First, I would like to thank mseberg for his wonderful replies on thread: Setting up Data Guard
Anyway, I am running 18.104.22.168 on Solaris 10 with standard file system layout (no ASM) and I am setting up a test environment using 22.214.171.124 on Linux to mimic our production environment. Unfortunately, we don't have another Solaris environment for me to use, so I am using a VM and running linux 5.7.
So, my first question deals with our existing configuration where the primary and standby databases have the same ORACLE_SID.
The service_names and db_unique_name are same as the ORACLE_SID except they are suffixed with DG1 (on primary) and DG2 on standby).
In order for me to mimic this type of setup, are there any good instructions for this.
All the instructions I find use separate ORACLE_SIDs for primary and standby.
Thanks in advance for any help you can offer.
Thank you very much!
You can use the ORACLE_SID the way you want. Its as simple as both Primary and Standby have the same DB_NAME, but they have different DB_UNIQUE_NAME.
So if you want to build it with the same ORACLE_SID its as simple as just doing it.
I like to use different but its not required. No good instructions for this that I know of, but I see no reason you cannot just use the instructions you want and keep the ORACLE_SID the way you want.