使用RMAN验证备份的有效性
生活随笔
收集整理的這篇文章主要介紹了
使用RMAN验证备份的有效性
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
--驗(yàn)證控制文件和參數(shù)文件:
RMAN> restore validate controlfile;Starting restore at 22-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISKchannel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_5_1
channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_5_1 tag=TAG20140722T095956
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
Finished restore at 22-JUL-14RMAN> restore validate spfile;Starting restore at 22-JUL-14
using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_6_1
channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_6_1 tag=TAG20140722T095956
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
Finished restore at 22-JUL-14--驗(yàn)證全備份 一般會(huì)很慢
RMAN> restore validate database;Starting restore at 22-JUL-14
using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_4_1
channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_4_1 tag=TAG20140722T095956
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_3_1
channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_3_1 tag=TAG20140722T095956
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
Finished restore at 22-JUL-14RMAN>
?
總結(jié)
以上是生活随笔為你收集整理的使用RMAN验证备份的有效性的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: 安卓中AIDL的使用方法快速入门
- 下一篇: 程序员如何保证我们的代码质量