OraFAQ Forum: Data Guard » DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY

Home » Server Options » Data Guard » DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY [message #300659]

Sun, 17 February 2008 09:47

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

Report message to a moderator

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

ebrian
Messages: 2786
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.

Report message to a moderator

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

BlackSwan
Messages: 20109
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