Name
RECOVER
Synopsis
Recovers a database or one of its physical components. During the recovery process, either incremental backups (the first choice) or archived redo log files are applied to recover the datafiles. For Oracle8i, this command must be executed from within the RUN command.
Oracle9i syntax
RECOVER [DEVICE TYPEdeviceSpecifier
[,deviceSpecifier
]...] recoverObject [recoverOptionList
]; recoverObject := { DATABASE [untilClause
| [untilClause
] 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
RECOVER recoverObject [recoverOptionList
];
RecoverOptionList :=
{ DELETE ARCHIVELOG
| CHECK READONLY
| NOREDO
| CHECK LOGICAL
}
[, { DELETE ARCHIVELOG
| CHECK READONLY
| NOREDO
| CHECK LOGICAL
}
] ...
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 files 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 ...
Get Oracle RMAN Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.