December 2002
Intermediate to advanced
928 pages
85h 29m
English
RECOVER
Oracle9i syntax:
RECOVER [DEVICE TYPEdeviceSpecifier[,deviceSpecifier]...]recoverObject[recoverOptionList];recoverObject:= { DATABASE [until| [until] SKIP [FOREVER] TABLESPACE [']tablespace_name['] [, [']tablespace_name['] ...] ] | TABLESPACE [']tablespace_name['] [, [']tablespace_name['] ...] | DATAFILEdatafileSpec[,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:
RECOVERrecoverObject[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.
Removes archived redo log files that are no longer necessary.
Excludes read-only tablespaces from the recovery process if their datafiles are current.
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.
Checks database for ...