Home » Server Options » Data Guard » DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY
DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #300659] Sun, 17 February 2008 09:47 Go to next message
patelvijudba
Messages: 1
Registered: February 2008
Location: MI
Junior Member
Hi

This is Vijay.
I have a question : How to Configure Standby on the same system as primary ? I have confusion for init parameter file for both primary and standby.

Thanks,

Vijay
Re: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #300662 is a reply to message #300659] Sun, 17 February 2008 11:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It's bascially Creating a Standby Database with a Different Directory Structure.

Follow this process along with Creating a Physical Standby Database and you'll have all you need.
Re: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #300672 is a reply to message #300659] Sun, 17 February 2008 14:03 Go to previous messageGo to next message
BlackSwan
Messages: 23178
Registered: January 2009
Senior Member
This can easily by done on V11 using RMAN as follows:

duplicate target database
to dupdb
from active database spfile
parameter_value_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupdb'
set log_file_name_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupdb'
set db_file_name_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupdb';

[Updated on: Sun, 17 February 2008 14:03] by Moderator

Report message to a moderator

icon14.gif  Re: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #306712 is a reply to message #300672] Sun, 16 March 2008 02:33 Go to previous messageGo to next message
kumarkis
Messages: 5
Registered: March 2008
Junior Member
I guess we need to use lock_name_space parameter as well, because both primary and standby database will have same database name......
Re: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #306796 is a reply to message #306712] Sun, 16 March 2008 20:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not only is lock_name_space NOT needed, it has been deprecated. You basically need to ensure DB_UNIQUE_NAME is set appropriately.

icon12.gif  Re: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #306982 is a reply to message #300659] Mon, 17 March 2008 07:20 Go to previous message
kumarkis
Messages: 5
Registered: March 2008
Junior Member
hi...thanx for the info...
Previous Topic: Open mode for Standby Database
Next Topic: not able to apply the recovery in DR site
Goto Forum:
  


Current Time: Wed Dec 24 21:43:25 CST 2014

Total time taken to generate the page: 0.08045 seconds