parameter achive_log_format

[Former Member]

Hi Gurus,

My parameter achive_log_format is ARC%S_%R.%T.

But now the archives have reached more than 100000 and i need to change the archive format for this.

Please suggest the new archive format for above 100000 archives.

Regards

Tushar

reg

[Former Member]

Check this note: [132551 - Overflow log sequence numbers on NT|https://service.sap.com/sap/support/notes/132551]

Cheers Michael

[former_member186775]

Hi Pankaj,

As you said ..you want to change the format of log_archive you

can do the following way.goto the sql prompt and there connect

as sysdba.check as

show parameter spfile; if you get the file location and file name it

means you have the spfile created.else create the file as

sql>create spfile from pfile;

now you can change the format by the following statement

sql>alter system set log_archive_format= '%d%s' scope=spfile;

now restart the system.

this is one of the way .Hope this helps.

Regards,

Manjula.U