Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

change redolog file name or format

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
Former Member replied


Login to the database after logging into ora<SID>

sqlplus "/as sysdba"

give the following command

SQL> show parameter log_archive_format





log_archive_format string %t_%s_%r.dbf

you will get the result like this ..


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question