Friday, March 16, 2012

RMAN-05001, RMAN-05501, RMAN-03002 when cloning database with RMAN on the same database server

Error: 
The following error occurred when cloning an auxiliary database on the same server as the target database (10.2.0.3ee, Solaris):


RMAN> duplicate target database to dupdb;


Starting Duplicate Db at 16-MAR-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=211 devtype=DISK
^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/16/2012 09:39:30
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /oracle/targetdb/user_tables02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /oracle/targetdb/user_tables01.dbf conflicts with a file used by the target database


Solution:

The reason is pretty clear: cloned auxiliary data files CANNOT be placed in the same location as the target data files.

One of the solution is to put the following Oracle initialization parameters in the pfile or spfile:

db_file_name_convert=('/oracle/targetdb', '/oracle/dupdb')
log_file_name_convert=('/oracle/targetdb', '/oracle/dupdb')


More Oracle DBA tips, please visit Oracle DBA Tips 

No comments:

Post a Comment