最近在做stream实验,主库stream1,从库stream2
我把主库安装好后直接拷贝到丛库中,才发现所有文件都是stream1,至此犯了一个错误
于是开始从参数文件开始修改,当mount状态的时候:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name STREAM1 in file header does not match given name of
STREAM2
ORA-01110: data file 1: '/u01/app/oracle/oradata/stream2/system01.dbf'
出现了预料的错误,进而重建控制文件,在trace中找到脚本后,重建
注意:resuse 替换set NORESETLOGS 替换resetlogs
再次出现:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/stream2/system01.dbf'
原因是datafile和control没同步
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
shutdown
alter open resetlogs 的时候 最后出现
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/stream2/system01.dbf'
需要实例恢复
SQL> recover datafile 1;
Media recovery complete.
或干脆(一般不用):
startup mount
alter database datafile filename offline drop;
alter database open;
至此一切 ok