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

来源：互联网发布：java的try catch 编辑：程序博客网时间：2024/04/29 07:08

热备份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 sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 314572800 bytes

Fixed Size 1219136 bytes

Variable Size 121636288 bytes

Database Buffers 184549376 bytes

Redo Buffers 7168000 bytes

Database mounted.

ORA-01122: database file 1 failedverification check

ORA-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_.arc

SQL> recover datafile 1; 恢复数据文件1号文件

ORA-00279: change 540503 generated at09/06/2012 14:31:27 needed for thread 1

ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_06/o1_mf_1_1_%u_.arc

ORA-00280: change 540503 for thread 1 is insequence #1

Specify log: {<RET>=suggested |filename | AUTO | CANCEL}

<RET>=suggested回车系统自己去查找

filename 手动指明写日志或归档的文件位置

AUTO 系统自动去查找

cancel 取消恢复

auto

alter database open