各位大侠:
oracle11g,Windows平台,运行在非归档模式。数据库不能恢复。请帮忙!
alter日志报错如下:
ORA-00368: ????????????
ORA-00353: ??????? 14187 ?? 20575028 ?? 05/07/2017 16:10:27
ORA-00312: ???? 3 ?? 1: 'F:\APP\ADMINISTRATOR\ORADATA\WATER\REDO03.LOG'
SQL> conn /as sysdba
已连接到空闲例程。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 8919027712 bytes
Fixed Size 2183032 bytes
Variable Size 3858759816 bytes
Database Buffers 5033164800 bytes
Redo Buffers 24920064 bytes
数据库装载完毕。
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
系统已更改。
SQL> recover database using backup controlfile until cancel;
ORA-00279: 更改 20677969 (在 05/07/2017 19:01:34 生成) 对于线程 1 是必需的
ORA-00289: 建议:
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\WATER\ARCHIVELOG\2017_05_07\O1_MF_1_1_%
U_.ARC
ORA-00280: 更改 20677969 (用于线程 1) 在序列 #1 中
指定日志: {=suggested | filename | AUTO | CANCEL}
F:\app\Administrator\oradata\WATER\REDO03.LOG
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: 'F:\APP\ADMINISTRATOR\ORADATA\WATER\REDO03.LOG'
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\APP\ADMINISTRATOR\ORADATA\WATER\SYSTEM01.DBF'
SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结尾
进程 ID: 2084
会话 ID: 5 序列号: 3
SQL>
SQL> conn /as sysdba
已连接到空闲例程。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 8919027712 bytes
Fixed Size 2183032 bytes
Variable Size 3858759816 bytes
Database Buffers 5033164800 bytes
Redo Buffers 24920064 bytes
数据库装载完毕。
SQL> recover database until cancel;
ORA-00279: 更改 20677973 (在 05/07/2017 19:02:36 生成) 对于线程 1 是必需的
ORA-00289: 建议:
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\WATER\ARCHIVELOG\2017_05_07\O1_MF_1_1_%
U_.ARC
ORA-00280: 更改 20677973 (用于线程 1) 在序列 #1 中
指定日志: {=suggested | filename | AUTO | CANCEL}
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\APP\ADMINISTRATOR\ORADATA\WATER\SYSTEM01.DBF'
SQL> 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开