Re: Standby DB

Fahd,
I was only answering your 3rd question, apologies. It's hard to visit Miracle DBForum and UKOUG in a consecutive way ;-)

Q1:
It is the easiest way to keep DBNAME and instance name the same on both ends. I recommend as much symmetry as possible. It will save you from making mistakes in a failovered situation, finding yourself in a different environment than you are used to.

Q2:
I keep the service name the same on both ends as well. You can choose either to register only the primary database to its listener, or to run separate listeners for the Data Guard connection and for the application. You should only start the 'application' listener on the primary then, to prevent clients from connecting to the standby)

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2004-11-01 at 08:56, fahd mirza wrote:

> Hi Listers,
> I am trying to build a standby database on a different host from the primary. I have some confusions.
> 1- Would the db_name, instance_name must be same on both primary and standby databases?
> 2- Only service_name would be different on both primary and standby databases?
> 3- The third thing is that could anyone please point me to some easy-to-follow material to build up a standby database.
> I will be very very indebted. many many thanks.
> regards,
> Fahd
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l