nerdexam
Oracle

1Z0-062 · Question #350

In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery…

The correct answer is C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is D. All copies of the control file are damaged and the auto backed up control file is used for. The RESETLOGS option is mandatory when opening a database after a recovery scenario that requires creating a new database incarnation, such as when all control files are lost and a new one is created or restored from an old backup.

Performing Backup and Recovery

Question

In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

Options

  • AOne control file copy is intact so the spfile is changed to refer to only one copy.
  • BOne control file copy is intact and damaged control file copies have to be restored to the
  • CAll copies of the control file are damaged and the CREATE CONTROLFILE statement is
  • DAll copies of the control file are damaged and the auto backed up control file is used for
  • EOne control file copy is intact and damaged control file copies have to be restored to a non-

How the community answered

(36 responses)
  • A
    6% (2)
  • B
    28% (10)
  • C
    56% (20)
  • E
    11% (4)

Why each option

The `RESETLOGS` option is mandatory when opening a database after a recovery scenario that requires creating a new database incarnation, such as when all control files are lost and a new one is created or restored from an old backup.

AOne control file copy is intact so the spfile is changed to refer to only one copy.

If at least one control file copy is intact, the database can be recovered without changing its current incarnation, so `RESETLOGS` is not required.

BOne control file copy is intact and damaged control file copies have to be restored to the

If at least one control file copy is intact, the database's current incarnation is preserved, and `RESETLOGS` is not required even if other damaged control files are restored.

CAll copies of the control file are damaged and the CREATE CONTROLFILE statement isCorrect

If all copies of the control file are damaged, a new control file must be created using the `CREATE CONTROLFILE` statement, which signifies a new database incarnation, thus requiring the database to be opened with the `RESETLOGS` option.

DAll copies of the control file are damaged and the auto backed up control file is used forCorrect

When all control file copies are damaged and an auto-backed up control file is restored, the database must be opened with `RESETLOGS` because the restored control file might not have the exact same log sequence number as the current online redo logs, necessitating a reset of the log sequence.

EOne control file copy is intact and damaged control file copies have to be restored to a non-

If at least one control file copy is intact, the database's current incarnation is preserved, and `RESETLOGS` is not required, regardless of whether damaged copies are restored to the same or a different location.

Concept tested: Oracle RMAN control file recovery and RESETLOGS

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/performing-complete-recovery.html#GUID-E5367A89-BB7F-4B85-802F-43A5D4404CC8

Topics

#control file recovery#media failure#ARCHIVELOG mode#RESETLOGS

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice