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

1年前 (2023) 程序员胖胖胖虎阿

102 0 0

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

版权声明：程序员胖胖胖虎阿发表于 2023年9月2日下午11:48。
转载请注明：【Vegas原创】ORA-01103："database name *** in control file is not @@@" 解决 | 胖虎的工具箱-编程导航