有热备的system表空间损坏的恢复

热备份system表空间SQL> alter tablespace system beginbackup; Tablespace altered. SQL> ！cp /u01/tiger/oradata/orcl2/system01.dbf/bk SQL> alter tablespace system end backup; Tablespace altered然后做一些交易再毁掉system表空间的文件切换日志的时候会出错SQL> ！cp /etc/passwd/u01/tiger/oradata/orcl2/system01.dbf SQL> alter system switch logfile;alter system switch logfile*ERROR at line 1:ORA-03113: end-of-file on communicationchannel我们重新连接数据库SQL> conn /as sysdbaConnected to an idle instance.SQL> startupOracle instance started. Total System Global Area 314572800 bytesFixed Size 1219136 bytesVariable Size 121636288 bytesDatabase Buffers 184549376 bytesRedo Buffers 7168000 bytesDatabase mounted.ORA-01122: database file 1 failedverification checkORA-01110: data file 1:"/u01/tiger/oradata/orcl2/system01.dbf"ORA-01251: Unknown File HeaderVersion read for file number 1查询需要恢复的文件SQL> select * from v$recover_file; FILE# ONLINE ONLINE_ ERROR CHANGE# TIME---------- ------- --------------------------- ---------- --------- 1 ONLINE ONLINE WRONG FILE TYPE 0得知1号文件需要恢复查看恢复所需要的归档 SQL> select * from v$recovery_log; no rows selected这时候看见没有需要的归档日志这时候把之前备份的是system01.dbf文件拷贝过来SQL> ！cp /bk/system01.dbf/u01/tiger/oradata/orcl2/system01.dbf重新查看没有恢复的文件了，SQL> select * from v$recover_file; FILE# ONLINE ONLINE_ ERROR CHANGE# TIME---------- ------- --------------------------- ---------- --------- 1 ONLINE ONLINE 540503 06-SEP-12看一下恢复的归档文件SQL> select * from v$recovery_log; THREAD# SEQUENCE# TIME---------- ---------- ---------ARCHIVE_NAME------------------------------------------------------------------------------------------------------------------------ 1 1 06-SEP-12/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_06/o1_mf_1_1_84jo2spj_.arc 1 2 06-SEP-12/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_06/o1_mf_1_2_84jo2vxd_.arc 1 3 06-SEP-12/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_06/o1_mf_1_3_84jo366c_.arcSQL> recover datafile 1; 恢复数据文件1号文件ORA-00279: change 540503 generated at09/06/2012 14:31:27 needed for thread 1ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_06/o1_mf_1_1_%u_.arcORA-00280: change 540503 for thread 1 is insequence #1 Specify log: {<RET>=suggested |filename | AUTO | CANCEL} <RET>=suggested 回车系统自己去查找 filename 手动指明写日志或归档的文件位置 AUTO 系统自动去查找 cancel 取消恢复autoalter database openOracle 备份恢复：flashback闪回有备份的users表空间的损坏恢复相关资讯 Oracle 备份恢复

有备份的users表空间的损坏恢复（09/08/2012 13:36:03）

Oracle 备份恢复：flashback闪回（09/08/2012 13:33:09）

本文评论查看全部评论（0）