Home » RDBMS Server » Backup & Recovery » archive log format issue (10.2.0.1)
archive log format issue [message #557133] Sat, 09 June 2012 08:16 Go to next message
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

Re: archive log format issue [message #557167 is a reply to message #557133] Sat, 09 June 2012 16:19 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Check this link & Try to understand the meaning of archive format
Re: archive log format issue [message #557235 is a reply to message #557167] Mon, 11 June 2012 03:48 Go to previous messageGo to next message
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
Re: archive log format issue [message #557256 is a reply to message #557235] Mon, 11 June 2012 05:21 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It is because you are archiving to the Fast Recovery Area, using Oracle Managed Files. So Uncle Oracle takes over the file naming.
Re: archive log format issue [message #557326 is a reply to message #557256] Mon, 11 June 2012 21:59 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: How to manage your archived log
Next Topic: interoperability between RMAN and VSS snapshot backups
Goto Forum:
  


Current Time: Thu Mar 28 06:08:56 CDT 2024