Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

RECOVER

Synopsis

The RECOVER command initiates media recovery on a database, a tablespace, or a datafile. You must be connected as SYSDBA or SYSOPER in order to use this command. The syntax shown here is for Oracle Database 10g.

Syntax

RECOVER {general | managed | bracket}

general ::= [AUTOMATIC] [FROM location]
            {full_recovery | partial_recovery | LOGFILE filename}
            [general_option [general_option...]]
managed ::= MANAGED STANDBY DATABASE {managed_recovery | cancel | finish}
bracket ::= {BEGIN BACKUP | END BACKUP}
full_recovery ::= [STANDBY]DATABASE [full_option [full_option...]]
partial_recovery ::= {partial_type | STANDBY partial_type}
                     UNTIL [CONSISTENT WITH] CONTROLFILE
general_option ::= {TEST | ALLOW integer CORRUPTION | parallel}
managed_recovery ::= managed_recovery_option [managed recovery option...]
cancel ::= CANCEL [IMMEDIATE] [WAIT | NOWAIT]
finish ::= [DISCONNECT [FROM SESSION]] [parallel]
           FINISH [SKIP [STANDBY LOGFILE]] [WAIT | NOWAIT]

full_option ::= {UNTIL {CANCEL | TIME datetime | CHANGE integer}
                | USING BACKUP CONTROLFILE}
partial_type ::= {TABLESPACE tablespace[, tablespace...]
                 | DATAFILE {filename | filenumber}[, filename | filenumber...]}
managed_recovery_option ::=
                     {{DISCONNECT [FROM SESSION] | TIMEOUT integer | NOTIMEOUT}
                     | {NODELAY | DEFAULT DELAY | DELAY integer}
                     | NEXT integer
                     | {EXPIRE integer | NO EXPIRE}
                     | parallel
                     | USING CURRENT LOGFILE
                     | UNTIL CHANGE integer
                     | THROUGH {[THREAD integer] SEQUENCE integer | ALL ARCHIVELOG | {ALL | LAST | NEXT} SWITCHOVER} ...