Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

A.
The archived redo log files cannot be used.

B.
The archived redo log files will be overwritten.

C.
The archived redo log files are deleted automatically.

D.
The achieved redo log files should be moved to some other location.

E.
The archived redo log files are still maintained because the file names are unique.

Explanation:
The parameter %r represents the RESETLOGS identifier and changes every time a RESETLOGS operation occurs, ensuring that no filename collisions exists in the flash recovery area or an archived log file destination.



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I agree with the answer. E