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