Thanks for the question, Krishnaprasad.
Asked: February 24, 2018 - 3:46 pm UTC
Last updated: February 25, 2018 - 9:15 am UTC
Version: 9i, 11g
Viewed 1000+ times
You Asked
Hi Team,
I am trying to do manual switch over not by using switch over command , this is just for my learning purpose .
if my understanding about the facts are correct , below are the steps :
1. shutdown the primary copy control file and redo log (current)
2. take it to standby site , rename control file and redo log .
3.start standby from those file it will work as primary switch over.
here my struck in situation where datafile name is different in standby and in primary .
so here i need to do switch datafile all or switch database to copy ???
if environment is file system i.e my datafile are placed in filesystem then switch datafile all can help us .
but if it is placed in ASM will it work or it has some different approach ???
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment