What is a complete recovery?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a complete recovery?

Rating:

A complete recovery is a type of media recovery in which all applicable redo data (data stored in online and archived redo logs) is applied to a restored backup in order to recover the lost data. A database must be running in ARCHIVELOG mode in order to perform a complete recovery. A complete recovery is performed when a media failure damages some or all of the data files or the control file. Only damaged data files need to be restored when performing a complete recovery. The restored files are recovered by applying all redo data generated after the restored backup was taken. Applying the redo data to the files makes them consistent with the rest of the database. While using Recovery Manager (RMAN) to perform a complete recovery, incremental backups can also be applied to the restored backup.

In a complete recovery, the restored backup is recovered up to the current system change number (SCN). When performing a complete recovery, the whole database can be recovered at once, or tablespaces or data files can be individually recovered. Unlike an incomplete recovery, a database does not need to be opened with the RESETLOGS option after a complete recovery. Therefore, some data files of the database can be recovered at one time and the remaining data files later.

Rating: