Renaming/Dropping and recreating online redo logs and Standby logfiles
After we created Primary and Standby DB’s we realize what we haven’t put file names as per our standard. So I got the task to rename both, online redo logs and standby logs. This what I did : 1. Following is the script to identify all log files we have SELECT GROUP#, BYTES, ‘ONLINE’ AS…