解决方法:重建controlfile:
1)删除现在的controlfile
2)nomount DB
SQL
>
startup nomount;
3)重建
create
controlfile
set
database
"dtberp" resetlogs
LOGFILE
GROUP 1 ' /u01/app/oracle/oradata/dtserp/REDO01.LOG ' SIZE 10M,
GROUP 2 ' /u01/app/oracle/oradata/dtserp/REDO02.LOG ' SIZE 10M,
GROUP 3 ' /u01/app/oracle/oradata/dtserp/REDO03.LOG ' SIZE 10M
DATAFILE
' /u01/app/oracle/oradata/dtserp/bach01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/bach02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/daxon01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/sysaux01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/sysaux02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/system01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/system02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/undotbs01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/users01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/users02.dbf '
LOGFILE
GROUP 1 ' /u01/app/oracle/oradata/dtserp/REDO01.LOG ' SIZE 10M,
GROUP 2 ' /u01/app/oracle/oradata/dtserp/REDO02.LOG ' SIZE 10M,
GROUP 3 ' /u01/app/oracle/oradata/dtserp/REDO03.LOG ' SIZE 10M
DATAFILE
' /u01/app/oracle/oradata/dtserp/bach01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/bach02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/daxon01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/sysaux01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/sysaux02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/system01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/system02.dbf ' ,
' /u01/app/oracle/oradata/dtserp/undotbs01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/users01.dbf ' ,
' /u01/app/oracle/oradata/dtserp/users02.dbf '
4) open resetlog
SQL
>
ALTER
DATABASE
OPEN
RESETLOGS;