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

創(chuàng)新互聯(lián)建站專注為客戶提供全方位的互聯(lián)網(wǎng)綜合服務(wù)，包含不限于成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站建設(shè)、宜城網(wǎng)絡(luò)推廣、微信平臺(tái)小程序開(kāi)發(fā)、宜城網(wǎng)絡(luò)營(yíng)銷、宜城企業(yè)策劃、宜城品牌公關(guān)、搜索引擎seo、人物專訪、企業(yè)宣傳片、企業(yè)代運(yùn)營(yíng)等，從售前售中售后，我們都將竭誠(chéng)為您服務(wù)，您的肯定，是我們最大的嘉獎(jiǎng)；創(chuàng)新互聯(lián)建站為所有大學(xué)生創(chuàng)業(yè)者提供宜城建站搭建服務(wù)，24小時(shí)服務(wù)熱線：18982081108，官方網(wǎng)址：chinadenli.net

一.場(chǎng)景描述

由于歸檔日志丟失，導(dǎo)致物理備庫(kù)MRP進(jìn)程無(wú)法與主庫(kù)同步。

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

二.使用主庫(kù)增量備份進(jìn)行備庫(kù)恢復(fù)

1.查詢備庫(kù)SCN

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

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

2.只讀表空間處理

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

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

3.根據(jù)備庫(kù)SCN，在主庫(kù)進(jìn)行增量備份

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至備庫(kù)并注冊(cè)

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';

-確認(rèn)

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.恢復(fù)備庫(kù)controlfile

(1).啟動(dòng)備庫(kù)至nomount狀態(tài)

startup nomount

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

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

(3).恢復(fù)控制文件

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

(4).查看恢復(fù)控制文件內(nèi)容

alter database backup controlfile to trace ;

* 由于控制文件是從主庫(kù)恢復(fù)過(guò)來(lái)的，因此需要確認(rèn)相關(guān)文件的文件名是否一致，相關(guān)命令:

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.在備庫(kù)應(yīng)用增量備份

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

Finished recover at 2018-03-30 16:01:21

7.確認(rèn)

確認(rèn)主備庫(kù)SCN，并開(kāi)啟MRP進(jìn)程，如果成功繼續(xù)同步，則任務(wù)完成。

關(guān)于DG歸檔丟失場(chǎng)景下如何重新同步physical standby就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò)，可以把它分享出去讓更多的人看到。

文章標(biāo)題：DG歸檔丟失場(chǎng)景下如何重新同步physicalstandby
網(wǎng)站網(wǎng)址：http://chinadenli.net/article40/jsiseo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站導(dǎo)航、定制開(kāi)發(fā)、面包屑導(dǎo)航、網(wǎng)站營(yíng)銷、品牌網(wǎng)站設(shè)計(jì)、域名注冊(cè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)