Oracle in a Nutshell

Name

RECOVER

Synopsis

Oracle9i syntax:

RECOVER [DEVICE TYPE deviceSpecifier     [, deviceSpecifier]...] 
recoverObject [recoverOptionList];

recoverObject :=
{ DATABASE 
  [ until
                          | [until] SKIP [FOREVER] TABLESPACE 
    [']tablespace_name['] [, [']tablespace_name['] ...]
  ]
| TABLESPACE [']tablespace_name[']
  [, [']tablespace_name['] ...]
| DATAFILE datafileSpec [, datafileSpec ...]
}

recoverOptionList :=
{ DELETE ARCHIVELOG 
| CHECK READONLY 
| NOREDO 
| CHECK LOGICAL 
| { FROM TAG | ARCHIVELOG TAG } [=] [']tag_name[']
} 
[, { DELETE ARCHIVELOG 
   | CHECK READONLY 
   | NOREDO 
   | CHECK LOGICAL 
   | { FROM TAG | ARCHIVELOG TAG } [=] [']tag_name['] 
   }
]...

Oracle8i syntax:

RECOVER recoverObject [recoverOptionList];

recoverOptionList :=
{ DELETE ARCHIVELOG 
| CHECK READONLY 
| NOREDO 
| CHECK LOGICAL
}
[, { DELETE ARCHIVELOG
   | CHECK READONLY
   | NOREDO
   | CHECK LOGICAL
   }
] ...

Recovers a database or one of its physical components. This command uses either incremental backups, if available, or archived redo log files to recover the datafiles. For Oracle8i, you must execute this command from within the RUN command.

Keywords

DELETE ARCHIVELOG

Removes archived redo log files that are no longer necessary.

CHECK READONLY

Excludes read-only tablespaces from the recovery process if their datafiles are current.

NOREDO

Forces the recovery to be performed using only incremental backups. No archived redo log files are applied. This option is valid when recovering a database operating in NOARCHIVELOG mode.

CHECK LOGICAL

Checks database for ...