断电oracle恢复redo,oracle正常关闭下redo丢失恢复

[oracle@oracle-one RHYS]$ ls -ltr

total 4898536

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo02.log

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo01.log

-rw-r-----. 1 oracle oinstall 5251072 Aug 27 13:22 users01.dbf

-rw-r-----. 1 oracle oinstall 524296192 Aug 27 13:22 arch_tbs01.dbf

-rw-r-----. 1 oracle oinstall 209723392 Aug 27 13:22 statspack.dbf

-rw-r-----. 1 oracle oinstall 262152192 Aug 27 13:22 undotbs3.dbf

-rw-r-----. 1 oracle oinstall 1688215552 Aug 27 13:30 test.dbf

-rw-r-----. 1 oracle oinstall 67117056 Aug 27 13:33 temp01.dbf

-rw-r-----. 1 oracle oinstall 31465472 Aug 27 13:38 undotbs1.dbf

-rw-r-----. 1 oracle oinstall 629153792 Aug 27 13:40 sysaux01.dbf

-rw-r-----. 1 oracle oinstall 1457528832 Aug 27 13:40 system01.dbf

-rw-r-----. 1 oracle oinstall 9846784 Aug 27 13:40 control01.ctl

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:40 redo03.log

[oracle@oracle-one RHYS]$ mv redo01.log redo01.log_bak

[oracle@oracle-one RHYS]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 27 17:15:07 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 405020672 bytes

Fixed Size 2213816 bytes

Variable Size 260048968 bytes

Database Buffers 138412032 bytes

Redo Buffers 4345856 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 1935

Session ID: 1 Serial number: 5

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracle-one RHYS]$

查看alert日志如下：

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 1

ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

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 1

ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional 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 of thread

ORA-00312: online log 1 thread 1: '/opt/app/oracle/RHYS/redo01.log'

USER (ospid: 1935): terminating the instance due to error 313

2013-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 bytes

Fixed Size 2213816 bytes

Variable Size 260048968 bytes

Database Buffers 138412032 bytes

Redo Buffers 4345856 bytes

Database mounted.

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

MOUNTED

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------

1 1 742 52428800 512 1 YES INACTIVE 11303012 26-AUG-13 11355835 27-AUG-13

3 1 743 52428800 512 1 NO CURRENT 11355835 27-AUG-13 2.8147E+14

2 1 741 52428800 512 1 YES INACTIVE 11265035 26-AUG-13 11303012 26-AUG-13

SQL>

SQL> alter database clear logfile group 1;

Database altered.

SQL> !

[oracle@oracle-one RHYS]$ ls -l

total 4949740

-rw-r-----. 1 oracle oinstall 524296192 Aug 27 17:15 arch_tbs01.dbf

-rw-r-----. 1 oracle oinstall 9846784 Aug 27 17:20 control01.ctl

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 17:20 redo01.log

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo01.log_bak

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo02.log

-rw-r-----. 1 oracle oinstall 52429312 Aug 27 17:15 redo03.log

-rw-r-----. 1 oracle oinstall 209723392 Aug 27 17:15 statspack.dbf

-rw-r-----. 1 oracle oinstall 629153792 Aug 27 17:15 sysaux01.dbf

-rw-r-----. 1 oracle oinstall 1457528832 Aug 27 17:15 system01.dbf

-rw-r-----. 1 oracle oinstall 67117056 Aug 27 13:33 temp01.dbf

-rw-r-----. 1 oracle oinstall 1688215552 Aug 27 17:15 test.dbf

-rw-r-----. 1 oracle oinstall 31465472 Aug 27 17:15 undotbs1.dbf

-rw-r-----. 1 oracle oinstall 262152192 Aug 27 17:15 undotbs3.dbf

-rw-r-----. 1 oracle oinstall 5251072 Aug 27 17:15 users01.dbf

[oracle@oracle-one RHYS]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 27 17:20:32 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database open;

Database altered.

SQL>