我的系统是WIN2000 SERVER ORACLE 817,我再做"损坏当前联机日志"的恢复方法的实验,出现了问题,我想用通过备份来恢复,我的步骤是:
1)先用
SQL> select group#,sequence#,archived,status from v$log;查出来现在活动的日志是 GROUP#SEQUENCE# ARC STATUS
------- ---------- --- ----------------
1 35 YES INACTIVE
2 34 YES INACTIVE
3 36 NOCURRENT
2)然后shutdown abort,关闭的数据库(因为我想模拟日志组中有活动的事务)
3)删除F:\Oracle\oradata\test1\redo03
4)startup提示
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: f:\ORACLE\ORADATA\TEST1\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件
SQL> select group#,sequence#,archived,status from v$log;
GROUP#SEQUENCE# ARCHIVED STATUS
---------- ---------- -------- ----------------
1
1 NO CURRENT
2
2 YESINACTIVE
3
3 YESINACTIVE
发现是当前日志
5)SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of thread 1
ORA-00312: online log 3 thread 1: 'F:\ORACLE\ORADATA\TEST1\REDO03.LOG'
6)recover database until cancel;
出现
SQL> recover database until cancel;
ORA-00279: ?? 1946814 (? 06/10/2004 08:32:51 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORADATA\ARCHIVELOG36_1.ARC
ORA-00280: ?? 1946814 ???? 1 ???? # 36 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
cancel;-----------------------------------------------因为归档中只到了ARCHIVELOG35_1.ARC
ORA-00308: ???????? 'cancel;'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND alter database open resetlogs;
alter database open resetlogs
*
ERROR 位于第 1 行:
ORA-01194: ??3?????????????
ORA-01110: ???? 3: 'F:\ORACLE\ORADATA\TEST1\USERS01.DBF'
8)我认为是数据文件有问题,进行了F:\>copy d:\hotlocal\system01.dbf f:\oracle\oradata\test1\
改写 f:\oracle\oradata\test1\SYSTEM01.DBF 吗? (Yes/No/All): y
已复制 1 个文件。
F:\>copy d:\hotlocal\rbs01.dbf f:\oracle\oradata\test1\
改写 f:\oracle\oradata\test1\RBS01.DBF 吗? (Yes/No/All): y
已复制 1 个文件。
SQL> recover database;
ORA-00279: ?? 1926710 (? 06/09/2004 17:33:44 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORADATA\ARCHIVELOG33_1.ARC
ORA-00280: ?? 1926710 ???? 1 ???? # 33 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
F:\Oracle\oradata\test1\archive\TEST1T001S00033.ARC
ORA-00283: ??????????
ORA-00313: ??????? 3 (?? 1) ???
ORA-00312: ???? 3 ?? 1: 'F:\ORACLE\ORADATA\TEST1\REDO03.LOG'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND shutdown immediate;
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area113498140 bytes
Fixed Size
75804 bytes
Variable Size
56754176 bytes
Database Buffers 56590336 bytes
Redo Buffers
77824 bytes
数据库装载完毕。
ORA-01113: ?? 1 ??????
ORA-01110: ???? 1: 'F:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF
进行数据文件的恢复,还是STARTUP不成功.我要怎么办呀??
|