on 05-24-2011 3:56 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.