askMLabs

1. Stop Managed Recovery Process On Standby Database
2. Shutdown Standby Database
3. Connect To Primary Database As SYS
4. Create A New Physical Standby Controlfile From The Primary
5. Copy Created Controlfile to Standby Server
6. Mount Standby Database With Newly Created Controlfile
7. Rename Datafiles ( Optional If db_file_name_convert and log_file_name_convert are specified)
8. Create Standby Redo Logs ( Optional )
9. Re-Enable Flashback
10. Start Managed Recovery

STEP 1:

[oracle@dgaskmsby01 ~]$ clear
[oracle@dgaskmsby01 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 27 10:09:21 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database recover managed standby database cancel;
Database altered.

STEP 2:

SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dgaskmsby01 ~]$ clear

On Primary Server :

SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 27 10:10:14 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

STEP 4:

SQL> alter database create standby controlfile as '/tmp/askm/askm_control01.ctl';
Database altered.

On Standby Server :

[oracle@dgaskmsby01 ~]$ cd /tmp/askm
[oracle@dgaskmsby01 askm]$ scp root@192.168.1.34:/tmp/askm/askm_control01.ctl .
root@192.168.1.34's password:
askm_control01.ctl                                                                                                                    100%   10MB   3.3MB/s   00:03
[oracle@dgaskmsby01 askm]$ grep -i controlfile $ORACLE_HOME/dbs/initsbyorcl.ora
*.control_files='/home/oracle/app/oracle/oradata/sbyorcl/s_control01.ctl','/home/oracle/app/oracle/flash_recovery_area/sbyorcl/s_control02.ctl'#Restore Controlfile
[oracle@dgaskmsby01 askm]$ cp askm_control01.ctl /home/oracle/app/oracle/oradata/sbyorcl/s_control01.ctl
[oracle@dgaskmsby01 askm]$ cp askm_control01.ctl /home/oracle/app/oracle/flash_recovery_area/sbyorcl/s_control02.ctl
STEP 6 :
[oracle@dgaskmsby01 askm]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 27 10:12:55 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             348129976 bytes
Database Buffers          100663296 bytes
Redo Buffers                6008832 bytes
Database mounted.
STEP 9 :

SQL> alter database flashback off;
Database altered.
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database flashback on;
Database altered.
STEP 10 :SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.

Reference :  459411.1

Hope It Helps