December 2002
Intermediate to advanced
928 pages
85h 29m
English
Initiates media recovery on a database, tablespace, or datafile. You must be connected as SYSDBA, SYSOPER, or INTERNAL (INTERNAL is not supported beginning with Oracle9i) in order to use RECOVER. RECOVER is not supported in iSQL*Plus. The functionality that RECOVER implements can also be accomplished with Recovery Manager (see Chapter 15).
Do not use the RECOVER command unless you fully understand database recovery procedures.
RECOVER’s syntax changes frequently. The following syntax is valid for Oracle9i Release 2:
RECOVER {general | managed | END BACKUP}
general ::=
[AUTOMATIC] [FROM directory]
{ {full_database_recovery
|partial_database_recovery
|LOGFILE filename}
[recovery_option [recovery_option...]]
|CONTINUE [DEFAULT] | CANCEL}
full_database_recovery ::=
[STANDBY] DATABASE
[UNTIL {CANCEL | TIME datetime | CHANGE scn}]
[USING BACKUP CONTROLFILE]
or
[STANDBY] DATABASE
[USING BACKUP CONTROLFILE]
[UNTIL {CANCEL | TIME datetime | CHANGE scn}]
partial_database_recovery ::=
{TABLESPACE tablespace [, tablespace]...
| DATAFILE datafilename [, datafilename]...
| STANDBY {TABLESPACE tablespace [, tablespace]...
| DATAFILE datafilename [, datafilename]...}
UNTIL [CONSISTENT] [WITH] CONTROLFILE }
recovery_option ::=
{TEST | ALLOW blocks CORRUPTION
| PARALLEL [degree] | NOPARALLEL}
managed ::=
MANAGED STANDBY DATABASE
[ {NODELAY | [TIMEOUT] minutes
| CANCEL [IMMEDIATE] [NOWAIT]}
| [DISCONNECT [FROM SESSION] ] [FINISH [NOWAIT] ] ]