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