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 *

Đồng Nai

Đồng Nai

%r – reset log: to avoid log name collision.

Reply

vin

vin

Hello,

A: arch_%t_%s_%r.arc
We must included %r

I checked the following options of archive log format:
>>
The following variables can be used in the format:

%s log sequence number

%S log sequence number, zero filled

%tthread number

%Tthread number, zero filled

%a activation ID

%d database ID

%r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database
<<

Thank
vin

Reply