which two recovery scenarios must you use the RESETLOGS…

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.)

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.)

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

B.
One control file copy is intact and damaged control file copies have to be restored to the default location.

C.
All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed
manually.

D.
All copies of the control file are damaged and the auto backed up control file is used for recovery.

E.
One control file copy is intact and damaged control file copies have to be restored to a non-default location.



Leave a Reply 0

Your email address will not be published. Required fields are marked *