验证oracle 11g数据库的RMAN备份的有效性
发表于:2024-10-06 作者:千家信息网编辑
千家信息网最后更新 2024年10月06日,[oracle@db1 ~]$ rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 12 16:08:4
千家信息网最后更新 2024年10月06日验证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全备进行验证。
验证
全备
有效
备份
数据
数据库
有效性
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
12v服务器电源启动瞬间电流
android 中数据库
互联网科技思想
plc可以做数据库吗
共建网络安全共同体选择题
云服务器什么系统
lettuce切换数据库
山东系统软件开发费用是多少
东西湖网络安全会议
安卓手机海航邮箱设置服务器
地气网络安全
甘肃腾悦网络技术有限公司
法官解读网络安全法
魔兽世界怀旧服务器和狂暴
网络安全需要哪些编程基础
中国网络安全法正式施行时间
四川仁贤领冠互联网科技有限公司
机关网络网络安全工作总结
物联网平台与数据库
修改数据库编码格式
请让web服务器管理权限
六安电力软件开发定制公司
长沙市关于加快网络安全产业发展
福州 软件 网络安全
微信分销软件开发商
计算机网络技术什么证
特斯拉汽车事件网络安全
网络安全是国家政治安全
软件开发公司国家有补贴吗
软件开发广交朋友嬴政