Recover Redo01.dbf
============================
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>SELECT GROUP#, ARCHIVED,STATUS FROM V$LOG;
1 NO CURRENT
2 YES INACTIVE
3 YES INACTIVE
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
DROP logfile Group
====================
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
(Remove redo01.log manualy)
Create Logfile Group
====================
SQL>ALTER DATABASE ADD LOGFILE GROUP 1 ('/opt/app/oracle/oradata/scdcc/redo01.log') size 50000K;
SQL>ALTER DATABASE OPEN;
No comments:
Post a Comment