DM7使用DMRAMN執行歸檔恢復
使用DMRAMN執行歸檔恢復
使用RECOVER命令完成資料庫恢復工作，可以是基於備份集的恢復工作，也可以是使用本地歸檔日誌的恢復工作。如果還原後，資料已經處於一致性狀態了，則可以使用更新DB_MAGIC方式恢復，前提是不需要重做日誌。語法如下：
RECOVER DATABASE '' []
[USE DB_MAGIC ] [UNTIL TIME '< 時間串>'] [UNTIL LSN ]; |
RECOVER DATABASE '' FROM BACKUPSET '< 備份集目錄>'[DEVICE TYPE DISK|TAPE[PARMS '< 介質引數>']] [IDENTIFIED BY
< 密碼> [ENCRYPT WITH < 加密演算法>]]
; |
RECOVER DATABASE '' UPDATE DB_MAGIC;
::=
WITH ARCHIVEDIR '< 歸檔日誌目錄>'{,'< 歸檔日誌目錄>'}
DATABASE：指定還原庫目標的dm.ini檔案路徑。
USE DB_MAGIC：指定本地歸檔日誌對應資料庫的DB_MAGIC，若不指定，則預設使用目標恢復資料庫的DB_MAGIC。
UNTIL TIME：恢復資料庫到指定的時間點。
UNTIL LSN：恢復資料庫到指定的LSN。
BACKUPSET：指定用於還原目標資料庫的備份集目錄。
DEVICE TYPE：指儲存備份集的介質型別，支援DISK和TAPE，預設為DISK。DISK表示儲存備份集到磁碟，TAPE表示儲存到磁帶。
PARMS：介質引數，供第三方儲存介質（TAPE型別）管理使用。
IDENTIFIED BY：指定備份時使用的加密密碼，供還原過程解密使用。
ENCRYPT WITH：指定備份時使用的加密演算法，供還原過程解密使用，若未指定，則使用預設演算法。
WITH ARCHIVEDIR：本地歸檔日誌搜尋目錄，若未指定，則僅使用目標庫配置本地歸檔目錄，RAC環境還會取REMOTE歸檔目錄。
資料庫恢復有三種方式：更新DB_MAGIC恢復、從備份集恢復和從歸檔恢復。
從歸檔恢復
從歸檔恢復是利用重做本地歸檔日誌來恢復資料的過程。從歸檔恢復允許恢復到指定的時間點及指定的LSN值。若同時指定了時間點和LSN，則以較早的為結束點。
由於從本地歸檔恢復允許使用USE DB_MAGIC指定待收集歸檔的DB_MAGIC，那麼就會存在跨庫恢復情況，所以，歸檔日誌的正確使用完全由使用者保證。因此，為了保證使用者能正確使用從歸檔恢復，除了下文這兩種情況，其他情況（可能導致資料被破壞）不建議使用者使用從本地歸檔恢復。
可以使用從歸檔恢復的情況：
1、執行過從備份集還原，以及執行過從備份集還原恢復的庫，本地歸檔日誌屬於備份集備份時的庫，本地歸檔日誌的DB_MAGIC與備份集中記錄DB_MAGIC值；
2、未執行過還原的庫，但恢復目標庫與本地歸檔日誌來源於同一個庫，且目標庫與原來的庫分離後沒有再單獨執行過操作或者故障重啟過。比如一個資料庫A因故障關閉後，複製一份作為資料庫B，此時資料庫A和B完全相同。此後，資料庫A故障重啟，並正常執行其他操作，生成了新的本地歸檔日誌。如果想利用A的本地歸檔日誌去將B恢復到A的狀態，那麼可以利用DMRMAN工具執行從本地歸檔恢復。若中間B啟動過或者執行過其他操作，則均不能再使用A的歸檔日誌進行恢復操作。
利用歸檔恢復資料庫至最新狀態的完整示例如下：
1) 啟動DIsql聯機備份資料庫，以及備份到檢查點結束為止的本地歸檔日誌。
檢視動態檢視V$RLOG中的CKPT_LSN列，可以得出當前檢查點LSN。
SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 used time: 83.467(ms). Execute id is 866393. SQL> select ckpt_lsn from v$rlog; LINEID CKPT_LSN ---------- -------------------- 1 19738189 used time: 0.817(ms). Execute id is 866466. SQL> backup archivelog until lsn 19738189 backupset '/dm_home/dmdba/dmdbms/data/jydm/bak/arch_bak_lsn_to_19738189'; executed successfully used time: 00:00:43.255. Execute id is 866619. SQL> backup database full backupset '/dm_home/dmdba/dmdbms/data/jydm/bak/db_bak_recover_arch'; executed successfully used time: 00:00:12.873. Execute id is 866805.
2) 準備目標庫，可以使用備份庫，也可以重新生成庫。
如果使用原備份庫，且備份庫故障，需要先執行目標庫歸檔修復：
RMAN>REPAIR ARCHIVELOG DATABASE 'opt/dmdbms/data/dm.ini';
如果使用新生成的庫，生成之後需要先重啟一下伺服器，才可以被還原。重新生成的庫不需要執行歸檔修復（repair）操作。重新生成庫操作如下：
[dmdba@dmks ~]$ dminit path=/dm_home/dmdbms/data db_name=dameng_for_recover auto_overwrite=1 port_num=5336 initdb V7.1.6.46-Build(2018.02.08-89107)ENT db version: 0x7000a file dm.key not found, use default license! License will expire in 14 day(s) on 2020-06-30 log file path: /dm_home/dmdbms/data/dameng_for_recover/dameng_for_recover01.log log file path: /dm_home/dmdbms/data/dameng_for_recover/dameng_for_recover02.log write to dir [/dm_home/dmdbms/data/dameng_for_recover]. create dm database success. 2020-06-16 16:03:18 [root@dmks root]# ./dm_service_installer.sh -i /dm_home/dmdbms/data/dameng_for_recover/dm.ini -p dmrc -t dmserver Move the service script file(/dm_home/dmdbms/bin/DmServicedmrc to /etc/rc.d/init.d/DmServicedmrc) Finished to create the service (DmServicedmrc) [root@dmks root]# service DmServicedmrc start Starting DmServicedmrc: [ OK ] [dmdba@dmks ~]$ disql SYSDBA/SYSDBA@localhost:5336 Server[localhost:5336]:mode is normal, state is open login used time: 10.727(ms) disql V7.1.6.46-Build(2018.02.08-89107)ENT Connected to: DM 7.1.6.46 SQL> select permanent_magic; LINEID PERMANENT_MAGIC ---------- --------------- 1 450923536 used time: 1.042(ms). Execute id is 5. SQL> select db_magic from v$rlog; LINEID DB_MAGIC ---------- ----------- 1 1009602608 used time: 1.332(ms). Execute id is 6. 3) 啟動RMAN，校驗備份。 RMAN> check backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; check backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; CMD END.CODE:[0] check backupset successfully. time used: 5.986(ms) RMAN> check backupset '/dm_home/dmdbms/backup/arch_bak'; check backupset '/dm_home/dmdbms/backup/arch_bak'; CMD END.CODE:[0] check backupset successfully. time used: 7.154(ms)
4) 還原資料庫。
RMAN> restore database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' from backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; restore database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' from backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; file dm.key not found, use default license! checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[4]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[3]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[2]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[1]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[0]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running, write dmrman info. RESTORE DATABASE CHECK...... RESTORE DATABASE , dbf collect...... RESTORE DATABASE , dbf refresh ...... RESTORE BACKUPSET [/dm_home/dmdbms/backup/db_bak_recover_arch] START...... total 22 packages processed... RESTORE DATABASE , UPDATE ctl file...... RESTORE DATABASE , REBUILD key file...... RESTORE DATABASE , CHECK db info...... RESTORE DATABASE , UPDATE db info...... total 26 packages processed! CMD END.CODE:[0] restore successfully. time used: 68070.231(ms)
5)還原歸檔日誌
RMAN> restore archive log from backupset '/dm_home/dmdbms/backup/arch_bak'to archivedir '/dm_home/dmdbms/backup/arch'; restore archive log from backupset '/dm_home/dmdbms/backup/arch_bak' to archivedir '/dm_home/dmdbms/backup/arch'; RESTORE ARCHIVE CHECK...... RESTORE ARCHIVE, dbf collect...... RESTORE ARCHIVE, dbf refresh ...... RESTORE BACKUPSET [/dm_home/dmdbms/backup/arch_bak] START...... total 60 packages processed... total 61 packages processed... total 62 packages processed! CMD END.CODE:[0] restore successfully. time used: 38325.097(ms)
6)檢視備份集的資料庫資訊，獲取源庫的DB_MAGIC。
RMAN> show backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; show backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; system path: /dm_home/dmdba/dmdbms/data/jydm db magic: 708657636 permanent magic: 1250320462 rac node: 1 page check: 0 rlog encrypt: 0 external cipher[id/name]: 0/ external hash[id/name]: 0/ length in char: 0 use new hash: 1 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B unicode_flag/charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 archive flag: 1 blank_pad_mode: 0 crc_check: TRUE backupset sig: BA backupset version: 4009 database name: jydm backup name: DB_FULL_jydm_20200617_172643_000246 backupset description: backupset ID : 1563647712 parent backupset ID: -1 META file size : 94720 compressed level: 0 encrypt type: 0 parallel num: 1 backup range: database mpp_timestamp: 1592386003 ddl_clone: FALSE mpp_flag: FALSE backup level: online backup type: full without log: FALSE START_LSN: 19751828 START_SEQ: 7739639 END_LSN: 19752212 END_SEQ: 7739836 base START_LSN: -1 base END_LSN: -1 base name: base backupset: backup time: 2020-06-17 17:26:55 min trx start lsn: 16553039 min exec ver: 0x0701060C pkg size: 0x02000000 backupset directory: /dm_home/dmdbms/backup/db_bak_recover_arch backupset name: db_bak_recover_arch backup data file num: 9 backup piece num: 2 $file_seq |$size(KB) |$pos_desc |$content_type 0 |407807 |db_bak_recover_arch.bak |DATA 1 |104 |db_bak_recover_arch_1.bak |LOG $file_seq |$group_id |$group_name |$file_id |$file_path |$mirror_path |$file_len 1 |0 |SYSTEM |0 |/dm_home/dmdba/dmdbms/data/jydm/SYSTEM.DBF| |24117248 2 |1 |ROLL |0 |/dm_home/dmdba/dmdbms/data/jydm/ROLL.DBF| |208666624 3 |4 |MAIN |0 |/dm_home/dmdba/dmdbms/data/jydm/MAIN.DBF| |197132288 4 |5 |BOOKSHOP |0 |/dm_home/dmdba/dmdbms/data/jydm/BOOKSHOP.DBF| |157286400 5 |6 |DMHR |0 |/dm_home/dmdba/dmdbms/data/jydm/DMHR.DBF| |134217728 6 |7 |USERS |0 |/dm_home/dmdba/dmdbms/data/jydm/users01.dbf| |52428800 7 |9 |SYSAUX |0 |/dm_home/dmdba/dmdbms/data/jydm/SYSAWR.DBF| |175112192 8 |10 |FG_PERSON |0 |/dm_home/dmdba/dmdbms/data/jydm/FG_PERSON.DBF| |134217728 $file_seq |$file_path |$file_len |$begin_lsn |$begin_seqno |$begin_rpag_off |$end_lsn |$end_seqno |$create_time |$close_time 9 | |101376 |19751827 |7739639 |8 |19752212 |7739836 |0000-00-00 00:00:00 |0000-00-00 00:00:00 show backupsets successfully. time used: 5.320(ms) RMAN> show backupset '/dm_home/dmdbms/backup/arch_bak'; show backupset '/dm_home/dmdbms/backup/arch_bak'; system path: /dm_home/dmdba/dmdbms/data/jydm db magic: 708657636 permanent magic: 1250320462 rac node: 1 page check: 0 rlog encrypt: 0 external cipher[id/name]: 0/ external hash[id/name]: 0/ length in char: 0 use new hash: 1 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B unicode_flag/charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 archive flag: 1 blank_pad_mode: 0 crc_check: TRUE backupset sig: BA backupset version: 4009 database name: jydm backup name: ARCH_20200617_173005_000673 backupset description: backupset ID : -99299676 parent backupset ID: -1 META file size : 135680 compressed level: 0 encrypt type: 0 parallel num: 1 backup range: archivelog mpp_timestamp: 1592386205 arch start lsn: 13775970 arch end lsn: 19752806 backup level: online backup type: archive without log: TRUE START_LSN: 19752785 START_SEQ: 7740126 END_LSN: 19752968 END_SEQ: 7740221 base START_LSN: -1 base END_LSN: -1 base name: base backupset: backup time: 2020-06-17 17:30:45 min trx start lsn: 16553039 min exec ver: 0x0701060C pkg size: 0x02000000 backupset directory: /dm_home/dmdbms/backup/arch_bak backupset name: arch_bak backup data file num: 20 backup piece num: 1 $file_seq |$size(KB) |$pos_desc |$content_type 0 |1501420 |arch_bak.bak |LOG $file_seq |$group_id |$group_name |$file_id |$file_path |$mirror_path |$file_len $file_seq |$file_path |$file_len |$begin_lsn |$begin_seqno |$begin_rpag_off |$end_lsn |$end_seqno |$create_time |$close_time 1 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200526003546144_0.log|314496512 |13775970 |4737535 |8 |14461220 |0 |2020-05-26 00:35:46 |2020-05-26 00:36:31 2 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200526003632028_0.log|271943680 |14461221 |5351778 |8 |14942037 |0 |2020-05-26 00:36:31 |2020-05-28 23:07:46 3 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200528230749046_0.log|18832384 |14942037 |5882910 |8 |15088441 |0 |2020-05-28 23:07:46 |2020-05-29 18:43:51 4 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200529184351533_0.log|444416 |15088442 |5919684 |8 |15092081 |0 |2020-05-29 18:43:51 |2020-05-29 19:37:55 5 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200529193755551_0.log|5632 |15092082 |5920544 |8 |15092086 |0 |2020-05-29 19:37:55 |2020-05-29 19:39:25 6 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200529193925775_0.log|16965120 |15092086 |5920547 |8 |15220690 |0 |2020-05-29 19:39:25 |2020-05-30 14:28:56 7 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200530142857037_0.log|152148480 |15220691 |5953674 |8 |16361831 |0 |2020-05-30 14:28:56 |2020-06-03 19:51:50 8 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200603195207512_0.log|88146944 |16361832 |6250831 |8 |17046028 |0 |2020-06-03 19:51:50 |2020-06-06 02:00:09 9 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606020009584_0.log|6746112 |17046029 |6422985 |8 |17088792 |0 |2020-06-06 02:00:09 |2020-06-06 06:13:36 10 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606061513930_0.log|24576 |17088793 |6436153 |8 |17088875 |0 |2020-06-06 06:13:36 |2020-06-06 06:24:48 11 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606062454805_0.log|7680 |17088876 |6436193 |8 |17088886 |0 |2020-06-06 06:24:48 |2020-06-06 06:26:17 12 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606062617837_0.log|7168 |17088886 |6436200 |8 |17088896 |0 |2020-06-06 06:26:17 |2020-06-06 06:27:51 13 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606062942967_0.log|7680 |17088896 |6436206 |8 |17088905 |0 |2020-06-06 06:27:51 |2020-06-06 06:29:43 14 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606064235117_0.log|15872 |17088906 |6436213 |8 |17088950 |0 |2020-06-06 06:29:43 |2020-06-06 13:11:01 15 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606142912805_0.log|5120 |17088951 |6436236 |8 |17088956 |0 |2020-06-06 13:11:01 |2020-06-06 14:29:13 16 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200606220653158_0.log|314339328 |17088957 |6436238 |8 |18425990 |0 |2020-06-06 14:29:13 |2020-06-13 21:00:00 17 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200613210000757_0.log|314571264 |18425991 |7050174 |8 |19599505 |0 |2020-06-13 21:00:00 |2020-06-17 09:35:23 18 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200617093523748_0.log|33190912 |19599505 |7664563 |8 |19731163 |0 |2020-06-17 09:35:23 |2020-06-17 16:18:01 19 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200617161801000_0.log|4020224 |19731163 |7729381 |8 |19747260 |0 |2020-06-17 16:18:01 |2020-06-17 17:01:01 20 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200617170101954_0.log|1499136 |19747260 |7737225 |8 |19752806 |0 |2020-06-17 17:01:01 |2020-06-17 17:30:05 show backupsets successfully. time used: 25.316(ms)
若還原後，立即執行執行恢復，可以不用獲取源庫DB_MAGIC。因為DMRMAN執行庫級備份集還原後，會將備份集中的DB_MAGIC刷入還原後的庫中。
7>利用歸檔恢復資料庫。由步驟6顯示的備份集資訊可知，源庫的DB_MAGIC值為1447060265。
RMAN> recover database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' with archivedir '/dm_home/dmdbms/backup/arch' use db_magic 708657636; recover database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' with archivedir '/dm_home/dmdbms/backup/arch' use db_magic 708657636; checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[4]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[3]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[2]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[1]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[0]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running, write dmrman info. EP[0] max_lsn: 19751827 EP[0] Recover LSN from 19751828 to 19752806. Recover from archive log finished, time used:0.165s. recover successfully! time used: 7051.292(ms)
8)檢查目標庫中的表t1確認資料與源資料庫一致。
SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 4 4 4 used time: 9.369(ms). Execute id is 6.
9)在源資料庫的t1表中插入一行資料
SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 4 4 4 used time: 0.779(ms). Execute id is 879030. SQL> insert into t1 values(5,5); affect rows 1 used time: 1.188(ms). Execute id is 879204. SQL> commit; executed successfully used time: 13.572(ms). Execute id is 879210. SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 used time: 0.590(ms). Execute id is 879218.
10)在源資料庫中備份歸檔日誌，從lsn為19752806開始進行備份，因為之前備份的歸檔日誌最大lsn為19752806,將將備份檔案傳到目標資料庫上
SQL> backup archivelog from lsn 19752806 backupset '/dm_home/dmdba/dmdbms/data/jydm/bak/arch_bak_from_19752806'; executed successfully used time: 00:00:01.850. Execute id is 879461. [dmdba@shard1 bak]$ scp -r arch_bak_from_19752806 dmdba@10.138.130.187:/dm_home/dmdbms/backup/ dmdba@10.138.130.187's password: arch_bak_from_19752806.bak 100% 10MB 9.8MB/s 00:00 arch_bak_from_19752806.meta 100% 61KB 60.5KB/s 00:00 [dmdba@shard1 bak]$
11)檢查備份的歸檔日誌
RMAN> check backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806'; check backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806'; CMD END.CODE:[0] check backupset successfully. time used: 7.121(ms)
12)檢視備份集資訊，獲取源庫的DB_MAGIC
RMAN> show backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806'; show backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806'; system path: /dm_home/dmdba/dmdbms/data/jydm db magic: 708657636 permanent magic: 1250320462 rac node: 1 page check: 0 rlog encrypt: 0 external cipher[id/name]: 0/ external hash[id/name]: 0/ length in char: 0 use new hash: 1 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B unicode_flag/charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 archive flag: 1 blank_pad_mode: 0 crc_check: TRUE backupset sig: BA backupset version: 4009 database name: jydm backup name: ARCH_20200617_190859_000032 backupset description: backupset ID : -1402072600 parent backupset ID: -1 META file size : 61952 compressed level: 0 encrypt type: 0 parallel num: 1 backup range: archivelog mpp_timestamp: 1592392139 arch start lsn: 19747260 arch end lsn: 19787571 backup level: online backup type: archive without log: TRUE START_LSN: 19786788 START_SEQ: 7756899 END_LSN: 19787571 END_SEQ: 7757301 base START_LSN: -1 base END_LSN: -1 base name: base backupset: backup time: 2020-06-17 19:09:00 min trx start lsn: 16553039 min exec ver: 0x0701060C pkg size: 0x02000000 backupset directory: /dm_home/dmdbms/backup/arch_bak_from_19752806 backupset name: arch_bak_from_19752806 backup data file num: 2 backup piece num: 1 $file_seq |$size(KB) |$pos_desc |$content_type 0 |10052 |arch_bak_from_19752806.bak |LOG $file_seq |$group_id |$group_name |$file_id |$file_path |$mirror_path |$file_len $file_seq |$file_path |$file_len |$begin_lsn |$begin_seqno |$begin_rpag_off |$end_lsn |$end_seqno |$create_time |$close_time 1 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200617170101954_0.log|1499136 |19747260 |7737225 |8 |19752806 |0 |2020-06-17 17:01:01 |2020-06-17 17:30:05 2 |/dm_home/dmdba/dmdbms/data/arch/ARCHIVE_LOCAL1_20200617173005734_0.log|8788480 |19752806 |7740145 |8 |19787571 |0 |2020-06-17 17:30:05 |2020-06-17 19:08:59 show backupsets successfully. time used: 6.440(ms)
13)還原最新生成的備份歸檔日誌
RMAN> restore archive log from backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806' to archivedir '/dm_home/dmdbms/backup/arch'; restore archive log from backupset '/dm_home/dmdbms/backup/arch_bak_from_19752806' to archivedir '/dm_home/dmdbms/backup/arch'; RESTORE ARCHIVE CHECK...... RESTORE ARCHIVE, dbf collect...... RESTORE ARCHIVE, dbf refresh ...... RESTORE BACKUPSET [/dm_home/dmdbms/backup/arch_bak_from_19752806] START...... total 1 packages processed... total 2 packages processed! CMD END.CODE:[0] restore successfully. time used: 317.745(ms)
14)使用之前的資料庫備份集還原目標資料庫
RMAN> restore database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' from backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; restore database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' from backupset '/dm_home/dmdbms/backup/db_bak_recover_arch'; checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[4]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[3]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[2]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[1]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[0]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running, write dmrman info. RESTORE DATABASE CHECK...... RESTORE DATABASE , dbf collect...... RESTORE DATABASE , dbf refresh ...... RESTORE BACKUPSET [/dm_home/dmdbms/backup/db_bak_recover_arch] START...... total 22 packages processed... RESTORE DATABASE , UPDATE ctl file...... RESTORE DATABASE , REBUILD key file...... RESTORE DATABASE , CHECK db info...... RESTORE DATABASE , UPDATE db info...... total 26 packages processed! CMD END.CODE:[0] restore successfully. time used: 29783.391(ms)
15)使用歸檔日誌執行恢復
RMAN> recover database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' with archivedir '/dm_home/dmdbms/backup/arch' use db_magic 708657636; recover database '/dm_home/dmdbms/data/dameng_for_recover/dm.ini' with archivedir '/dm_home/dmdbms/backup/arch' use db_magic 708657636; checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[4]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[3]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[2]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[1]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running...[0]. checking if the database under system path [/dm_home/dmdbms/data/dameng_for_recover] is running, write dmrman info. EP[0] max_lsn: 19751827 total redo pages:2920 EP[0] Recover LSN from 19751828 to 19787571. Recover from archive log finished, time used:1.503s. recover successfully! time used: 8275.787(ms) RMAN>
16)啟動資料資料庫檢查表t1的資料
[root@dmks init.d]# service DmServicedmrc start Starting DmServicedmrc: [ OK ] SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 used time: 1.662(ms). Execute id is 5.
17) 若執行後歸檔恢復過程中，出現歸檔不足的錯誤，則利用歸檔校驗工具dmrachk，檢視歸檔目錄中歸檔連續性情況，然後再利用備份的
本地歸檔日誌，還原到歸檔目錄後，再次執行恢復操作
[dmdba@dmks backup]$ dmrachk arch_path=/dm_home/dmdbms/backup/arch rachk V7.1.6.46-Build(2018.02.08-89107)ENT the database db_magic: 708657636 /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200526003546144_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 614243 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 13775970 arch_seq : 4737535 clsn : 14461220 next_seq : 5351777 file len : 314496512 file free : 314496512 create time : 2020-05-26 00:35:46 close time : 2020-05-26 00:36:31 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200526003632028_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 531132 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 14461221 arch_seq : 5351778 clsn : 14942037 next_seq : 5882909 file len : 271943680 file free : 271943680 create time : 2020-05-26 00:36:31 close time : 2020-05-28 23:07:46 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200528230749046_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 36774 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 14942037 arch_seq : 5882910 clsn : 15088441 next_seq : 5919683 file len : 18832384 file free : 18832384 create time : 2020-05-28 23:07:46 close time : 2020-05-29 18:43:51 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200529184351533_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 860 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 15088442 arch_seq : 5919684 clsn : 15092081 next_seq : 5920543 file len : 444416 file free : 444416 create time : 2020-05-29 18:43:51 close time : 2020-05-29 19:37:55 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200529193755551_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 3 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 15092082 arch_seq : 5920544 clsn : 15092086 next_seq : 5920546 file len : 5632 file free : 5632 create time : 2020-05-29 19:37:55 close time : 2020-05-29 19:39:25 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200529193925775_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 33127 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 15092086 arch_seq : 5920547 clsn : 15220690 next_seq : 5953673 file len : 16965120 file free : 16965120 create time : 2020-05-29 19:39:25 close time : 2020-05-30 14:28:56 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200530142857037_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 297157 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 15220691 arch_seq : 5953674 clsn : 16361831 next_seq : 6250830 file len : 152148480 file free : 152148480 create time : 2020-05-30 14:28:56 close time : 2020-06-03 19:51:50 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200603195207512_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 172154 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 16361832 arch_seq : 6250831 clsn : 17046028 next_seq : 6422984 file len : 88146944 file free : 88146944 create time : 2020-06-03 19:51:50 close time : 2020-06-06 02:00:09 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606020009584_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 13168 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17046029 arch_seq : 6422985 clsn : 17088792 next_seq : 6436152 file len : 6746112 file free : 6746112 create time : 2020-06-06 02:00:09 close time : 2020-06-06 06:13:36 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606061513930_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 40 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088793 arch_seq : 6436153 clsn : 17088875 next_seq : 6436192 file len : 24576 file free : 24576 create time : 2020-06-06 06:13:36 close time : 2020-06-06 06:24:48 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606062454805_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 7 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088876 arch_seq : 6436193 clsn : 17088886 next_seq : 6436199 file len : 7680 file free : 7680 create time : 2020-06-06 06:24:48 close time : 2020-06-06 06:26:17 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606062617837_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 6 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088886 arch_seq : 6436200 clsn : 17088896 next_seq : 6436205 file len : 7168 file free : 7168 create time : 2020-06-06 06:26:17 close time : 2020-06-06 06:27:51 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606062942967_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 7 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088896 arch_seq : 6436206 clsn : 17088905 next_seq : 6436212 file len : 7680 file free : 7680 create time : 2020-06-06 06:27:51 close time : 2020-06-06 06:29:43 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606064235117_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 23 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088906 arch_seq : 6436213 clsn : 17088950 next_seq : 6436235 file len : 15872 file free : 15872 create time : 2020-06-06 06:29:43 close time : 2020-06-06 13:11:01 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606142912805_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 2 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088951 arch_seq : 6436236 clsn : 17088956 next_seq : 6436237 file len : 5120 file free : 5120 create time : 2020-06-06 13:11:01 close time : 2020-06-06 14:29:13 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200606220653158_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 613936 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 17088957 arch_seq : 6436238 clsn : 18425990 next_seq : 7050173 file len : 314339328 file free : 314339328 create time : 2020-06-06 14:29:13 close time : 2020-06-13 21:00:00 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200613210000757_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 614389 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 18425991 arch_seq : 7050174 clsn : 19599505 next_seq : 7664562 file len : 314571264 file free : 314571264 create time : 2020-06-13 21:00:00 close time : 2020-06-17 09:35:23 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200617093523748_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 64818 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 19599505 arch_seq : 7664563 clsn : 19731163 next_seq : 7729380 file len : 33190912 file free : 33190912 create time : 2020-06-17 09:35:23 close time : 2020-06-17 16:18:01 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200617161801000_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 7844 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 19731163 arch_seq : 7729381 clsn : 19747260 next_seq : 7737224 file len : 4020224 file free : 4020224 create time : 2020-06-17 16:18:01 close time : 2020-06-17 17:01:01 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200617170101954_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 2920 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 19747260 arch_seq : 7737225 clsn : 19752806 next_seq : 7740144 file len : 1499136 file free : 1499136 create time : 2020-06-17 17:01:01 close time : 2020-06-17 17:30:05 crc_check : TRUE /*******************************************************************/ /*******************************************************************/ archive file /dm_home/dmdbms/backup/arch/ARCHIVE_LOCAL1_20200617173005734_0.log itemize. version : 0x7004 status : INACTIVE n_rpags : 17157 db_magic : 708657636 pemnt_magic : 1250320462 arch_lsn : 19752806 arch_seq : 7740145 clsn : 19787571 next_seq : 7757301 file len : 8788480 file free : 8788480 create time : 2020-06-17 17:30:05 close time : 2020-06-17 19:08:59 crc_check : TRUE /*******************************************************************/ The SUMMARY(seqno[0]): total files: 21 okey files: 21 fail file: 0 repeat file: 0 the rachk tool running cost 5.413 ms [dmdba@dmks backup]$
DMRMAN檢視歸檔備份的範圍：
RMAN> show backupset '/dm_home/dmdbms/backup/arch_bak' info meta; show backupset '/dm_home/dmdbms/backup/arch_bak' info meta; backupset sig: BA backupset version: 4009 database name: jydm backup name: ARCH_20200617_173005_000673 backupset description: backupset ID : -99299676 parent backupset ID: -1 META file size : 135680 compressed level: 0 encrypt type: 0 parallel num: 1 backup range: archivelog mpp_timestamp: 1592386205 arch start lsn: 13775970 arch end lsn: 19752806 backup level: online backup type: archive without log: TRUE START_LSN: 19752785 START_SEQ: 7740126 END_LSN: 19752968 END_SEQ: 7740221 base START_LSN: -1 base END_LSN: -1 base name: base backupset: backup time: 2020-06-17 17:30:45 min trx start lsn: 16553039 min exec ver: 0x0701060C pkg size: 0x02000000 show backupsets successfully. time used: 7.527(ms)
如果有丟失部分歸檔日誌可以執行歸檔還原後，再次執行利用本地歸檔恢復操作。
RMAN>restore archive log from backupset '/dm_home/dmdbms/backup/arch_bak' ALL TO ARCHIVEDIR '/dm_home/dmdbms/backup/arch';
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-2735098/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- DM7使用DMRAMN執行備份集恢復
- DM7使用DMRAMN執行更新DB_MAGIC恢復
- DM7使用DMRAMN對多次故障恢復後使用不同資料庫的歸檔進行恢復資料庫
- DM7使用DMRMAN執行歸檔修復
- DM7使用DMRMAN執行歸檔還原
- DM7使用DMRMAN執行歸檔備份
- DM7使用DMRMAN執行RAC資料庫恢復資料庫
- DM7使用DMRMAN執行資料庫還原和恢復資料庫
- DM7使用dmrestore工具利用不同資料庫的歸檔恢復資料庫REST資料庫
- RMAN恢復 執行重要檔案RMAN恢復
- DM7聯機執行SQL語句進行歸檔備份SQL
- 恢復之非歸檔模式下的恢復模式
- RMAN恢復 執行不重要檔案的RMAN恢復
- rman datafile恢復(歸檔模式)模式
- DM7配置本地歸檔
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- DM7使用dmrestore執行並行對映檔案還原REST並行
- 用冷備份+歸檔日誌執行不完全恢復一例
- DG歸檔日誌缺失恢復
- 無備份恢復(歸檔模式)模式
- ORACLE非歸檔下的恢復Oracle
- dg丟失歸檔，使用rman增量備份恢復
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案
- 恢復案例：無歸檔，掉電，控制檔案全部丟失恢復
- 使用RMAN來PDB執行完全恢復
- DM7配置遠端歸檔
- 恢復案例：歸檔模式下丟失全部資料檔案的恢復模式
- 資料庫備份與恢復（使用歸檔後滾）資料庫
- 完整恢復模式下執行檔案還原模式
- trace檔案備份控制檔案並執行恢復
- 恢復案例：無歸檔，丟失全部控制檔案、日誌檔案恢復案例
- 非歸檔模式恢復資料庫模式資料庫
- Data Guard跳歸檔恢復的案例
- 只有冷備和歸檔，能否恢復？
- standby缺失primary歸檔，手工同步恢復
- DM7使用dmrestore工具利用歸檔日誌還原REST
- 恢復歸檔日誌檔案的常用方法
- rman恢復--歸檔模式有備份，丟失資料檔案的恢復模式