Home » » Creating Physical Standby Controlfile

Creating Physical Standby Controlfile

Written By Srikrishna Murthy Annam on Wednesday, December 7, 2011 | 12:46 PM

  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
On Standby Server :
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 :
STEP 3 : 
[oracle@dgaskmpri01 ~]$ sqlplus '/as sysdba'
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 :
STEP 5 :
[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
SRI
Share this article :

Related Articles By Category



Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger