RECOVER

Recover a Database, Tablespace, Data or Log file.

Syntax:

   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

Key:

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

Related Commands:

ALTER DATABASE
Recovery - FAQ

Related Views:

  GLOBAL_NAME 
  DBA_DATA_FILES
  V$CONTROLFILE
  V$DATABASE
  V$DATAFILE
  V$LOG
  V$LOGFILE




Back to the Top

Simon Sheppard
SS64.com