Duplicate DB for Standby [message #651137] |
Wed, 11 May 2016 23:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #651148 is a reply to message #651140] |
Thu, 12 May 2016 03:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|