Oracle Data Guard - Standby Database Location
317715Apr 6 2009 — edited Apr 6 2009A basic question probably, but an important one for me! Is it possible to have the standby database on the same production server as the primary DB server?
I thought we cannot, because you cannot have 2 databases with the same name on the same server. However, reading Oracle's data Guard - Concepts and Administration document, it says in chapter 1 -
"There are no restrictions on where the databases are located, provided they can communicate with each other. For example, you can have a standby database on the same system as the production database.........."
I tried setting up a database with standby on the same server, and it failed with an error (sorry dont have the error code right now, on my home laptop)....and the error description was about not being able to have 2 databases with the same name. So how does one achieve having the standby on the same server as the primary?