驗證oracle 11g資料庫的RMAN備份的有效性
[oracle@db1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 12 16:08:43 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRD (DBID=893924085)
RMAN> list backup of database;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18552 Full 5.70G DISK 00:10:08 08-DEC-17
BP Key: 18552 Status: AVAILABLE Compressed: YES Tag: TAG20171208T230015
Piece Name: /backup/scprd1/rman/Full_SCPRD_20171208_18569.bak
List of Datafiles in backup set 18552
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
7 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
10 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18674 Full 5.73G DISK 00:09:39 11-DEC-17
BP Key: 18674 Status: AVAILABLE Compressed: YES Tag: TAG20171211T230016
Piece Name: /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
List of Datafiles in backup set 18674
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
7 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
10 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035
RMAN> validate backupset 18674;
Starting validate at 12-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:11:45
Finished validate at 12-DEC-17
只針對RMAN的FULL全備進行驗證。
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 12 16:08:43 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRD (DBID=893924085)
RMAN> list backup of database;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18552 Full 5.70G DISK 00:10:08 08-DEC-17
BP Key: 18552 Status: AVAILABLE Compressed: YES Tag: TAG20171208T230015
Piece Name: /backup/scprd1/rman/Full_SCPRD_20171208_18569.bak
List of Datafiles in backup set 18552
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
7 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
10 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18674 Full 5.73G DISK 00:09:39 11-DEC-17
BP Key: 18674 Status: AVAILABLE Compressed: YES Tag: TAG20171211T230016
Piece Name: /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
List of Datafiles in backup set 18674
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
7 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
10 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035
RMAN> validate backupset 18674;
Starting validate at 12-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:11:45
Finished validate at 12-DEC-17
只針對RMAN的FULL全備進行驗證。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2148613/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN 驗證 資料檔案 和 備份 的有效性
- oracle11g rman驗證備份有效性Oracle
- Oracle 11g 檢查 RMAN 備份的有效性Oracle
- 驗證資料庫中URL的有效性資料庫
- oracle rman備份驗證和備份進度監控Oracle
- 11g rman validate驗證資料庫資料庫
- 【原】Oracle學習系列—資料庫備份—RMAN備份Oracle資料庫
- 簡單的使用rman備份oracle資料庫的做法Oracle資料庫
- Oracle 11g RMAN備份-增量備份Oracle
- 【OCR】OCR備份策略及備份介質有效性驗證
- oracle資料庫使用rman備份指令碼Oracle資料庫指令碼
- oracle rman備份驗證和備份/恢復進度監控Oracle
- Rman-ORACLE資料庫RMAN實現自動備份Oracle資料庫
- Oracle 11g RMAN備份-備份標籤Oracle
- (轉)【OCR】OCR備份策略及備份介質有效性驗證
- 使用RMAN備份資料庫資料庫
- linux下自動備份oracle資料庫-rmanLinuxOracle資料庫
- Oracle資料庫備份與恢復之RMANOracle資料庫
- Oracle資料庫RMAN小結之備份部分Oracle資料庫
- Oracle 11g RMAN備份-一致備份Oracle
- RMAN備份恢復——RAC環境資料庫的備份(zt)資料庫
- RMAN備份恢復--RAC環境資料庫的備份(十)資料庫
- RMAN備份恢復——RAC環境資料庫的備份(一)資料庫
- 利用RMAN備份重建資料庫資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-RMAN備份的目的GUIIDE資料庫
- 如何利用Rman對Oracle資料庫進行備份Oracle資料庫
- Aix下使用rman備份Oracle RAC資料庫(轉)AIOracle資料庫
- 【RMAN】使用增量備份更新資料庫備份映象資料庫
- Oracle資料庫的備份方法-冷備份(轉)Oracle資料庫
- Oracle 11g RMAN備份-基本操作Oracle
- rman備份驗證(之restore validate)REST
- Oracle資料庫備份與恢復之RMAN2Oracle資料庫
- RMAN備份 建立catalog資料庫資料庫
- 非歸檔資料庫RMAN備份資料庫
- 11g 資料庫rman壓縮備份壓縮率測試資料庫
- rman資料庫全庫備份與恢復資料庫
- 使用RMAN建立資料庫備份庫(筆記)資料庫筆記
- oracle rman備用資料庫(一)Oracle資料庫