柚子快報激活碼778899分享：dba RMAN增量備份恢復(fù)

http://yzkb.51969.com/

通過rman的增量備份恢復(fù)dataguard中standby端的數(shù)據(jù)：

1.停止備庫上的MRP進程：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2.查詢備庫上的SCN值：

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

CURRENT_SCN

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

233164444

SQL> select min(checkpoint_change#) from v$datafile_header

where file# not in (select file# from v$datafile where enabled = 'READ ONLY');

MIN(F.FHSCN)

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

233163358

comment:上面一個為控制文件中記錄的SCN號，另一個為數(shù)據(jù)文件頭記錄的SCN號， 我們需要選擇較小SCN號（233163358）的來備份。

3.對主庫進行增量備份:

RMAN> BACKUP INCREMENTAL FROM SCN 233163358 DATABASE FORMAT '/tmp/ForStandby_%U' tag 'FORSTANDBY';

4.傳送備份集到備庫：

scp?/tmp/ForStandby_%U? ? standby:/tmp/

5.在備庫控制文件中注冊備份集：

RMAN>

CATALOG START WITH '/tmp/ForStandby';

6.使用已經(jīng)注冊的備份集進行恢復(fù)：

RMAN>

RECOVER DATABASE NOREDO;

7.在主庫創(chuàng)建一個備用的備庫控制文件備份：

RMAN>

BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT '/tmp/ForStandbyCTRL.bck';

8.將備份用的備庫控制文件傳到主庫；

9.將此時備庫的控制文件進行備份，以供后面驗證是否存在差異：

RMAN>?

backup current controlfile format '/tmp/ctl_%d_%T_%s.ctl';

10.在備庫中恢復(fù)備份控制文件：

RMAN> SHUTDOWN IMMEDIATE ;

RMAN> STARTUP NOMOUNT;

RMAN> RESTORE STANDBY CONTROLFILE FROM '/tmp/ForStandbyCTRL.bck';

11.啟動備庫到mount：

RMAN> SHUTDOWN IMMEDIATE ;

RMAN> STARTUP MOUNT;

12.備庫控制文件注冊數(shù)據(jù)文件

RMAN> CATALOG START WITH '+DATA/mystd/datafile/';

RMAN> SWITCH DATABASE TO COPY;

13. 在備庫清空所有備用重做日志：

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;

....

14. 在備庫開啟MRP進程

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

聯(lián)系自己做恢復(fù)時候的一個報錯問題。先關(guān)閉MRP進程，然后按照備庫此時最小SCN值在主庫上進行備份，然后將備份上傳到備庫，注冊進控制文件鐘，進行recover database noredo恢復(fù)

此時我第一步先替換了控制文件重新啟動了數(shù)據(jù)庫，并將備份和數(shù)據(jù)文件重新注冊進控制文件中，SWITCH DATABASE TO COPY； 之后我用命令recover database noredo恢復(fù)：

RMAN> recover database noredo;

Starting recover at 31-AUG-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=56 instance=jyzhao1 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: +DATA/mynas/datafile/system.258.951608183

destination for restore of datafile 00002: +DATA/mynas/datafile/sysaux.257.951608183

destination for restore of datafile 00003: +DATA/mynas/datafile/undotbs1.259.951608185

destination for restore of datafile 00004: +DATA/mynas/datafile/users.265.951608205

destination for restore of datafile 00005: +DATA/mynas/datafile/undotbs2.261.951608185

destination for restore of datafile 00006: +DATA/mynas/datafile/dbs_d_jingyu.262.951608185

destination for restore of datafile 00007: +DATA/mynas/datafile/dbs_i_jingyu.263.951608185

destination for restore of datafile 00008: +DATA/mynas/datafile/test.264.951608185

destination for restore of datafile 00009: +DATA/mynas/datafile/test2.260.951608185

destination for restore of datafile 00010: +DATA/mynas/datafile/dbs_d_hank.274.951774467

destination for restore of datafile 00011: +DATA/mynas/datafile/dbadata.276.952933931

channel ORA_DISK_1: reading from backup piece /public/backup/incremental/inc26vsd9r18.bak

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 08/31/2017 15:11:05

ORA-19870: error while restoring backup piece /public/backup/incremental/inc26vsd9r18.bak

ORA-19573: cannot obtain exclusive enqueue for datafile 11

起初我認為可能是備份問題，后來查閱了報錯，發(fā)現(xiàn)是恢復(fù)被其他的進程占用，此時想到MRP進程，檢查發(fā)現(xiàn)沒有停止mrp進程，手動停止后，發(fā)現(xiàn)可以正常進行恢復(fù)。

柚子快報激活碼778899分享：dba RMAN增量備份恢復(fù)

http://yzkb.51969.com/

相關(guān)閱讀