This content has been marked as final. Show 2 replies
The detailed procedure for anything in Oracle more complex than
requires a version number. Since you thought it unimportant to provide that no help is possible.
SELECT * FROM dual
In this case, in addition to the version number, little things such as:
1. What type of Data Guard implementation? Active? Logical? Snapshot Standby? would be useful information for anyone trying to help you.
2. Is this stand-alone or RAC? Again you provide no information and this is critically important?
3. What is the geographical distance between the primary and the standby?
4. What is the protection mode?
If you are not a student you need to read the Oracle online docs and understand the technology. To ask this question, without providing obviously essential information, indicates you may be a danger to your database: Something I am sure you do not wish to be.
The database versions are all 10.2.0.4. The 2 data guards are active physical standby with max performance. One dataguard server is at New Jersey and the other one is at Atlanta here local. We would like to switch over to the local one from primary DB.