"Translated from MoS article" method of recreating the control file of the physical standby database

How to recreate the control file for the physical standby database

Reference from:
Steps to recreate a physical Standby controlfile (document ID 459411.1)

Suitable for:
Oracle database-enterprise edition-version 8.1.7.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 29-aug-2014***

Workaround:
Follow these methods to recreate the physical standby controlfile

1. Stop Managed Recovery Process on the Standby database (if still running): sql> ALTER DATABASE recover Managed Stan Dby database cancel;2. Shutdown the Standby database:sql> Shutdown immediate;3. Connect to the Primary Database as sys:sql> connect sys/<password>@<primary> as SYSDBA4. Create a new physical Standby controlfile from the primary:sql> ALTER DATABASE create Standby Controlfile as ' <fi Le-specification> '; 5. Copy the new created Standby Controlfile to the Standby Database using Os-tools (eg. cp or FTP) and replace the current St Andby Controlfile with the new created one.6. Mount the Standby Database with the new Standby controlfile:oracle 8i and 9i (8.x-9.x): Sql> startup Nomountsql    > ALTER DATABASE mount standby database; Oracle 10g and 11g (10.x-11.x): Sql> startup mount7. If the file-structure is different between Primary and Standby Database, you could either rename the File-location (s) in The new Standby controlfile:sql> ALTER DATABASE rename file ' <old filespecification or file#> ' to ' <new filespecification> '; o R set Db_file_name_convert or/and log_file_name_convert init parameters in the standby database.8. Starting with 9i:if you don ' t has Standby redologs proactively on the Primary and want them on the Standby Database or y OU had Standby redologs with this Standby Database before, now add the Standby redologs (again): Sql> alter Database Add standby LogFile Group <group no.> (' filespecification (s) ') size <size> reuse; Seedocument 219344.1:usage, benefits and limitations of Standby Redo Logs (SRL) for further Details about Standby Re DoLogs9. Re-enable Flashback (if Flashback was enabled previously):sql> ALTER DATABASE Flashback off; Sql> ALTER DATABASE Flashback ON;10. Start Managed Recovery again:sql> ALTER DATABASE recover Managed standby database disconnect [using current logfile] ;

"Translated from MoS article" method of recreating the control file of the physical standby database