Monday, July 1, 2013

RMAN-05001 AND ORA-17628

The one might encounter with the following errors while creating a standby database :
sql statement: alter database mount standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/01/2013 17:15:11
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/db1/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/db1/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/db1/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/db1/system01.dbf conflicts with a file used by the target database

AND

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/01/2013 17:19:45
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 07/01/2013 17:19:45
ORA-17628: Oracle error 19505 returned by remote Oracle server

Solution.

Though its workaround is very simple.
1. For RMAN 05001, Be sure that you have mention "db_file_name_convert" & "log_file_name_convert" into your parameter file on both database servers.
2. For ORA-17628, Be sure that you have created an adequate directories and subdirs at standby server.

No comments:

Post a Comment