Home » RDBMS Server » Backup & Recovery » question regarding archived log files format.
question regarding archived log files format. [message #247277] Mon, 25 June 2007 06:01 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
dear all,
i have a question regarding archived logfiles names format, for me i tried to change the archived logfile name format
ALTER SYSTEM SET log_archive_format='LOGSEQUENCE_%s__resetlogs_%r__thread_%t'scope=spfile;
shutdown immediate;
startup;

or
ALTER SYSTEM SET log_archive_format='LOGSEQUENCE_%s__resetlogs_%r__thread_%t_%d'scope=spfile;
shutdown immediate;
startup;

but the archived logfiles name are still has the same format and it appears like this:
O1_MF_1_1_37YPSGQX_.ARC ,O1_MF_1_8_37Z77O00_.ARC
only the last part is getting changed with sequence number ,

should the archived logfile names change according to the changing of log_archive_format parameter or it affects another thing?

thanks in advance.

[Updated on: Mon, 25 June 2007 06:02]

Report message to a moderator

Re: question regarding archived log files format. [message #247306 is a reply to message #247277] Mon, 25 June 2007 08:25 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Are you using ASM?

If so, it is likely that your LOG_ARCHIVE_DEST parameter is set to an incomplete ASM filename like +dg1.

To fix, set LOG_ARCHIVE_DEST to an ASM directory like +dg1/archlogs/.
Re: question regarding archived log files format. [message #247545 is a reply to message #247277] Tue, 26 June 2007 05:58 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
i am not using ASM,
thanks frank for reading.
Re: question regarding archived log files format. [message #247637 is a reply to message #247545] Tue, 26 June 2007 11:05 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
did you check
weather Oracle support the long format for Archivelogs?

'LOGSEQUENCE_%s__resetlogs_%r__thread_%t_%d' >>seems too long.
Re: question regarding archived log files format. [message #247692 is a reply to message #247545] Tue, 26 June 2007 21:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It appears that you are using the flash_recovery_area, therefore, you can not specify the LOG_ARCHIVE_FORMAT for the archive logs managed in the FRA.
icon13.gif  Re: question regarding archived log files format. [message #247751 is a reply to message #247277] Wed, 27 June 2007 02:11 Go to previous messageGo to next message
pratik25
Messages: 4
Registered: June 2007
Location: HYDERABAD
Junior Member
TRY TO alter system archive log start to '/u01/app/oracle/product/9.2.0/dbs/arch2' SCOPE =SPFILE; (YOUR LOCATIN)IF WRON THEN DONT MIN I AM VERY NEW TO ORACLE)
Re: question regarding archived log files format. [message #247769 is a reply to message #247692] Wed, 27 June 2007 02:55 Go to previous message
prince973
Messages: 37
Registered: November 2006
Member
ebrian wrote on Wed, 27 June 2007 05:46
It appears that you are using the flash_recovery_area, therefore, you can not specify the LOG_ARCHIVE_FORMAT for the archive logs managed in the FRA.


THANKS
Previous Topic: stored RMAN script
Next Topic: Choosing 3-rd party backup software for Oracle
Goto Forum:
  


Current Time: Thu Dec 08 14:10:33 CST 2016

Total time taken to generate the page: 0.08538 seconds