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

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

0 View this answer in context

Helpful Answer

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