RECOVER Clause

Perform media recovery - the RECOVER clause must appear as part of an ALTER DATABASE RECOVER command.

Syntax:

   ALTER DATABASE database_name RECOVER [AUTOMATIC]
     [FROM 'location'] options [execution_clause]

   ALTER DATABASE database_name RECOVER CONTINUE [DEFAULT]

   ALTER DATABASE database_name RECOVER CANCEL

Options (full recovery):

   [STANDBY] DATABASE UNTIL CANCEL
   [STANDBY] DATABASE UNTIL TIME date
   [STANDBY] DATABASE UNTIL CHANGE int
   [STANDBY] DATABASE UNTIL CONSISTENT

   [STANDBY] DATABASE USING BACKUP CONTROLFILE
   [STANDBY] DATABASE SNAPSHOT TIME date


Options (partial recovery):

   TABLESPACE tablespace [,tablespace...]
   LOGFILE 'logfilename'
   DATAFILE 'filename' [,'filename'...]
   DATAFILE filenunber [,filenunber...]
   STANDBY DATAFILE datafile UNTIL [CONSISTENT WITH] CONTROLFILE 
   STANDBY TABLESPACE tablespace UNTIL [CONSISTENT WITH] CONTROLFILE

Execution_clauses:

   TEST
   ALLOW int CORRUPTION
   [PARALLEL parallel_clause]

The recovery option DATABASE implies a full recovery, while the TABLESPACE or DATAFILE options imply a partial recovery.

It is possible to include more than one DATAFILE or TABLESPACE in a single command (just separate with commas).

Related Commands:


DATABASE - ALTER DATABASE
RECOVER MANAGED STANDBY standby_recover_clause

Related Views:

DBA_DATA_FILES
DBA_TABLESPACES
V$ARCHIVE
V$DATABASE
V$DATAFILE
V$INSTANCE
V$INSTANCE_RECOVERY
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_PROGRESS
V$RECOVERY_STATUS
V$RECOVER_FILE
V$TABLESPACE


© Copyright SS64.com 1999-2014
Some rights reserved