- 论坛徽章:
- 0
|
Oracle数据库联机日志文件丢失处理方法(总结)!
下面是我遇到的问题,请教怎么解决不了?
SQL>; connect internal/oracle as sysdba
已连接到空闲例程。
SQL>; startup open
ORACLE 例程已经启动。
Total System Global Area 545252620 bytes
Fixed Size 70924 bytes
Variable Size 142057472 bytes
Database Buffers 403046400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
ORA-00314: ?? 2 (?? 1)????? 47258 ? 47261 ???
ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
以下是我作的恢复步骤,怎么不成功,请教
SQL>; shutdown immediate
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>; startup mount
ORACLE 例程已经启动。
Total System Global Area 545252620 bytes
Fixed Size 70924 bytes
Variable Size 142057472 bytes
Database Buffers 403046400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL>; select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 47257 NO INACTIVE
2 47258 NO ACTIVE
3 47259 NO CURRENT
SQL>; alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 2
*
ERROR 位于第 1 行:
ORA-01624: ??2?????????1
ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
SQL>; shutdown immediate
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>; startup open
ORACLE 例程已经启动。
Total System Global Area 545252620 bytes
Fixed Size 70924 bytes
Variable Size 142057472 bytes
Database Buffers 403046400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
ORA-00313: ??????? 2 (?? 1) ???
ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND<~
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#
SQL>; select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 47257 NO INACTIVE
2 47258 NO ACTIVE
3 47259 NO CURRENT
SQL>; alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 2
*
ERROR 位于第 1 行:
ORA-01624: ??2?????????1
ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
SQL>; shutdown immediate
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
在init<sid>;.ora中加入如下参数
_allow_resetlogs_corruption=TRUE
SQL>; startup mount
ORACLE 例程已经启动。
Total System Global Area 545252620 bytes
Fixed Size 70924 bytes
Variable Size 142057472 bytes
Database Buffers 403046400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL>;
SQL>; recover database until cancel;
ORA-00279: ?? 7902963519486 (? 09/26/2005 10:25:41 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\ORA81\RDBMS\ARC47258.001
ORA-00280: ?? 7902963519486 ???? 1 ???? # 47258 ???
指定日志: {<RET>;=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: ??: RECOVER ??? OPEN RESETLOGS ???????
ORA-01194: ??1?????????????
ORA-01110: ???? 1: 'D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-01112: ???????
SQL>;
SQL>; alter database open resetlogs;
alter database open resetlogs
*
ERROR 位于第 1 行:
ORA-00603: ORACLE server session terminated by fatal error |
|