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 TYPE deviceSpecifier
    [, deviceSpecifier]...] 
recoverObject [recoverOptionList];

recoverObject :=
{ DATABASE 
  [ untilClause
  | [untilClause] 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
   }
] ...

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.