急！多功controlfile后无法打开数据库

cscoxubin

sqlplusw /nolog
conn sys/admin as sysdba
增加一个control04.ctl文件
alter system set control_files=
'c:\oracle\oradata\myoracle\control01.ctl','c:\oracle\oradata\myoracle\control02.ctl',
'c:\oracle\oradata\myoracle\control03.ctl','c:\oracle\oradata\myoracle\control04.ctl'
scope=spfile;

shutdown immediate

到os中建设control04.ctl
重新starup
select  * from v$controlfile;
可得到4个文件


但重启计算机后数据库可mount　但无法打开

会出现　要打开数据库必须使用resetlogs或norestlogs选项。

johnz02

我想大概是controfile的时间和datafile的时间有差异。
1） backup all your current controfiles to somewhere.
2)  compare the timestamp of controfiles and datafiles like system01.dbf.
3)  use only the controfiles that have the same timestamp as the datafiles. If necessary, overwrite controfiles whose timestamp are different from that of datafiles with the correct controfiles.
4) try to start db. If db still can not start, BACKUP all your controfiles before do something else.

HTH

John

remen

你怎么重新建立的ctl

doni

LZ做的不对,应该这样
shutdown
cp file in OS
startup nomount
alter system ... (add control file)
alter database open

that's OK

zydudu

搞错顺序了