ora-01665 解决办法

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];