RECOVER Clause

Perform media recovery - the RECOVER clause must appear as part of an ALTER DATABASE RECOVER command.

Syntax:

   ALTER DATABASE database_name RECOVER [AUTOMATIC]
     [FROM 'location'] options [execution_clause]

   ALTER DATABASE database_name RECOVER CONTINUE [DEFAULT]

   ALTER DATABASE database_name RECOVER CANCEL

Options:

   LOGFILE 'logfilename'
   DATAFILE 'filename'
   STANDBY DATAFILE datafile UNTIL [CONSISTENT WITH] CONTROLFILE 

   TABLESPACE tablespace
   STANDBY TABLESPACE tablespace UNTIL [CONSISTENT WITH] CONTROLFILE

   [STANDBY] DATABASE UNTIL CANCEL
   [STANDBY] DATABASE UNTIL TIME date
   [STANDBY] DATABASE UNTIL CHANGE int
   [STANDBY] DATABASE USING BACKUP CONTROLFILE

Execution_clause:
   TEST
   ALLOW int CORRUPTION
   [PARALLEL parallel_clause]

The recovery option DATABASE implies a full recovery, while the TABLESPACE or DATAFILE options imply a partial recovery.

It is possible to include more than one DATAFILE or TABLESPACE in a single command (just separate with commas).

Related Commands:

DATABASE - ALTER DATABASE
RECOVER MANAGED STANDBY standby_recover_clause

Related Views:

DBA_DATA_FILES
DBA_TABLESPACES
V$ARCHIVE
V$DATABASE
V$DATAFILE
V$INSTANCE
V$INSTANCE_RECOVERY
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_PROGRESS
V$RECOVERY_STATUS
V$RECOVER_FILE
V$TABLESPACE