oracle手工完全恢複（二） 介質失敗，丟失大部分資料檔案

案例1：recover database （介質失敗，丟失大部分資料檔案）

解決方案：需要做介質恢複，先restore丟失的資料檔案，然後recover database，起庫。

（1）類比環境

05:45:49 SQL> select * from test;

ID

----------

1

2

3

05:45:52 SQL> insert into test values (4);

1 row created.

05:46:01 SQL> commit;

Commit complete.

05:46:02 SQL> insert into test values (5);

1 row created.

05:46:32 SQL> commit;

Commit complete.

05:46:34 SQL> insert into test values (6);

1 row created.

05:46:48 SQL> commit;

Commit complete.

05:46:49 SQL> insert into test values (7);

1 row created.

05:47:15 SQL> commit;

Commit complete.

05:46:08 SQL> select * from v$log;

本文URL地址：http://www.bianceng.cn/database/Oracle/201410/45392.htm

GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM

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

1          1         38   52428800          1 NO  CURRENT                1187992 16-AUG-11

2          1         36   52428800          1 YES INACTIVE               1184326 16-AUG-11

3          1         37   52428800          1 YES INACTIVE               1187989 16-AUG-11

05:46:13 SQL> alter system switch logfile;

System altered.

05:46:43 SQL> alter system archive log current;

System altered.

05:46:58 SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM

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

1          1         38   52428800          1 YES ACTIVE                 1187992 16-AUG-11

2          1         39   52428800          1 YES ACTIVE                 1188675 16-AUG-11

3          1         40   52428800          1 NO  CURRENT                1188689 16-AUG-11

05:47:03 SQL> alter system archive log current;

System altered.

05:47:25 SQL>

05:47:16 SQL> insert into test values (8);

1 row created.

05:47:29 SQL> commit;

Commit complete.

05:47:30 SQL> insert into test values (9);

1 row created.

05:47:32 SQL> select * from test;

ID

----------

1

2

3

4

5

6

7