Switchover please please follw in order wise

Hi,

I had attached the two doctuments for doing switchover .

first to make

1. switch over to standby
2. then we have to do switchover to primary.

Thanks

1. Switch over to standby:

1. For doing switch over We have to check the primary and standby must be in sync
2. and check we had a propoer backup  for the database so that if anything goes wrong it would be helpful
3. We can make two standby at a time . but we can t make two primaries at a time if that happens maximum times we have to rebuild dr database.
4. Need to check the prarameters to be same on both primary and standby
5. Take a backup of services , stat jobs, partisions jobs , if these kind of jobs are there we have to comment for a while and make sure that we enable after switch over.
6. Basic step first we have to make primary to standby and then standby to primary.
7. On DR side we have to bring the alll instances down except the one mrp is runing on the rac environment.


SQL> select host_name,open_mode,database_role from gv$instance;
SQL> shut immediate [shut down on node2, node3]
SQL> select host_name,open_mode,database_role from gv$instance;
need to check whether FLASH BACK is enabled or not
SQL> sho parameter flash
SQL> create restore point restorepointname guarantee flashback database; [after 11g databases if it is below create restore point restorepointname;]
SQL> select * from v$restore_point;
once the switchover completes successfully we have to make sure the restore point has to be removed.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

SQL> shut immediate [on node1]
and
SQL> startup mount [on threee nodes]

*******************
droping restore point
SQL> drop restore point restorepointname;
if some thing goes wrong and we have to bring
SQL> flashback to restorepointname;



2. Switch over to primary:

1. For doing switch over We have to check the primary and standby must be in sync
2. and check we had a propoer backup  for the database so that if anything goes wrong it would be helpful
3. We can make two standby at a time . but we can t make two primaries at a time if that happens maximum times we have to rebuild dr database.
4. Need to check the prarameters to be same on both primary and standby
5. Take a backup of services , stat jobs, partisions jobs , if these kind of jobs are there we have to comment for a while and make sure that we enable after switch over.
6. Basic step first we have to make primary to standby and then standby to primary.
7. On DR side we have to bring the alll instances down except the one mrp is runing on the rac environment.


SQL> select host_name,open_mode,database_role from gv$instance;
SQL> shut immediate [shut down on node2, node3] except the one mrp is running.
SQL> select host_name,open_mode,database_role from gv$instance;
need to check whether FLASH BACK is enabled or not
SQL> sho parameter flash
SQL> create restore point restorepointname guarantee flashback database; [after 11g databases if it is below create restore point restorepointname;]
SQL> select * from v$restore_point;
once the switchover completes successfully we have to make sure the restore point has to be removed.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

once all these completes we have to make sure backups and jobs are started and validate services.
start the MRP on DR side and check the sync with primary.


SQL> alter database open; on all the nodes
*******************
droping restore point
SQL> drop restore point restorepointname;
if some thing goes wrong and we have to bring
SQL> flashback to restorepointname;

Thanks,