报ORA-01665错误

在备库启动时报错。
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01665: control file is not a standby control file

解决方法：
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/ora/u01/oradata/db/douyaqiang.ctl'';
重建备库控制文件，然后下面的操作；
SQL> show parameter pfile


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /ora/u01/product/10.2.0.1/db_1
                                                 /dbs/spfiledb.ora
SQL> create pfile from spfile;


File created.

修改pfile文件中控制文件
[oracle@linux5 dbs]$ more initdb.ora
db.__db_cache_size=159383552
db.__java_pool_size=4194304
db.__large_pool_size=4194304
db.__shared_pool_size=113246208
db.__streams_pool_size=0
*.audit_file_dest='/ora/u01/admin/db/adump'
*.background_dump_dest='/ora/u01/admin/db/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/ora/u01/oradata/db/douyaqiang.ctl'
#*.control_files='/ora/u01/oradata/db/control01.ctl','/ora/u01/oradata/db/control02.ctl','/ora/u01/oradata/db/control03.ctl
重建spfile
 create spfile from pfile;


File created.


SQL> startup nomount;
ORACLE instance started.


Total System Global Area  285212672 bytes
Fixed Size                  2020224 bytes
Variable Size             121638016 bytes
Database Buffers          159383552 bytes
Redo Buffers                2170880 bytes
SQL> alter database mount standby database;


Database altered.