Thursday, February 5, 2009

Recovery : Redolog group (Current) :- without having backup

How to recover of currently dropped or crashed redo log without having any backup...
1) check the status through v$log
SQL> select group#,sequence#,bytes,archived,status from v$log;
2) check the log mode of database
SQL> select name,open_mode,log_mode from v$database;
3) create new controlfile and loss of data thats having within that corrupted group
SQL> alter database backup controlfile to trace as 'path for new ctl file';
4) use this above created controlfile and open the database with resetlog option

No comments:

Post a Comment