OCP-1Z0-053-V13.02-685

685. In your test database:

-You are using Recovery Manager (RMAN) to perform incremental backups of your test database

-The test database is running in NOARCHIVELOG mode

-One of the data files is already upted

-All online redo log files are lost because of a media failure

Which option must you consider in this scenario?

A. Locking ing the database in ARCHVIELOG mode and then using incremental backup to recover the database

B. Using incremental backup to recover the damaged data file and then manually creating the online redo log files

C. Creating a new test database because the database is not recoverable du e to the fact that the database is configured in NOARCHIVELOG mode

D. Using incremental backups to recover the database by using the recover database noredo command and then using the RESETLOGS option to open the database.

Answer: C

Example 3-6 Recovering a NOARCHIVELOG Database

You can perform limited recovery of changes to a database running inNOARCHIVELOG Mode by applyingIncrementalBackups. The incremental backups must be consistent, like all backups of a database run inNOARCHIVELOGMode, so you cannot back up the database when it is open.

Assume that you run databaseprodInNOARCHIVELOGMode with a recovery catalog. You shut down the database consistently and make a level 0 backup of databaseprodTo tape on Sunday afternoon. You shut down the database consistently and make a level 1 differential incremental backup to tape at 3: 00 a.m. on Wednesday and Friday.

On Saturday, a media failureDestroys half the data filesAnd the online redo logs. BecauseThe online logs are lost, You must specifyNOREDOOption inRECOVERCommand. Otherwise, RMAN searches for the redo logs after applying the Friday incremental backup and issues an error message when it does not find them.

After connecting RMANprodAnd the catalog database, recover as follows:

Startup force nomount; restore controlfile; # restore control file from consistent backupALTER database mount; restore database; # restore data files from consistent backupRECOVER database noredo; # specify NOREDO because Online redo logs are lostAlter database open resetlogs;

The recovered database reflects only changes up through the time of the Friday incremental backup. Because there are no archived redo log files, there is no way to recover changes made after the incremental backup.