搭建中备库alter database mount standby database报错

张沛

环境：

1. SYS@PROD>select * from v$version;
   
2. 
   
3. BANNER
   
4. ----------------------------------------------------------------
   
5. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
   
6. PL/SQL Release 10.2.0.1.0 - Production
   
7. CORE    10.2.0.1.0      Production
   
8. TNS for Linux: Version 10.2.0.1.0 - Production
   
9. NLSRTL Version 10.2.0.1.0 - Production

复制代码

Primary Database xxxx
Standby Database  yyyy
参照官档http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i63561做的实验
在执行到Standby Database
startup nomount
alter database mount standby database;
ERROR at line 1:
ORA-01665: control file is not a standby control file
alert日志中记录信息

MMNL started with pid=12, OS id=4079
Sun Apr 14 14:58:09 2013
alter database mount standby database
Sun Apr 14 14:58:14 2013
Setting recovery target incarnation to 1
ORA-1665 signalled during: alter database mount standby database...
不知道是什么引起的错误，望大神们看看
（主库能open，日志文件等都传到Standby Database中
[oracle@secdb1 disk1]$ ls
control1.ctl  log6b.rdo  log9b.rdo     redo03.log    system01.dbf
log10a.rdo    log7a.rdo  redo01_b.log  redo04_a.log  temp01.dbf
log10b.rdo    log7b.rdo  redo01.log    redo04_b.log  temp1.dbf
log11a.rdo    log8a.rdo  redo02_b.log  redo05_a.log  temp2.dbf
log11b.rdo    log8b.rdo  redo02.log    redo05_b.log  undotbs01.dbf
log6a.rdo     log9a.rdo  redo03_b.log  sysaux01.dbf  users.dbf
）

renjixinchina

ORA-01665: control file is not a standby control file
提示的很明显

张沛

找到错误了，控制文件的问题，不好意思，耽误大家时间了