Restore redo after oracle closes normally

Restore redo after oracle closes normally

[Oracle @ oracle-one RHYS] $ ls-ltrtotal 4898536-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo02.log-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo01.log-rw-r -----. 1 oracle oinstall 5251072 Aug 27 users01.dbf-rw-r -----. 1 oracle oinstall 524296192 Aug 27 arch_tbs01.dbf-rw-r -----. 1 oracle oinstall 209723392 Aug 27 statspack. dbf-rw-r -----. 1 oracle oinstall262152 192 Aug 27 undotbs3.dbf-rw-r -----. 1 oracle oinstall 1688215552 Aug 27 test. dbf-rw-r -----. 1 oracle oinstall 67117056 Aug 27 temp01.dbf-rw-r -----. 1 oracle oinstall 31465472 Aug 27 undotbs1.dbf-rw-r -----. 1 oracle oinstall 629153792 Aug 27 sysaux01.dbf-rw-r -----. 1 oracle oinstall 1457528832 Aug 27 system01.dbf-rw-r -----. 1 oracle oinstall 9846784 Aug 27 c Ontrol01.ctl-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo03.log [oracle @ oracle-one RHYS] $ mv redo01.log redo01.log _ bak [oracle @ oracle-one RHYS] $ sqlplus/as sysdbaSQL * Plus: release 11.2.0.1.0 Production on Tue Aug 27 17:15:07 2013 Copyright (c) 1982,200 9, Oracle. all rights reserved. connected to an idle instance. SQL> startupORACLE instance started. total System Global Area 405020672 bytes Fixed Size 2213816 bytesVariable Size 260048968 bytesDatabase Buffers 138412032 bytesRedo Buffers 4345856 bytesDatabase mounted. ORA-03113: end-of-file on communication channelProcess ID: 1935 Session ID: 1 Serial number: 5SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, data Mining and Real Application Testing option S [oracle @ oracle-one RHYS] $ view alert Log is as follows: Errors in file/opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_lgwr_1915.trc: ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log 'ora-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3 Errors in file/opt/app/oracle/diag/rdbms/rh Ys/RHYS/trace/RHYS_lgwr_1915.trc: ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log' ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3 Errors in file/opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_1935.trc: ORA-00313: open failed for members of log group 1 o F thread ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log' USER (ospid: 1935 ): terminating the instance due to error 3132013-08-27 17:15:22. 637000 + 08: 00 Instance terminated by USER, pid = 1935 adrci> SQL> startup mount; ORACLE instance started. total System Global Area 405020672 bytesFixed Size 2213816 bytesVariable Size 260048968 bytesDatabase Buffers 138412032 bytesRedo Buffers 434 5856 bytesDatabase mounted. SQL> select open_mode from v $ database; OPEN_MODE--------------------MOUNTEDSQL> select * from v $ log; GROUP # THREAD # SEQUENCE # bytes blocksize members arc status FIRST_CHANGE # BYTES NEXT_CHANGE # NEXT_TIME ---------- --- BYTES --------- ------------ --------- 1 742 52428800 512 1 YES INACTI VE 11303012 26-AUG-13 11355835 27-AUG-13 3 1 743 52428800 1 no current 512 27-AUG-13 2.8147E + 14 2 1 11355835 741 52428800 1 yes inactive 512 26-AUG-13 11265035 26-AUG-13SQL> SQL> alter database clear logfile group 1; database altered. SQL>! [Oracle @ oracle-one RHYS] $ ls-ltotal 4949740-rw-r -----. 1 oracle oinstall 524296192 Aug 27 arch_tbs01.dbf-rw-r -----. 1 oracle oinstall 9846784 Aug 27 control01.ctl-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo01.log-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo01.log _ bak-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo02.log-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo03.log-rw-r -----. 1 oracle oinstall 209723392 Aug 27 statspack. dbf-rw-r -----. 1 oracle oinstall 629153792 Aug 27 sysaux01.dbf-rw-r -----. 1 oracle oinstall 1457528832 Aug 27 system01.dbf-rw-r -----. 1 oracle oinstall 67117056 Aug 27 temp01.dbf-rw-r -----. 1 oracle oinstall 1688215552 Aug 27 test. dbf-rw-r -----. 1 oracle oinstall 31465472 Aug 27 undotbs1.dbf-rw-r -----. 1 oracle oinstall 262152192 Aug 27 undotbs3.dbf-rw-r -----. 1 oracle oinstall 5251072 Aug 27 17:20:32 users01.dbf [oracle @ oracle-one RHYS] $ sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Tue Aug 27 2013 Copyright (c) 1982,200 9, oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter database open; Database altered. SQL>