In your database, you may be forced to perform a recovery using the RESETLOGS option during
which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old
log files. Which archived log file name format ensures this?
A.
%t_%s.dbf
B.
arch_%t.arc
C.
arch_%d.arc
D.
arch_%t_%d.arc
E.
arch_%d_%s_.dbf
F.
arch_%t_%s_%r.arc
On a single node 9i instance the archive log mode is reset as follows:
…..
ALTER SYSTEM SET log_archive_format=’arch_%t_%s.arc’ SCOPE=spfile;
In Oracle 10g the LOG_ARCHIVE_START parameter and ARCHIVE LOG START command have been deprecated, so you will use the following code.
ALTER SYSTEM SET log_archive_dest_1=’location=/u01/oradata/MYSID/archive/’ SCOPE=spfile;
ALTER SYSTEM SET log_archive_format=’arch_%t_%s_%r.arc’ SCOPE=spfile;
To set the LOG_ARCHIVE_FORMAT initialization parameter, using %t to include the thread number as part of the file name, %s to include the log sequence number, and %r to include the resetlogs ID (a timestamp value represented in ub4).
Use capital letters (%T, %S, and %R) to pad the file name to the left with zeroes.