OraFAQ Forum: Backup & Recovery » archive log format issue

Home » RDBMS Server » Backup & Recovery » archive log format issue (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

archive log format issue [message #557133]

Sat, 09 June 2012 08:16

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
The log_archive_format parameter is set to %t_%s_%r.dbf,but the archive log is generate as o1_mf_1_10_7x6lby27_.arc, why?

SQL> show parameters log_archive_format;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      %t_%s_%r.dbf

[oracle@hxl 2012_06_09]$ ls -lr
total 93468
-rw-r----- 1 oracle oinstall 51229184 Jun  9 10:00 o1_mf_1_9_7x5ckqbv_.arc
-rw-r----- 1 oracle oinstall 43131392 Jun  9 09:01 o1_mf_1_8_7x581vgo_.arc
-rw-r----- 1 oracle oinstall    74240 Jun  9 21:06 o1_mf_1_11_7x6lksyp_.arc
-rw-r----- 1 oracle oinstall  1131008 Jun  9 21:02 o1_mf_1_10_7x6lby27_.arc

Report message to a moderator

Re: archive log format issue [message #557167 is a reply to message #557133]

Sat, 09 June 2012 16:19

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Check this link & Try to understand the meaning of archive format

Report message to a moderator

Re: archive log format issue [message #557235 is a reply to message #557167]

Mon, 11 June 2012 03:48

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
The reason maybe is the parameters LOG_ARCHIVE_DEST is set to null, can you confirm?

Oracle Doc Say:
The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter

Report message to a moderator