change redolog file name or format

[Former Member]

hi experts,

I would like to know how I can change the filename format for our redolog files. Can someone tell me of the exact directory and filename for this requirement? I have to change the parameter log_archive_format.

Thanks in advance!

[Former Member · Accepted solution]

Hi,

1. DO SQL> archive log list;

2. If archiving is switch on swith off.

3. Reset the parameter log_archive_format by the following command

alter system reset log_archive_format scope=both;

4. Change the path by the following command

alter system set log_archive_format=<desired value> scope = both;

5. shutdown immediate

6. startup mount

7. enable archiving

alter database archivelog;

8. alter database open;

9 test by generating a archive log file

alter system swith logfile;

10 check the contents of your oraarch directory

[Former Member · Accepted solution]

hi,

what command can i use to know the current value of the parameter log_archive_format? Because in the init.ora file, it seems doesnt match the filename generated.

Thank you

[Former Member · Accepted solution]

Hi,

Login to the database and give

show parameter log

or you can go to ST04 -> detail analysis -> v$values -> v$parameters and search for the parameter

[Former Member · Accepted solution]

hi,

detailed analysis of what particular directory? under what directory? or do you know any syntax to display? select * from?? for instance.

Thank you

[Former Member · Accepted solution]

Hi,

Login to the database after logging into ora<SID>

sqlplus "/as sysdba"

give the following command

SQL> show parameter log_archive_format

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_format string %t_%s_%r.dbf

you will get the result like this ..

Deepthi

[Former Member · Accepted solution]

Thanks! This thread solved my problem, Changed the parameter log_archive_format in the init<SID>.ora file that is in use.

[sunny_pahuja2]

Hi,

As per SAP recommendation, offline redo log files should have format %t_%s_%r.dbf which is govern by the parameter log_archive_format. Same you can set in spfile/pfile.

Thanks

Sunny

[Former Member]

hi sunny,

Im under location E:\oracle\<SID>\102\admin\sample\pfile and filename is inismpl.ora. the parameter log_archive_format is starting with a '#' character does it mean that it is commented out? im new to these sorry for that question. and also, am I in the right directory?

Thank you