O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required