设为首页 加入收藏

TOP

检测ORACLE数据块损坏的方法汇总(二)
2014-11-23 21:42:29 】 浏览:1092
Tags:检测 ORACLE 数据 损坏 方法 汇总
p; RMAN> backup check logical database; Starting backup at 2014-11-05 15:46:14 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/home/app/oraten/oradata/oraten/system01.dbf input datafile fno=00003 name=/home/app/oraten/oradata/oraten/sysaux01.dbf input datafile fno=00002 name=/home/app/oraten/oradata/oraten/undotbs01.dbf input datafile fno=00005 name=/home/app/oraten/oradata/oraten/test01.dbf input datafile fno=00004 name=/home/app/oraten/oradata/oraten/users01.dbf channel ORA_DISK_1: starting piece 1 at 2014-11-05 15:46:14 channel ORA_DISK_1: finished piece 1 at 2014-11-05 15:46:39 piece handle=/home/app/oraten/flash_recovery_area/ORATEN/backupset/2014_11_05/o1_mf_nnndf_TAG20141105T154614_b5mog6kr_.bkp tag=TAG20141105T154614 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 2014-11-05 15:46:40 channel ORA_DISK_1: finished piece 1 at 2014-11-05 15:46:41 piece handle=/home/app/oraten/flash_recovery_area/ORATEN/backupset/2014_11_05/o1_mf_ncsnf_TAG20141105T154614_b5moh030_.bkp tag=TAG20141105T154614 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 2014-11-05 15:46:41 List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 59 Full 545.84M DISK 00:00:17 2014-11-05 15:46:31 BP Key: 41 Status: AVAILABLE Compressed: NO Tag: TAG20141105T154614 Piece Name: /home/app/oraten/flash_recovery_area/ORATEN/backupset/2014_11_05/o1_mf_nnndf_TAG20141105T154614_b5mog6kr_.bkp List of Datafiles in backup set 59 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------- ---- 1 Full 870906 2014-11-05 15:46:14 /home/app/oraten/oradata/oraten/system01.dbf 2 Full 870906 2014-11-05 15:46:14 /home/app/oraten/oradata/oraten/undotbs01.dbf 3 Full 870906 2014-11-05 15:46:14 /home/app/oraten/oradata/oraten/sysaux01.dbf 4 Full 870906 2014-11-05 15:46:14 /home/app/oraten/oradata/oraten/users01.dbf 5 Full 870906 2014-11-05 15:46:14 /home/app/oraten/oradata/oraten/test01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 60 Full 6.80M DISK 00:00:01 2014-11-05 15:46:40 BP Key: 42 Status: AVAILABLE Compressed: NO Tag: TAG20141105T154614 Piece Name: /home/app/oraten/flash_recovery_area/ORATEN/backupset/2014_11_05/o1_mf_ncsnf_TAG20141105T154614_b5moh030_.bkp Control File Included: Ckp SCN: 870915 Ckp time: 2014-11-05 15:46:39 SPFILE Included: Modification time: 2014-11-05 15:16:33

关于rman备份与恢复的验证,可以参照:

http://blog.csdn.net/yidian815/article/details/40824689

5:使用dbms_repair包

关于dbms_repaire包的使用,请参见:

http://blog.csdn.net/yidian815/article/details/40825511

首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle之Check约束实例详解 下一篇Oracle之唯一性约束(UNIQUEConstr..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目