O'Reilly logo

Oracle SQL: the Essential Reference by David C. Kreines

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

RECOVER
RECOVER {[AUTOMATIC] [FROM location]
          {[STANDBY] DATABASE 
          [UNTIL {CANCEL | CHANGE change_number | TIME time} |
              USING BACKUP CONTROLFILE |                 
           [STANDBY] DATAFILE filename[,filename ...] 
             [UNTIL [CONSISTENT [WITH] CONTROLFILE |
           [STANDBY] TABLESPACE tablespace[,tablespace ...] 
             [UNTIL [CONSISTENT [WITH] CONTROLFILE |
           TABLESPACE tablespace[,tablespace ...] |
           DATAFILE filename[,filename ...] |
           LOGFILE filename | 
           CONTINUE [DEFAULT] |
           CANCEL
          } |
          MANAGED STANDBY DATABASE {TIMEOUT integer | CANCEL [IMMEDIATE]}
       }
 [PARALLEL integer | NOPARALLEL]

Performs media recovery on a database, tablespace, datafile, or logfile. This command is intended for DBAs.

Keywords

AUTOMATIC

Specifies that during a recovery operation, the name of the next required archived log file will be automatically generated using the LOG_ARCHIVE_DEST (or LOG_ARCHIVE_DEST_1) and LOG_ARCHIVE_FORMAT parameters from the INIT.ORA initialization file. If this keyword is omitted and LOGFILE is not specified, the user will be prompted for the name of each archived log file as required.

FROM

Specifies the location of archived log files to be read. location must be provided in an operating system-dependent form (typically a fully qualified directory name), and if this keyword is specified, the value of location overrides the value of the LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_1 parameters in the INIT.ORA file.

STANDBY

Specifies that the standby database, which must be mounted and not open, will be recovered using the control file, ...

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