Recover a Database, Tablespace, Data or Log file.
RECOVER [AUTOMATIC] [FROM 'location'] [STANDBY] DATABASE [UNTIL CANCEL] [UNTIL TIME date] [UNTIL CHANGE int] [USING BACKUP CONTROLFILE] RECOVER [AUTOMATIC] [FROM 'location'] TABLESPACE tablespace [, tablespace2...] RECOVER [AUTOMATIC] [FROM 'location'] STANDBY TABLESPACE tablespace [, tablespace2...] UNTIL [CONSISTENT] [WITH] CONTROLFILE RECOVER [AUTOMATIC] [FROM 'location'] DATAFILE 'filename' [, filename2...] RECOVER [AUTOMATIC] [FROM 'location'] STANDBY DATAFILE 'filename' [, filename2,...] UNTIL [CONSISTENT] [WITH] CONTROLFILE RECOVER [AUTOMATIC] [FROM 'location'] LOGFILE 'filename' RECOVER [AUTOMATIC] [FROM 'location'] CONTINUE [DEFAULT] RECOVER [AUTOMATIC] [FROM 'location'] CANCEL RECOVER MANAGED STANDBY DATABASE TIMEOUT integer RECOVER MANAGED STANDBY DATABASE CANCEL [IMMEDIATE]
On a parallel server you can add to any of the above:
PARALLEL Parallel Clause
AUTOMATIC Automatically generate the name of the next archived redo log file needed to continue the recovery operation. FROM location The location from which the archived redo log file group is read. STANDBY Recover the standby database using the control file and archived redo log files copied from the primary database. The standby database must be mounted but not open. UNTIL CANCEL Partial recovery. Recovery proceeds by prompting you with the suggested filenames of archived redo log files, and recovery completes when you specify CANCEL instead of a filename. UNTIL CHANGE integer An incomplete, change-based recovery. integer is the System Change Number (SCN) following the last change you wish to recover. UNTIL TIME date Partial time-based recovery. Use the format: 'YYYY-MM-DD:HH24:MI:SS' UNTIL [CONSISTENT] [WITH] CONTROLFILE Recover an old standby datafile or tablespace using the current standby database control file. TABLESPACE tablespace Recover a tablespace. You may recover up to 16 tablespaces in one statement. CONTINUE [DEFAULT] Continues multi-instance recovery after it has been interrupted to disable a thread. Continues recovery using the redo log file that Oracle would automatically generate if no other logfile were specified. This option is equivalent to specifying AUTOMATIC, except that Oracle does not prompt for a filename. CANCEL Terminates cancel-based recovery. MANAGED STANDBY DATABASE Sustained standby recovery mode. TIMEOUT integer The number of MINUTES = the wait period of a sustained recovery operation.
The RECOVER command is available in Server Manager/SQL*Plus,
this is recommended for media recovery in preference to the syntax ALTER DATABASE
RECOVER... (provided for backwards compatibility with older versions)
"All those who drink of this remedy recover in a short time, except those whom it does not help, who die. Therefore, it is obvious that it fails only in incurable cases." - Galen (circa 100 A.D.)
Recovery - FAQ
GLOBAL_NAME DBA_DATA_FILES V$CONTROLFILE V$DATABASE V$DATAFILE V$LOG V$LOGFILE