RECOVER Clause

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

Syntax:

   ALTER DATABASE database_name RECOVER [AUTOMATIC] [FROM 'location'] option [PARALLEL parallel_clause]

   ALTER DATABASE database_name RECOVER MANAGED STANDBY DATABASE {TIMEOUT int|CANCEL [IMMEDIATE]}

Options

   [STANDBY] DATABASE UNTIL CANCEL
   [STANDBY] DATABASE UNTIL TIME date
   [STANDBY] DATABASE UNTIL CHANGE int
   [STANDBY] DATABASE USING BACKUP CONTROLFILE
   STANDBY TABLESPACE tablespace UNTIL [CONSISTENT WITH] CONTROLFILE
   STANDBY DATAFILE datafile UNTIL [CONSISTENT WITH] CONTROLFILE 
   LOGFILE 'filename'
   DATAFILE 'filename'
   TABLESPACE tablespace
   CONTINUE [DEFAULT]
   CANCEL

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

Related Commands:

DATABASE - ALTER DATABASE

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