Oracle 11g rman备份相关
发表于：2025-01-20 作者：千家信息网编辑
千家信息网最后更新 2025年01月20日，1.验证备份是否可以被成功还原，完全还原确定需应用哪些备份集和归档日志。RMAN> restore database preview;Starting restore at 07-OCT-15usin
千家信息网最后更新 2025年01月20日Oracle 11g rman备份相关
1.验证备份是否可以被成功还原，完全还原确定需应用哪些备份集和归档日志。
RMAN> restore database preview;Starting restore at 07-OCT-15using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=202 device type=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: SID=138 device type=DISKList of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------57 Incr 0 363.33M DISK 00:01:26 05-OCT-15 List of Datafiles in backup set 57 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 0 Incr 3687271 05-OCT-15 +DATA/phub/datafile/system.271.891340857 2 0 Incr 3687271 05-OCT-15 +DATA/phub/datafile/sysaux.272.891340857 4 0 Incr 3687271 05-OCT-15 +DATA/phub/datafile/users.269.891340843 7 0 Incr 3687271 05-OCT-15 +DATA/phub/datafile/idx01.dbf Backup Set Copy #1 of backup set 57 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:01:26 05-OCT-15 YES DB0 List of Backup Pieces for backup set 57 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 64 1 AVAILABLE /home/oracle/backup/data_51qiv187_1_1.bak 65 2 AVAILABLE /home/oracle/backup/data_51qiv187_2_1.bak 66 3 AVAILABLE /home/oracle/backup/data_51qiv187_3_1.bak 67 4 AVAILABLE /home/oracle/backup/data_51qiv187_4_1.bakBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------55 Incr 0 215.65M DISK 00:01:06 05-OCT-15 List of Datafiles in backup set 55 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 3 0 Incr 3687269 05-OCT-15 +DATA/phub/datafile/undotbs1.260.891340857 5 0 Incr 3687269 05-OCT-15 +DATA/phub/datafile/example.287.891340843 6 0 Incr 3687269 05-OCT-15 +DATA/phub/datafile/llc01.dbf Backup Set Copy #1 of backup set 55 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:01:06 05-OCT-15 YES DB0 List of Backup Pieces for backup set 55 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 60 1 AVAILABLE /home/oracle/backup/data_50qiv187_1_1.bak 61 2 AVAILABLE /home/oracle/backup/data_50qiv187_2_1.bak 62 3 AVAILABLE /home/oracle/backup/data_50qiv187_3_1.bakusing channel ORA_DISK_1using channel ORA_DISK_2List of Archived Log Copies for database with db_unique_name PHUB=====================================================================Key Thrd Seq S Low Time ------- ---- ------- - ---------552 1 276 A 05-OCT-15 Name: +DATA/phub/archivelog/2015_10_05/thread_1_seq_276.374.892332021554 1 277 A 05-OCT-15 Name: +DATA/phub/archivelog/2015_10_06/thread_1_seq_277.372.892352657556 1 278 A 06-OCT-15 Name: +DATA/phub/archivelog/2015_10_06/thread_1_seq_278.370.892370685557 1 279 A 06-OCT-15 Name: +DATA/phub/archivelog/2015_10_06/thread_1_seq_279.368.892385187559 1 280 A 06-OCT-15 Name: +DATA/phub/archivelog/2015_10_06/thread_1_seq_280.365.892385193562 1 281 A 06-OCT-15 Name: +DATA/phub/archivelog/2015_10_06/thread_1_seq_281.285.892411985564 1 282 A 06-OCT-15 Name: +DATA/phub/archivelog/2015_10_07/thread_1_seq_282.290.892428501566 1 283 A 07-OCT-15 Name: +DATA/phub/archivelog/2015_10_07/thread_1_seq_283.300.892458049Media recovery start SCN is 3687269Recovery must be done beyond SCN 3687271 to clear datafile fuzzinessFinished restore at 07-OCT-15
2.检查用于恢复数据库的的最新备份集，以确认备份是否完整，检查恢复所需要的数据文件副本和归档日志备份集。
RMAN> restore database validate;Starting restore at 07-OCT-15using channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting validation of datafile backup setchannel ORA_DISK_2: starting validation of datafile backup setchannel ORA_DISK_1: reading from backup piece /home/oracle/backup/data_50qiv187_1_1.bakchannel ORA_DISK_2: reading from backup piece /home/oracle/backup/data_51qiv187_1_1.bakchannel ORA_DISK_1: piece handle=/home/oracle/backup/data_50qiv187_1_1.bak tag=DB0channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: reading from backup piece /home/oracle/backup/data_50qiv187_2_1.bakchannel ORA_DISK_2: piece handle=/home/oracle/backup/data_51qiv187_1_1.bak tag=DB0channel ORA_DISK_2: restored backup piece 1channel ORA_DISK_2: reading from backup piece /home/oracle/backup/data_51qiv187_2_1.bakchannel ORA_DISK_2: piece handle=/home/oracle/backup/data_51qiv187_2_1.bak tag=DB0channel ORA_DISK_2: restored backup piece 2channel ORA_DISK_2: reading from backup piece /home/oracle/backup/data_51qiv187_3_1.bakchannel ORA_DISK_1: piece handle=/home/oracle/backup/data_50qiv187_2_1.bak tag=DB0channel ORA_DISK_1: restored backup piece 2channel ORA_DISK_1: reading from backup piece /home/oracle/backup/data_50qiv187_3_1.bakchannel ORA_DISK_2: piece handle=/home/oracle/backup/data_51qiv187_3_1.bak tag=DB0channel ORA_DISK_2: restored backup piece 3channel ORA_DISK_2: reading from backup piece /home/oracle/backup/data_51qiv187_4_1.bakchannel ORA_DISK_1: piece handle=/home/oracle/backup/data_50qiv187_3_1.bak tag=DB0channel ORA_DISK_1: restored backup piece 3channel ORA_DISK_1: validation complete, elapsed time: 00:01:03channel ORA_DISK_2: piece handle=/home/oracle/backup/data_51qiv187_4_1.bak tag=DB0channel ORA_DISK_2: restored backup piece 4channel ORA_DISK_2: validation complete, elapsed time: 00:01:12Finished restore at 07-OCT-15
3.校验数据文件的是否存在坏块：
RMAN> backup check logical validate database;Starting backup at 07-OCT-15using channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00006 name=+DATA/phub/datafile/llc01.dbfinput datafile file number=00005 name=+DATA/phub/datafile/example.287.891340843input datafile file number=00003 name=+DATA/phub/datafile/undotbs1.260.891340857channel ORA_DISK_2: starting full datafile backup setchannel ORA_DISK_2: specifying datafile(s) in backup setinput datafile file number=00007 name=+DATA/phub/datafile/idx01.dbfinput datafile file number=00002 name=+DATA/phub/datafile/sysaux.272.891340857input datafile file number=00001 name=+DATA/phub/datafile/system.271.891340857input datafile file number=00004 name=+DATA/phub/datafile/users.269.891340843channel ORA_DISK_2: backup set complete, elapsed time: 00:00:55List of Datafiles=================File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------1 OK 0 14660 98639 3880208 File Name: +DATA/phub/datafile/system.271.891340857 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 65879 Index 0 13480 Other 0 4541 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------2 OK 0 23933 120381 3880206 File Name: +DATA/phub/datafile/sysaux.272.891340857 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 35531 Index 0 30258 Other 0 30598 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------4 OK 0 4478 87390 3006034 File Name: +DATA/phub/datafile/users.269.891340843 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 81242 Index 0 730 Other 0 910 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------7 OK 0 98073 131072 3010614 File Name: +DATA/phub/datafile/idx01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 32360 Other 0 639 channel ORA_DISK_2: starting full datafile backup setchannel ORA_DISK_2: specifying datafile(s) in backup setincluding current control file in backup setchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:01List of Control File and SPFILE===============================File Type Status Blocks Failing Blocks Examined------------ ------ -------------- ---------------Control File OK 0 646 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:59List of Datafiles=================File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------3 OK 0 1 18560 3880208 File Name: +DATA/phub/datafile/undotbs1.260.891340857 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 18559 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------5 OK 2192 31371 44325 3819558 File Name: +DATA/phub/datafile/example.287.891340843 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 4394 Index 0 1149 Other 0 7406 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------6 OK 0 166327 393216 3015852 File Name: +DATA/phub/datafile/llc01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 192240 Index 0 32080 Other 0 2569 Finished backup at 07-OCT-15
4.校验单个数据文件：
RMAN> backup check logical validate datafile 1;Starting backup at 07-OCT-15using channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=+DATA/phub/datafile/system.271.891340857channel ORA_DISK_2: starting full datafile backup setchannel ORA_DISK_2: specifying datafile(s) in backup setincluding current control file in backup setchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:01List of Control File and SPFILE===============================File Type Status Blocks Failing Blocks Examined------------ ------ -------------- ---------------Control File OK 0 646 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07List of Datafiles=================File Status Marked Corrupt Empty Blocks Blocks Examined High SCN---- ------ -------------- ------------ --------------- ----------1 OK 0 14660 98639 3880343 File Name: +DATA/phub/datafile/system.271.891340857 Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 65879 Index 0 13480 Other 0 4541 Finished backup at 07-OCT-15
5.备份进度查询：
select case when opname like '%aggregate%' then 'total' else opname end opname, trunc(sofar * 100 / totalwork, 2) || '%' progress, units from v$session_longops where opname like 'RMAN%' and totalwork > sofar;
OPNAME PROGRESS UNITS------------------------------------------------------------ ----------------------------------------- --------------------------------RMAN: incremental datafile backup 62.28% Blockstotal 0% BlocksRMAN: incremental datafile backup 75.47% Blocks
6.恢复进度查询：
SELECT sid, serial#, CONTEXT, sofar, totalwork, round(sofar / totalwork * 100, 2) "% Complete" FROM v$session_longops WHERE opname LIKE 'RMAN:%' AND opname NOT LIKE 'RMAN: aggregate%';
SID SERIAL# CONTEXT SOFAR TOTALWORK % Complete---------- ---------- ---------- ---------- ---------- ---------- 8 5 1 329181437312 75.27 192 31 1 281220456096 61.66
恢复完成：
SELECT sid, serial#, CONTEXT, sofar, totalwork, round(sofar / totalwork * 100, 2) "% Complete" FROM v$session_longops WHERE opname LIKE 'RMAN:%' 9 AND opname NOT LIKE 'RMAN: aggregate%'; SID SERIAL# CONTEXT SOFAR TOTALWORK % Complete---------- ---------- ---------- ---------- ---------- ---------- 8 5 1 437312437312 100 192 31 1 456096456096 100
简单备份脚本：
run{allocate channel C1 device type disk maxpiecesize=51200M;allocate channel C2 device type disk maxpiecesize=51200M;sql 'alter system switch logfile';crosscheck archivelog all;delete noprompt expired archivelog all;delete noprompt archivelog until time 'sysdate-15';backup incremental level=0 tag='db0' as compressed backupset database include currentcontrolfile format '/back/level0/df_%U.bak';release channel C1;release channel C2;crosscheck backup;delete noprompt obsolete;delete noprompt expired backup;}
备份
数据
文件
日志
进度
查询
检查
成功
副本
单个
数据库
脚本
应用
验证
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
广西一站网网络技术集团
云服务器云计算机
校园网络安全设计方案
当前网络安全工作的重点
无锡软件开发条件
服务器机柜维修项目报价
国家网络安全员是谁
软件开发即征即退手续
JAVA数据库课程设计题目
网络安全法可以走简易程序吗
应用商店出现无法连接服务器
我的世界类似商店的服务器推荐
网络安全mod
网络安全现在就业前景
网络安全法pdf版
执法监督平台建设软件开发
富宁县不动产数据库软件
天津诚信网络技术开发哪家好
黄埔网络数据库维护怎么收费
精易通洗浴管理系统建立新服务器
华为x服务器
服务器警告申诉原因英文
新华互联网科技新闻
软件开发人员价值评价
数据库api生成框架
boa服务器安全
恒生软件开发外包
软件开发工程师工资表
运营商网络安全运营
网络安全二百写
