In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?

You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?

You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?

A.
loss of one of the tablespaces

B.
loss of a system data file

C.
loss of one of the control files

D.
loss of a tempfile

E.
loss of the only member of an unarchived redo log group

F.
loss of a member from each redo log group



Leave a Reply 0

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