Home » Server Options » Data Guard » Error when duplicate target database for standby from active database (Oracle 11.2.0.3 - Windows 7 64 Bit)
Error when duplicate target database for standby from active database [message #633340] Mon, 16 February 2015 06:20 Go to next message
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
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 Go to previous messageGo to next message
John Watson
Messages: 7150
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous message
John Watson
Messages: 7150
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 - Advanced Compression
Next Topic: dataguard
Goto Forum:
  


Current Time: Wed Nov 22 12:43:01 CST 2017

Total time taken to generate the page: 0.31820 seconds