我的重建db的步骤如下:
1。在DB1上failover , DB1变成了primary, DB2变成了standby(disable)
2。在DB2上依次执行下面步骤:
a. 登录db1执行下面语句得到scn
SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V\\$DATABASE;
b. mount db2 and restore until scn
RESTORE DATABASE UNTIL SCN $scn;
c. RECOVER DATABASE UNTIL SCN $scn;
d.ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
下面报错:
ALTER DATABASE CONVERT TO PHYSICAL STANDBY
*
ERROR at line 1:
ORA-01672: control file may be missing files or have extra ones
事实上,我好像应该在a之前作 alter database create standby controlfile as '+DATA/service_id/CONTROLFILE/stdcotrl.ctl';
另外我的系统是ASM上放置datafile和controlfile
[ 本帖最后由 wxdlsj 于 2008-1-22 11:59 编辑 ]
在asm中, '+DATA/service_id/CONTROLFILE‘中已经有个老的controlfile,当我执行下面命令是不成功
alter database create standby controlfile as '+DATA/service_id/CONTROLFILE/stdcotrl.ctl';
谁有ASM上的经验?