Oracle丟失active或current記錄檔的恢複操作過程

丟失活動或當前記錄檔的恢複
Oracle通過記錄檔保證提交成功的資料不丟失,可是在故障中,使用者可能損失了當前的(current)記錄檔.這又分為兩種情況:此時資料是正常關閉的和此時資料庫是異常關閉.
1.在損失當前日誌時,資料庫是正常關閉的.
由於關閉資料庫前,oracle會執行全面檢查點,當前日誌在執行個體恢複中可以不再需要.
下面進行測試(資料庫運行在非歸檔模式下).在oracle9i及以後版本中,是無法對當前日誌進行clear,需要通過until cancel恢複後再以resetlogs方式開啟
[oracle@jingyong ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 7 00:39:59 2013

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$version where rownum<2;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
        3        ONLINE
/u01/app/oracle/product/10.2.0/oradata/jingyong/redo03.log
NO

        2        ONLINE
/u01/app/oracle/product/10.2.0/oradata/jingyong/redo02.log
NO

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---

        1        ONLINE
/u01/app/oracle/product/10.2.0/oradata/jingyong/redo01.log
NO

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> !mv /u01/app/oracle/product/10.2.0/oradata/jingyong/redo* /u01/app/oracle

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'/u01/app/oracle/product/10.2.0/oradata/jingyong/redo01.log'

SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database clear logfile group 2;

Database altered.

SQL> alter database clear logfile group 3;
alter database clear logfile group 3
*
ERROR at line 1:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/product/10.2.0/oradata/jingyong/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------
        1          1          0  52428800          1 NO  UNUSED
            0 06-JAN-13

        3          1          0  52428800          1 NO  CLEARING_CURRENT
      914164 06-JAN-13

        2          1          0  52428800          1 NO  UNUSED
      914157 06-JAN-13

SQL> recover database until cancel;
Media recovery complete.

SQL> alter database open resetlogs;

Database altered.

SQL>

1 2 3 下一頁