DG歸檔丟失場景下如何重新同步physical standby

137次閱讀

共計 6464 個字符，預計需要花費 17 分鐘才能閱讀完成。

這篇文章給大家介紹 DG 歸檔丟失場景下如何重新同步 physical standby，內容非常詳細，感興趣的小伙伴們可以參考借鑒，希望對大家能有所幫助。

一. 場景描述

由于歸檔日志丟失，導致物理備庫 MRP 進程無法與主庫同步。

SQL select thread#, max(sequence#) Last Standby Seq Received
2 from v$archived_log val, v$database vdb
3 where val.resetlogs_change# = vdb.resetlogs_change#
4 group by thread# order by 1;

THREAD# Last Standby Seq Received
———- ————————-
1 1121
2 1143

SQL select thread#, max(sequence#) Last Standby Seq Applied
2 from v$archived_log val, v$database vdb
3 where val.resetlogs_change# = vdb.resetlogs_change#
4 and val.applied in (YES , IN-MEMORY)
5 group by thread# order by 1;

THREAD# Last Standby Seq Applied
———- ————————
1 882
2 853

二. 使用主庫增量備份進行備庫恢復

1. 查詢備庫 SCN

SQL SELECT CURRENT_SCN FROM V$DATABASE;
SQL select min(fhscn) from x$kcvfh; – 推薦

MIN(FHSCN)
—————————————-
41888422

2. 只讀表空間處理

如果存在只讀表空間，則需要在主庫執(zhí)行下面命令:

SQL alter tablespace xxx read write ;
SQL alter tablespace xxx read only ;

3. 根據備庫 SCN，在主庫進行增量備份

RMAN BACKUP INCREMENTAL FROM SCN 41888422 DATABASE FORMAT /tmp/ForStandby_%U tag FORSTANDBY

Starting backup at 2018-03-30 15:38:47
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 instance=racdb12c1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DGDATA1/RACDB12C/DATAFILE/ees_dat01.dbf
input datafile file number=00007 name=+DGDATA2/RACDB12C/DATAFILE/ees_idx01.dbf
input datafile file number=00002 name=+DGSYSTEM/RACDB12C/DATAFILE/sysaux.272.960743041
input datafile file number=00001 name=+DGSYSTEM/RACDB12C/DATAFILE/system.271.960743017
input datafile file number=00008 name=+DGDATA1/racdb12c/datafile/ees_idx02.dbf
input datafile file number=00009 name=+DGDATA1/racdb12c/datafile/ees_idx03.dbf
input datafile file number=00003 name=+DGSYSTEM/RACDB12C/DATAFILE/undotbs1.273.960743055
input datafile file number=00004 name=+DGSYSTEM/RACDB12C/DATAFILE/undotbs2.275.960743081
input datafile file number=00005 name=+DGSYSTEM/RACDB12C/DATAFILE/users.276.960743083
channel ORA_DISK_1: starting piece 1 at 2018-03-30 15:38:52
channel ORA_DISK_1: finished piece 1 at 2018-03-30 15:45:50
piece handle=/tmp/ForStandby_5fsv3e4b_1_1 tag=FORSTANDBY comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:58
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2018-03-30 15:45:58
channel ORA_DISK_1: finished piece 1 at 2018-03-30 15:46:05
piece handle=/tmp/ForStandby_5gsv3ehf_1_1 tag=FORSTANDBY comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 2018-03-30 15:46:05

4. 將備份文件 copy 至備庫并注冊

scp root@rac1:/tmp/ForStandby_5fsv3e4b_1_1 /tmp

scp root@rac1:/tmp/ForStandby_5gsv3ehf_1_1 /tmp

catalog backuppiece /tmp/ForStandby_5fsv3e4b_1_1
catalog backuppiece /tmp/ForStandby_5gsv3ehf_1_1

- 確認

list backup
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— ——————-
12 Incr 1.96G DISK 00:06:55 2018-03-30 15:45:46
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: FORSTANDBY
Piece Name: /tmp/ForStandby_5fsv3e4b_1_1
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
—- — —- ———- ——————- ———– —— —-
1 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafilesys/datafile/system.271.960743017
2 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafilesys/datafile/sysaux.272.960743041
3 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafilesys/datafile/undotbs1.273.960743055
4 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafilesys/datafile/undotbs2.275.960743081
5 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafilesys/datafile/users.276.960743083
6 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafileuser/datafile/ees_dat01.dbf
7 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafileuser/datafile/ees_idx01.dbf
8 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafileuser/datafile/ees_idx02.dbf
9 Incr 52145113 2018-03-30 15:38:52 NO /oradata/racdb12cdg/datafileuser/datafile/ees_idx03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— ——————-
13 Incr 46.50M DISK 00:00:08 2018-03-30 15:45:59
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: FORSTANDBY
Piece Name: /tmp/ForStandby_5gsv3ehf_1_1
Control File Included: Ckp SCN: 52146933 Ckp time: 2018-03-30 15:45:51

5. 恢復備庫 controlfile

(1). 啟動備庫至 nomount 狀態(tài)

startup nomount

(2). 備份備庫控制文件

cp /oradata/control_file/control01.ctl /oradata/control_file/control01.ctl.bak

(3). 恢復控制文件

restore standby controlfile to /oradata/control_file/control01.ctl from /tmp/ForStandby_5gsv3ehf_1_1

(4). 查看恢復控制文件內容

alter database backup controlfile to trace ;

* 由于控制文件是從主庫恢復過來的，因此需要確認相關文件的文件名是否一致，相關命令:

SELECT a.FILE#, a.NAME,a.CHECKPOINT_CHANGE#,a.LAST_CHANGE#,status FROM v$datafile a;
alter system set standby_file_management=manual;
alter database rename file file_name to file_name

6. 在備庫應用增量備份

RMAN RECOVER DATABASE NOREDO;

Starting recover at 2018-03-30 16:00:23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata/racdb12cdg/datafilesys/datafile/system.271.960743017
destination for restore of datafile 00002: /oradata/racdb12cdg/datafilesys/datafile/sysaux.272.960743041
destination for restore of datafile 00003: /oradata/racdb12cdg/datafilesys/datafile/undotbs1.273.960743055
destination for restore of datafile 00004: /oradata/racdb12cdg/datafilesys/datafile/undotbs2.275.960743081
destination for restore of datafile 00005: /oradata/racdb12cdg/datafilesys/datafile/users.276.960743083
destination for restore of datafile 00006: /oradata/racdb12cdg/datafileuser/datafile/ees_dat01.dbf
destination for restore of datafile 00007: /oradata/racdb12cdg/datafileuser/datafile/ees_idx01.dbf
destination for restore of datafile 00008: /oradata/racdb12cdg/datafileuser/datafile/ees_idx02.dbf
destination for restore of datafile 00009: /oradata/racdb12cdg/datafileuser/datafile/ees_idx03.dbf
channel ORA_DISK_1: reading from backup piece /tmp/ForStandby_5fsv3e4b_1_1
channel ORA_DISK_1: piece handle=/tmp/ForStandby_5fsv3e4b_1_1 tag=FORSTANDBY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55