Oracle 11g rman备份相关
发表于：2025-11-07 作者：千家信息网编辑
千家信息网最后更新 2025年11月07日，1.验证备份是否可以被成功还原，完全还原确定需应用哪些备份集和归档日志。RMAN> restore database preview;Starting restore at 07-OCT-15usin
千家信息网最后更新 2025年11月07日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安全错误
数据库的锁怎样保障安全
山东大学数据库实验6
安恒信息网络安全人才
网络安全模式鼠标键盘无法使用
博雅数据库二本投挡线四川理科
蓝凌kk服务器默认端口
盂县租房软件开发
网络安全的图书分类号
数据库中一列叫做什么
校企软件开发
思科网络安全认证体系
前景好的网络技术
网络安全技术保障主要有哪些
关于网络安全发言稿200字
关于软件开发中的闭合原则
数据网络技术资费
菲律宾+软件开发工资多少
5g时代网络安全试点
广州10大软件开发公司
数据库粒度之属性加密
深圳市有光网络技术
软件开发难度简述
数据库自动编号怎么解决
合肥软件开发的培训
拓补结构 数据库储存
软件开发设计是商标第几类
app如何搭建服务器
海曙直销软件开发服务
jvm如何从服务器获取内存的
网络技术与发展题目
网络安全宣传片文字
