SQL> recover database using backup controlfile
ORA-00279: ???? 2375142 ??? 06/29/2002 08:54:42 ? (???? 1 ??)
ORA-00289: ?? : D:\ORACLE\ORA81\RDBMS\ARC04465.001
ORA-00280: ?? 2375142 (???? 1) ???? #4465
指定日誌: {=suggested | filename | AUTO | CANCEL}
d:\oracle\oradata\orcl\redo01.log
ORA-00310: ?????????? 4485; ???????? 4465
ORA-00334: ????: 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG'
SQL> recover database using backup controlfile
ORA-00279: ???? 2375142 ??? 06/29/2002 08:54:42 ? (???? 1 ??)
ORA-00289: ?? : D:\ORACLE\ORA81\RDBMS\ARC04465.001
ORA-00280: ?? 2375142 (???? 1) ???? #4465
指定日誌: {=suggested | filename | AUTO | CANCEL}
d:\oracle\oradata\orcl\redo02.log
ORA-00310: ?????????? 4487; ???????? 4465
ORA-00334: ????: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
SQL> recover database using backup controlfile
ORA-00279: ???? 2375142 ??? 06/29/2002 08:54:42 ? (???? 1 ??)
ORA-00289: ?? : D:\ORACLE\ORA81\RDBMS\ARC04465.001
ORA-00280: ?? 2375142 (???? 1) ???? #4465
指定日誌: {=suggested | filename | AUTO | CANCEL}
d:\oracle\oradata\orcl\redo03.log
ORA-00310: ?????????? 4480; ???????? 4465
ORA-00334: ????: 'D:\ORACLE\ORADATA\ORCL\REDO03.LOG'
加上_allow_resetlogs_corruption = true参数执行后出现下面的结果,上面的大侠,帮帮忙吧!!!
Total System Global Area 190670876 bytes
Fixed Size 75804 bytes
Variable Size 33230848 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
群集已被更改
ALTER DATABASE OPEN RESETLOGS
*
ERROR 在行 1:
ORA-03113: end-of-file on communication channel
ALTER DATABASE RENAME GLOBAL_NAME TO ORCL
*
ERROR 在行 1:
ORA-03114: 未與 ORACLE 相連
大侠按照你的方法我做了,但还是不行,请大侠指教。
以下是经过:
已连接到空闲例程。
SQL> STARTUP MOUNT PFILE=M:\DATABASE\ORCL\INITORCL.ORA
ORACLE 例程已经启动。
Total System Global Area 190670876 bytes
Fixed Size 75804 bytes
Variable Size 33230848 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
ORA-00279: ?? 2401145 (? 07/06/2002 08:32:04 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORA81\RDBMS\ARC00001.001
ORA-00280: ?? 2401145 ???? 1 ???? # 1 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: ??: RECOVER ??? OPEN RESETLOGS ???????
ORA-01194: ??1?????????????
ORA-01110: ???? 1: 'M:\DATABASE\ORCL\SYSTEM01.DBF'
ORA-01112: ???????
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
ORA-00279: ?? 2401145 (? 07/06/2002 08:32:04 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORA81\RDBMS\ARC00001.001
ORA-00280: ?? 2401145 ???? 1 ???? # 1 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
M:\DATABASE\ORCL\REDO01.LOG
已应用的日志。
完成介质恢复。
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR 位于第 1 行:
ORA-00600: ??????????: [25012], [1], [2], [], [], [], [], []
大侠根据你的方法做了,但最后还是出错了,请大侠再看看
Microsoft Windows 2000 [Version 5.00.2195]
(C) 版权所有 1985-1998 Microsoft Corp.
F:\Documents and Settings\Administrator>set ORACLE_SID=ORCL
F:\Documents and Settings\Administrator>SQLPLUS /NOLOG
SQL*Plus: Release 8.1.7.0.0 - Production on 星期六 7月 6 15:23:21 200
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> CONNECT /AS SYSDBA
已连接到空闲例程。
SQL> @M:\DATABASE\ORCL\TRACE.SQL
ORACLE 例程已经启动。
Total System Global Area 27547676 bytes
Fixed Size 75804 bytes
Variable Size 11665408 bytes
Database Buffers 15728640 bytes
Redo Buffers 77824 bytes
控制文件已创建
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR 位于第 1 行:
ORA-01589: ??????????? RESETLOGS ? NORESETLOGS ??
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR 位于第 1 行:
ORA-01194: ??1?????????????
ORA-01110: ???? 1: 'M:\DATABASE\ORCL\SYSTEM01.DBF'
SQL> RECOVER DATABASE
ORA-00283: ??????????
ORA-01610: ?? BACKUP CONTROLFILE ??????????
SQL> recover database using backup controlfile
ORA-00279: ?? 2375142 (? 06/29/2002 08:54:42 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORA81\RDBMS\ARC04465.001
ORA-00280: ?? 2375142 ???? 1 ???? # 4465 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
CANCEL
介质恢复已取消。
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR 位于第 1 行:
ORA-01113: ?? 1 ??????
ORA-01110: ???? 1: 'M:\DATABASE\ORCL\SYSTEM01.DBF'
SQL> alter database clear logfile group 1;
数据库已更改。
SQL> alter database clear logfile group 2;
数据库已更改。
SQL> alter database clear logfile group 3;
数据库已更改。
SQL> recover database using backup controlfile
ORA-00279: ?? 2375142 (? 06/29/2002 08:54:42 ??) ???? 1 ????
ORA-00289: ??: F:\ORACLE\ORA81\RDBMS\ARC04465.001
ORA-00280: ?? 2375142 ???? 1 ???? # 4465 ???
指定日志: {=suggested | filename | AUTO | CANCEL}
M:\DATABASE\ORCL\REDO01.LOG
ORA-00339: ???????????
ORA-00334: ????: 'M:\DATABASE\ORCL\REDO01.LOG'
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ----------
1 1 0 1048576 1 YES
UNUSED 0
2 1 0 1048576 1 YES
UNUSED 0
3 1 0 1048576 1 YES
CURRENT 0
SQL> shutdown
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> STARTUP PFILE=M:\DATABSE\ORCL\INITORCL.ORA
LRM-00109: 无法打开参数文件 'M:\DATABSE\ORCL\INITORCL.ORA'
ORA-01078: 处理系统参数失败
SQL> STARTUP PFILE=M:\DATABASE\ORCL\INITORCL.ORA
ORACLE 例程已经启动。
Total System Global Area 27547676 bytes
Fixed Size 75804 bytes
Variable Size 11665408 bytes
Database Buffers 15728640 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
ORA-01589: ??????????? RESETLOGS ? NORESETLOGS ??
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ----------
1 1 0 1048576 1 YES
UNUSED 0
2 1 0 1048576 1 YES
UNUSED 0
3 1 0 1048576 1 YES
CURRENT 0
SQL> alter database open resetlogs;
数据库已更改。
SQL> SELECT * FROM EMC.ARS2M02
2 /
SELECT * FROM EMC.ARS2M02
*
ERROR 位于第 1 行:
ORA-12571: TNSacket writer failure
SQL> select * from scott.dept;
select * from scott.dept
*
ERROR 位于第 1 行:
ORA-03114: 未连接到 ORALCE
SQL> SHUTDOWN
ORA-01012: not logged on
SQL> EXIT
F:\Documents and Settings\Administrator>SQLPLUS /NOLOG
SQL*Plus: Release 8.1.7.0.0 - Production on 星期六 7月 6 15:36:16 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> CONNECT /AS SYSDBA
ERROR:
ORA-01092: ORACLE instance terminated. Disconnection forced