OraFAQ Forum: Data Guard » Error when duplicate target database for standby from active database

Home » Server Options » Data Guard » Error when duplicate target database for standby from active database (Oracle 11.2.0.3 - Windows 7 64 Bit)

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

Error when duplicate target database for standby from active database [message #633340]

Mon, 16 February 2015 06:20

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Hi,

While creating physical standby database following error occurs -

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/16/2015 17:31:27
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c1 channel at 02/16/2015 17:31:27
ORA-17629: Cannot connect to the remote database server
ORA-17627:
ORA-17629: Cannot connect to the remote database server

Can anyone please help?

Many Thanks in advance

Regards,
Hitesh

Report message to a moderator

Re: Error when duplicate target database for standby from active database [message #633341 is a reply to message #633340]

Mon, 16 February 2015 06:25

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I can't help because I do not know what you did.
However, if you want a demo of the whole process, here it is:
Create a physical standby in ten minutes

Report message to a moderator

Re: Error when duplicate target database for standby from active database [message #633342 is a reply to message #633340]

Mon, 16 February 2015 07:00

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-17629: Cannot connect to the remote database server
 *Cause:  Connecting to the remote server specified by database connect
          string for netowrk file transfer failed.
 *Action: Check additional error messages

ORA-17627: %s
 *Cause:  An error returned by OCI while sending/receiving message from
          remote instance
 *Action: Look at error message and take appropriate action or contact
          Oracle Support Services for further assistance

Report message to a moderator

Re: Error when duplicate target database for standby from active database [message #633376 is a reply to message #633342]

Tue, 17 February 2015 05:04

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Many Thanks for reply

Now as above error occurred so I taken primary database backup and then executed DUPLICATE command using backup so it worked fine, but now the issue is unable to start Primary database, because it now gives following error -

ORA-19698: <path>\REDO01.LOG is from different database: id=1683644139, db_name=STANDBY

Report message to a moderator

Re: Error when duplicate target database for standby from active database [message #633377 is a reply to message #633376]

Tue, 17 February 2015 05:09

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

For information, I am trying to create Physical standby database on same machine (Windows 7-64 Bit) , 11.2.0.3 database.

I created physical standby database using following scripts -

run
{
allocate channel c1 device type disk format '<PATH_Backup>/%u';
backup database plus archivelog;
}
-----
backup current controlfile for standby format '<Path>/standbycontrol.ctl';
-----
duplicate target database for standby dorecover;
....
Post creation of standby database, standby database started but it shows PRIMARY_INSTANCE in v$instance and when trying to start PRIMARY database, it gave error Controlfile conflict so I restored from RMAN but post restore it gave above error - (ORA-19698)

Please help me how to resolve this ?

Many Thanks in advance.

Report message to a moderator

Re: Error when duplicate target database for standby from active database [message #633378 is a reply to message #633377]

Tue, 17 February 2015 05:13

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

First, you need to look up the difference between v$instance.instance_role and v$database.database_role
Second, you need to show your complete RMAN session, not just bits of it.
Third, you need to enclose your copy/paste within [code] tags to make it readable. As described here,
How to use [code] tags and make your code easier to read
or I will not assist.

[Updated on: Tue, 17 February 2015 05:14]

Report message to a moderator

Previous Topic:	Data Guard in 10 minutes: demo today
Next Topic:	Data Guard - Advanced Compression

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:03:39 CST 2025