Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

A.
LOG_ARCHIVE_DEST

B.
LOG_ARCHIVE_TRACE

C.
LOG_ARCHIVE_FORMAT

D.
LOG_ARCHIVE_CONFIG

E.
LOG_ARCHIVE_DEST_10

F.
LOG_ARCHIVE_LOCAL_FIRST

Explanation:
If the COMPATIBLE initialization parameter is set to 10.0 or higher, the database requires the specification of resetlogs ID (%r) when you include the LOG_ARCHIVE_FORMAT parameter. The default for this parameter is operating system dependent. For example, this is the default format for UNIX:
LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf
The incarnation of a database changes when you open it with the RESETLOGS option. Specifying %r causes the database to capture the resetlogs ID in the archive log file name, enabling you to more
easily perform recovery from a backup of a previous database incarnation.
REF.: Oracle(r) 10g Administrator Guide, 7-7



Leave a Reply 1

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


seenagape

seenagape

Correct answer is C