Drop and Recreate Online Redolog Files
- Posted by Arjun Raja
- On July 29, 2009
- 0 Comments
Method to drop and recreate online redolog files with 2 members to each group. Firstly ORACLE will never allow you to drop the current ONLINE redolog file – Ex : SQL> select GROUP#,THREAD#,STATUS from v$log; GROUP# THREAD# STATUS ———- ———- —————- 1 1 CURRENT 2 1 UNUSED 3 1 INACTIVE 4 1 INACTIVE SQL> alter […]
Read More