RMAN> restore database preview;
1,完全还原确定需应用哪个备份集
2,可以看到0级备份和1级备份和将应用的归档日志。
RMAN> restore database validate;
1,检查用于恢复数据库的最新备份集,以确认这个备份是否完整
2,检查恢复所需要的数据文件副本和归档日志备份集,并确认他的完整
3,validate对备份集进行全面验证,确定完整性
可以设置参数 check logical
RMAN> list backupset 可以确定需要检查的备份集所分配的键值
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
23 25.00K DISK 00:00:06 01-SEP-13
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20130901T124724
Piece Name: /u02/oradata/backup/data/checkdb_full_CHECKDB_24_p%_1.dbfbk
确定需要备份集后,利用备份BS Key 值,通过validate backupset检查验证这个备份集
RMAN> validate backupset 23;
Starting validate at 06-SEP-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece /u02/oradata/backup/data/checkdb_full_CHECKDB_24_p%_1.dbfbk
channel ORA_DISK_1: piece handle=/u02/oradata/backup/data/checkdb_full_CHECKDB_24_p%_1.dbfbk tag=TAG20130901T124724
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished validate at 06-SEP-13
二,rman 备份时候,无法监控其运行的进度,v$sesion_longops是一个很好的工具
以下测试:
RMAN> run {
2> allocate channel c1 device type disk to destination '/home/oracle/disk1';
3> allocate channel c2 device type disk to destination '/home/oracle/disk2';
4> backup database;
5> }
观察进度
SQL> select case when opname like '%aggregate%' then 'total'
2 else
3 opname end opname,
4 trunc(sofar*100/totalwork,2)||'%' progress, units
5 from v$session_longops
6 where opname like 'RMAN%' and totalwork>sofar;
OPNAME
----------------------------------------------------------------
PROGRESS UNITS
----------------------------------------- --------------------------------
total
38.06% Blocks
RMAN: full datafile backup
39.64% Blocks
RMAN: full datafile backup
55.46% Blocks
三,查看恢复进度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%';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-1063407/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15187685/viewspace-1063407/