一、重新创建控制文件的步骤
1、备份一个控制文件出来
alter database backup controlfile to trace as ‘G:\ctl1.txt’;
2、设置集群为false
alter system set cluster_database=false scope=spfile;
3、把数据库关闭,并启动到nomount状态
shutdown immediate;
startup nomount;
4、重新创建控制文件(根据自己环境下的创建,从G:\ctl1.txt这个文件中获取)
CREATE CONTROLFILE REUSE DATABASE “ogfsdb” NORESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 8192
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_1.257.1060722359’ SIZE 100M BLOCKSIZE 512,
GROUP 2 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_2.258.1060722365’ SIZE 100M BLOCKSIZE 512,
GROUP 3 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_3.266.1060723829’ SIZE 100M BLOCKSIZE 512,
GROUP 4 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_4.267.1060723835’ SIZE 100M BLOCKSIZE 512,
GROUP 5 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_5.259.1060722369’ SIZE 100M BLOCKSIZE 512,
GROUP 6 ‘+DGSYSTEM1/ogfsdb/onlinelog/group_6.268.1060723839’ SIZE 100M BLOCKSIZE 512
– STANDBY LOGFILE
DATAFILE
‘+DGSYSTEM1/ogfsdb/datafile/system.260.1060722373’,
‘+DGSYSTEM1/ogfsdb/datafile/sysaux.261.1060722409’,
‘+DGSYSTEM1/ogfsdb/datafile/undotbs1.262.1060722437’,
‘+DGSYSTEM1/ogfsdb/datafile/undotbs2.264.1060722459’,
‘+DGSYSTEM1/ogfsdb/datafile/users.265.1060722469’
CHARACTER SET ZHS16GBK
;
5、打开数据库
alter database open;