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 (full recovery):

   [STANDBY] DATABASE UNTIL CANCEL
   [STANDBY] DATABASE UNTIL TIME date
   [STANDBY] DATABASE UNTIL CHANGE int
   [STANDBY] DATABASE UNTIL CONSISTENT

   [STANDBY] DATABASE USING BACKUP CONTROLFILE
   [STANDBY] DATABASE SNAPSHOT TIME date

Options (partial recovery):

   TABLESPACE tablespace [,tablespace...]
   LOGFILE 'logfilename'
   DATAFILE 'filename' [,'filename'...]
   DATAFILE filenunber [,filenunber...]
   STANDBY DATAFILE datafile UNTIL [CONSISTENT WITH] CONTROLFILE 
   STANDBY TABLESPACE tablespace UNTIL [CONSISTENT WITH] CONTROLFILE

Execution_clauses:

   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 Oracle Commands:

DATABASE - ALTER DATABASE
RECOVER MANAGED STANDBY standby_recover_clause