OraFAQ Forum: Backup & Recovery » question regarding archived log files format.

Home » RDBMS Server » Backup & Recovery » question regarding archived log files format.

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

question regarding archived log files format. [message #247277]

Mon, 25 June 2007 06:01

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

Frank Naude
Messages: 4579
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/.

Report message to a moderator

Re: question regarding archived log files format. [message #247545 is a reply to message #247277]

Tue, 26 June 2007 05:58

prince973
Messages: 37
Registered: November 2006

Member

i am not using ASM,
thanks frank for reading.

Report message to a moderator

Re: question regarding archived log files format. [message #247637 is a reply to message #247545]

Tue, 26 June 2007 11:05

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.

Report message to a moderator

Re: question regarding archived log files format. [message #247692 is a reply to message #247545]

Tue, 26 June 2007 21:46

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.

Report message to a moderator

Re: question regarding archived log files format. [message #247751 is a reply to message #247277]

Wed, 27 June 2007 02:11

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)

Report message to a moderator

Re: question regarding archived log files format. [message #247769 is a reply to message #247692]

Wed, 27 June 2007 02:55

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 17:46:51 CDT 2024