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
Correct answer is C