You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

Question

Options

• AYou can perform complete recovery by using the command:
• BYou can perform incomplete recovery by using the command:
• COnly consistent backups can be used for restoring a database in NOARCHIVELOG mode.
• DMedia recovery is possible in most cases.

• A
  7% (4)
• B
  76% (45)
• D
  17% (10)

Explanation

https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841 Recovering a NOARCHIVELOG Database with Incremental Backups Restoring a database running in NOARCHIVELOG mode is similar to restoring a database in ARCHIVELOG mode. The main differences are: - Only consistent backups can be used in restoring a database in NOARCHIVELOG mode. - Media recovery is not possible because no archived redo logs exist. You can perform limited recovery of changes to a database running in NOARCHIVELOG mode by applying incremental backups. The incremental backups must be consistent, like all backups of a database run in NOARCHIVELOG mode, so you cannot make backups of the database when it is open. When you are recovering a NOARCHIVELOG database, specify the NOREDO option on the RECOVER command to indicate that RMAN does not attempt to apply archived redo logs. Otherwise, RMAN returns an error. To recover a NOARCHIVELOG database with incremental backups: 1.After connecting to the target database and the recovery catalog, place the database in a STARTUP FORCE MOUNT 2.Restore and recover the database. For example, you can perform incomplete recovery with the following commands: RESTORE DATABASE FROM TAG "consistent_whole_backup"; RECOVER DATABASE NOREDO; 3.Open the database with the RESETLOGS option. For example, enter the following command: ALTER DATABASE OPEN RESETLOGS;

No community discussion yet for this question.