Which archived log file name format ensures this?

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?

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.
arch_%t_%s_%r.arc

B.
arch_%d_%s_.dbf

C.
arch_%t_%d.arc

D.
arch_%d.arc

E.
%t_%s.dbf

F.
arch_%t.arc

Show Hint

Leave a Reply 2

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

guaose

guaose

https://docs.oracle.com/cd/E18283_01/server.112/e17120/archredo004.htm

The following example shows a setting of LOG_ARCHIVE_FORMAT:

LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc

This setting will generate archived logs as follows for thread 1; log sequence numbers 100, 101, and 102; resetlogs ID 509210197. The identical resetlogs ID indicates that the files are all from the same database incarnation:

/disk1/archive/arch_1_100_509210197.arc,
/disk1/archive/arch_1_101_509210197.arc,
/disk1/archive/arch_1_102_509210197.arc

/disk2/archive/arch_1_100_509210197.arc,
/disk2/archive/arch_1_101_509210197.arc,
/disk2/archive/arch_1_102_509210197.arc

/disk3/archive/arch_1_100_509210197.arc,
/disk3/archive/arch_1_101_509210197.arc,
/disk3/archive/arch_1_102_509210197.arc

Reply