OGG在RAC上的初始化(下)-- OGG初始化

發布時間：2020-08-11 04:25:55 來源：ITPUB博客閱讀：278 作者：shilei1 欄目：關系型數據庫

上篇地址http://blog.itpub.net/29047826/viewspace-1284906/

1，源端執行RMAN全庫備份
備份路徑為節點node1的本地磁盤。為了將該備份復制到災備端，此次備份不能保存在ASM上。

run {
allocate channel ch01 device type disk;
allocate channel ch02 device type disk;
backup
format '/backup/full_%d_%s_%T_%p.bak'
database include current controlfile;
sql 'alter system archive log current';
backup
archivelog all format '/backup/arch_%d_%s_%T_%p';
release channel ch02;
release channel ch01;
}

2，查看controlfile所在的備份片。災備端恢復的時候也從這個備份片中讀取controlfile。

RMAN> list backup of controlfile;

List of Backup Sets
===================

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
37      Full    17.80M     DISK        00:00:00     2014-09-28 23:53:06
        BP Key: 37   Status: AVAILABLE Compressed: NO Tag: TAG20140928T235259
        Piece Name: /backup/full_PROD_36_20140928_1.bak
Control File Included: Ckp SCN: 1260618      Ckp time: 2014-09-28 23:53:06

3，獲取不活動的（INACTIVE）的已經歸檔的日志的最后一個SCN號，如果有多個已歸檔的INACTIVE的組，取最大的FIRST_CHANGE# 1260645
該SCN號作為災備端recover database until 的SCN，并且在復制進程重新啟動后也要參照這個SCN。

SYS@PROD1 > select inst_id,group#,thread#,sequence#,archived,status,first_change# from gv$log order by status;

   INST_ID     GROUP#    THREAD# SEQUENCE# ARC STATUS           FIRST_CHANGE#
---------- ---------- ---------- ---------- --- ---------------- -------------
         1          3          2         25 NO CURRENT                1260660
         2          3          2         25 NO CURRENT                1260660
         1          1          1         29 NO CURRENT                1260655
         2          1          1         29 NO CURRENT                1260655
         1          2          1         28 YES INACTIVE               1260638
         1          4          2         24 YES INACTIVE               1260645
         2          2          1         28 YES INACTIVE               1260638
         2          4          2         24 YES INACTIVE               1260645

4，將源端備份復制到災備端

[oracle@node1 ~]$ scp /backup/* oracle@172.16.228.103:/backup/

5，停止災備端的復制進程準備恢復數據庫

GGSCI (node3) 4> stop rt1

Sending STOP request to REPLICAT RT1 ...
Request processed.

停止復制進程后，可以在源端繼續執行一些DML操作。這些操作會正常的通過抽取進程獲取，并有投遞進程投遞到災備端的remote trail目錄，只是暫時不用復制進程追加而已。

6，關閉災備端數據庫
[root@node3 ~]# srvctl stop database -d prod

7，災備端從RMAN啟動數據庫到nomount狀態

[root@node3 ~]# su - oracle
[oracle@node3 ~]$ rman target /

RMAN> startup nomount;

Oracle instance started

Total System Global Area     672256000 bytes

Fixed Size                     2256272 bytes
Variable Size                520094320 bytes
Database Buffers             146800640 bytes
Redo Buffers                   3104768 bytes

8，災備端從RMAN恢復控制文件

RMAN> restore controlfile from '/backup/full_PROD_24_20140928_1.bak';

Starting restore at 2014-09-28 20:14:13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 instance=PROD1 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/prod/controlfile/current.260.859387343
output file name=+ARCH/prod/controlfile/current.256.859387345
Finished restore at 2014-09-28 20:14:14

9，災備端控制文件加載復制過來的備份集信息,核對控制文件信息

RMAN> catalog start with '/backup/';

RMAN> list backup;

10，災備端從RMAN恢復數據庫

RMAN> restore database;

11，災備端從RMAN恢復歸檔日志

RMAN> run{
allocate channel c1 type disk;
allocate channel c2 type disk;
restore archivelog all;
release channel c1;
release channel c2;
}

12，災備端從RMAN指定SCN恢復。該SCN是源端數據庫執行RMAN備份后狀態為INACTIVE中數值最大的SCN。

RMAN> recover database until scn 1260645

13，災備端在mount狀態下通過控制文件查看文件頭的scn是否一致

SYS@PROD1 > select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
           1260645
           1260645
           1260645
           1260645
           1260645
           1260645
           1260645

7 rows selected.

SYS@PROD1 > select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------
           1260645
           1260645
           1260645
           1260645
           1260645
           1260645
           1260645

14，災備端resetlogs方式開啟數據庫

alter database open resetlogs;

[root@node3 ~]# srvctl start database -d prod

15，災備端重新配置checkpoint

[oracle@node3 goldengate]$ ggsci

GGSCI (node3) 1> DBLOGIN USERID oggadmin,PASSWORD oggadmin

GGSCI (node3) 2> ADD CHECKPOINTTABLE oggadmin.checkpointtable

GGSCI (node3) 14> DELETE REPLICAT rt1

GGSCI (node3) 15> ADD REPLICAT rt1, EXTTRAIL /goldengate/dirdat/rt, checkpointtable oggadmin.checkpointtable

16，災備端重新啟動復制進程，從SCN為1260645開始
注意這個單詞不要寫錯aftercsn

GGSCI (node3) 16> start rt1 aftercsn 1260645

Sending START request to MANAGER ...
REPLICAT RT1 starting

17，災備端通過sqlplus查詢恢復數據庫期間生成的DML是否被成功追加
sqlplus / as sysdba
select * from snow.t1

本次初始化演練到此結束。

向AI問一下細節

中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

OGG在RAC上的初始化(下)-- OGG初始化

猜你喜歡

中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

OGG在RAC上的初始化(下)-- OGG初始化

猜你喜歡

最新資訊

相關推薦

相關標簽