ora-01665 解决办法

最新推荐文章于 2021-04-15 00:51:35 发布

iteye_9368

最新推荐文章于 2021-04-15 00:51:35 发布

阅读量1.6k

点赞数

文章标签：数据库

本文提供了一套详细的步骤来解决ORA-01665错误，该错误通常发生在Oracle数据库的物理备用控制文件不是备用控制文件的情况下。通过停止管理恢复进程、关闭备用数据库、从主数据库创建新的物理备用控制文件并使用操作系统工具复制到备用数据库等步骤，可以有效地解决此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-01665: controlfile is not a standby controlfile

Follow these Steps if you have to recreate the Physical Standby Controlfile:

1. Stop Managed Recovery Process on the Standby Database (if still running):
SQL> alter database recover managed standby database cancel;

2. Shutdown the Standby Database:
SQL> shutdown immediate;

3. Connect to the Primary Database as SYS:

SQL> connect sys/<Password>@<Primary> as sysdba
4. Create a new Physical Standby Controlfile from the Primary:
SQL> alter database create standby controlfile as '<File-Specification>';

5. Copy the new created Standby Controlfile to the Standby Database using OS-Tools (eg. cp or ftp) and replace the current Standby Controlfile with the new created one.

6. Mount the Standby Database with the new Standby Controlfile:
SQL> startup nomount
SQL> alter database mount standby database;

7. Start Managed Recovery again:

SQL> alter database recover managed standby database disconnect [using current logfile];