change redolog file name or format
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!
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 ..