RAC 資料庫恢復到單例項下並且基於時間點恢復

RAC 下基於時間點的恢復
1、源庫進行備份 我這裡進行了2次備份
2、複製2次的備份集到目標機器上，在目標機器上建立好SPFILE.
3、使用recover controlfile from 進行控制檔案恢復，這個沒什麼好說的確定好控制檔案所在備份集進行恢復就可以了。
4、重新命名進行恢復

run {
set newname for datafile '+DATA/rac/datafile/system.270.790795355' to '/home/oradba/db/rac/system.dbf';
set newname for datafile '+DATA/rac/datafile/sysaux.271.790795355' to '/home/oradba/db/rac/sysaux.dbf';
set newname for datafile '+DATA/rac/datafile/undotbs1.272.790795355' to '/home/oradba/db/rac/undotbs1.dbf';
set newname for datafile '+DATA/rac/datafile/users.273.790795355' to '/home/oradba/db/rac/users.dbf';
set newname for datafile '+DATA/rac/datafile/undotbs2.278.790795443' to '/home/oradba/db/rac/undotbs2.dbf';
restore database from tag='TAG20120921T224531';
}
完成後可以用report schema看一下
5、重命令控制檔案中記錄的檔案包括資料檔案和日誌檔案
alter database rename file '+DATA/rac/datafile/system.270.790795355' to '/home/oradba/db/rac/system.dbf';
alter database rename file '+DATA/rac/datafile/sysaux.271.790795355' to '/home/oradba/db/rac/sysaux.dbf';
alter database rename file '+DATA/rac/datafile/undotbs1.272.790795355' to '/home/oradba/db/rac/undotbs1.dbf';
alter database rename file '+DATA/rac/datafile/users.273.790795355' to '/home/oradba/db/rac/users.dbf';
alter database rename file '+DATA/rac/datafile/undotbs2.278.790795443' to '/home/oradba/db/rac/undotbs2.dbf';
alter database rename file '+DATA/rac/datafile/logfile1.dbf' to '/home/oradba/db/rac/logfile1.dbf';
...........
6、確定時間點
run {
set until time "to_date('2012-09-22 18:59:40','yyyy-mm-dd hh24:mi:ss')";
recover database;
}
7、alter database open resetlogs;
8、重建臨時表空間

SQL> create temporary tablespace temp1 tempfile '/home/oradba/db/rac/temp1.dbf' size 100m autoextend on;

Tablespace created.

SQL> alter database default temporary tablespace temp1;

Database altered.

SQL> drop tablespace temp;

Tablespace dropped.
9、刪除無用的日誌組
   THREAD# STATUS ENABLED      GROUPS INSTANCE
---------- ------ -------- ---------- ------------------------------------------
         1 OPEN   PUBLIC            2 rac
         2 CLOSED PUBLIC            2 rac2

SQL> alter database disable thread 2;

Database altered.

QL> select * from v$log;
truncating (as requested) before column FIRST_CHANGE#

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRS
---------- ---------- ---------- ---------- ---------- --- ---------------- ----
         1          1          3   52428800          1 YES INACTIVE         22-S
         2          1          4   52428800          1 NO  CURRENT          22-S
         3          2          1   52428800          1 YES INACTIVE         22-S
         4          2          2   52428800          1 NO  INACTIVE         22-S

SQL> alter database drop logfile group 3;

Database altered.

SQL> lter database drop logfile group 4;
SP2-0734: unknown command beginning "lter datab..." - rest of line ignored.
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-00350: log 4 of instance rac2 (thread 2) needs to be archived
ORA-00312: online log 4 thread 2: '/home/oradba/db/rac/redo4.log'

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL>
SQL> alter database drop logfile group 4;

Database altered.
10、刪除不用的UNDO tablespace

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1

SQL> drop tablespace undotbs2 including contents and datafiles;

Tablespace dropped.

 

至此完成。