Home » Server Options » Data Guard » Duplicate DB for Standby (oracle 12c Windows 2012)
Duplicate DB for Standby [message #651137] Wed, 11 May 2016 23:54 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

We are trying to make a File System based Standby from an ASM based Production server,
But we are getting the error message of below.

Starting backup at 09-MAY-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=531 instance=<name> device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/09/2016 17:26:53
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/09/2016 17:26:53
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""



Also I have attached the log file along with it.

Kindly guide me to identify the problem.

Regards
Muktha
Al
Re: Duplicate DB for Standby [message #651140 is a reply to message #651137] Thu, 12 May 2016 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Once again what is the original command?
What are the Data Guard creation specific parameter values?
As always you hide the most important information.

Re: Duplicate DB for Standby [message #651148 is a reply to message #651140] Thu, 12 May 2016 03:06 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

1) It is there in the attachment.
2) I am showing here now.

connect target/**** auxillary sys/<password>@prodaux

run {			
SET NEWNAME FOR DATAFILE 1 to '<path>\system01.dbf';
SET NEWNAME FOR DATAFILE 2 to '<path>\undotbs02.dbf';
SET NEWNAME FOR DATAFILE 3 to '<path>\sysaux01.dbf';
SET NEWNAME FOR DATAFILE 4 to '<path>\ORA_MASTER_1101.dbf';
SET NEWNAME FOR DATAFILE 5 to '<path>\undotbs01.dbf';
SET NEWNAME FOR DATAFILE 6 to '<path>\USERS01.dbf';
SET NEWNAME FOR DATAFILE 7 to '<path>\ORA_TRANS_1201.dbf';
SET NEWNAME FOR DATAFILE 8 to '<path>\ORA_TRANS_INDEX_1301.dbf';
SET NEWNAME FOR DATAFILE 9 to '<path>\ORA_MASTER_INDEX_1401.dbf';
SET NEWNAME FOR DATAFILE 10 to '<path>\ORA_HIST_1501.dbf';
SET NEWNAME FOR DATAFILE 11 to '<path>\ORA_SYSCONFG01.dbf';
SET NEWNAME FOR DATAFILE 12 to '<path>\ORA_ADMIN01.dbf';
SET NEWNAME FOR DATAFILE 13 to '<path>\ORA_TRANS_1202.dbf';
SET NEWNAME FOR DATAFILE 14 to '<path>\sysaux02.dbf';
SET NEWNAME FOR DATAFILE 15 to '<path>\ORA_TRANS_1203.dbf';
 SET NEWNAME FOR TEMPFILE 1 TO '<path>\temp01.dbf'; 
duplicate target database for standby from active database 
dorecover
nofilenamecheck;
}


3) We made pfile from primary, then created instance in standby.
4) PASSWORD files were copied into the standby.
5) Up the instance with pfile.
6) Then applying the above mentioned command.

Regards
Muktha
Re: Duplicate DB for Standby [message #651152 is a reply to message #651148] Thu, 12 May 2016 03:28 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/t/200800/



Previous Topic: Converting ASM to NonASM Standby
Next Topic: Replace string
Goto Forum:
  


Current Time: Thu Mar 28 17:25:30 CDT 2024