【Vegas原创】ORA-01103："database name *** in control file is not @@@" 解决

解决方法：重建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'

 

     4） open resetlog

SQL> ALTER DATABASE OPEN RESETLOGS;