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
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