Home » RDBMS Server » Backup & Recovery » Duplicate RMAN problem
Duplicate RMAN problem [message #361499] Wed, 26 November 2008 12:12 Go to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Hello Everyone,

When I try to issue duplicate target database to auxiliarydatabase;
I get the following error

Starting Duplicate Db at 26-NOV-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=11 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2008 13:07:08
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D20.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D19.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D18.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D17.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I07.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D16.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D15.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\USERS02.DBF conflicts with
a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I06.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\TE_Auxiliarydb_I01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\TE_Auxiliarydb_D01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\TE_MASTER01.DBF conflicts
with a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D14.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D13.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D12.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D11.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I05.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I04.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I03.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I02.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_I01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D10.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D09.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D08.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D07.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D06.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D05.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D04.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D03.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D02.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\CP_Auxiliarydb_D01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\XDB01.DBF conflicts with a
file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\USERS01.DBF conflicts with
a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\TOOLS01.DBF conflicts with
a file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\ODM01.DBF conflicts with a
file used by the target database
RMAN-05001: auxiliary filename D:\ORACLE\ORADATA\Auxiliarydb1\DRSYS01.DBF conflicts with
a file used by the target database


This error message is similar to message #227329 and I have set the db_file_name_convert and log_file_name_convert parameters in my init file. Can someone please help?

Thanks,
SN
Re: Duplicate RMAN problem [message #361505 is a reply to message #361499] Wed, 26 November 2008 12:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I have set the db_file_name_convert and log_file_name_convert parameters in my init file
Post them.
Copy and paste the exact contents.
Re: Duplicate RMAN problem [message #361509 is a reply to message #361505] Wed, 26 November 2008 12:37 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
db_file_name_convert = ('D:/oracle/oradata/proddb','E:/oracle/oradata/duplicatedb')

log_file_name_convert = ('D:/oracle/oradata/proddb','E:/oracle/oradata/duplicatedb')
Re: Duplicate RMAN problem [message #361510 is a reply to message #361509] Wed, 26 November 2008 12:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Make these values to be in uppercase.
Try again.
Re: Duplicate RMAN problem [message #361513 is a reply to message #361510] Wed, 26 November 2008 12:57 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Tried doing that but it didnt work. Got the same error.
Re: Duplicate RMAN problem [message #361514 is a reply to message #361513] Wed, 26 November 2008 12:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
post the values again and
output of
show parameter convert

[Updated on: Wed, 26 November 2008 13:01]

Report message to a moderator

Re: Duplicate RMAN problem [message #361515 is a reply to message #361514] Wed, 26 November 2008 13:02 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Here goes,

db_file_name_convert = ('D:/ORACLE/ORADATA/PRODDB','E:/ORACLE/ORADATA/AUXILIARYDB')
log_file_name_convert = ('D:/ORACLE/ORADATA/PRODDB','E:/ORACLE/ORADATA/AUXILIARYDB')
Re: Duplicate RMAN problem [message #361517 is a reply to message #361515] Wed, 26 November 2008 13:08 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
SQL> show parameter convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string D:/ORACLE/ORADATA/NGS1, E:/ORA
CLE/ORADATA/NGSDUP
log_file_name_convert string D:/ORACLE/ORADATA/NGS1, E:/ORA
CLE/ORADATA/NGSDUP
Re: Duplicate RMAN problem [message #361518 is a reply to message #361515] Wed, 26 November 2008 13:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>('D:/ORACLE/ORADATA/PRODDB'
This is not the right format for a windows directory/path.
use D:\blah\blah instead of D:/blah/blah
Re: Duplicate RMAN problem [message #361520 is a reply to message #361518] Wed, 26 November 2008 13:23 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
That did the trick! However, I'm getting the same error for the my redo logs. I have given same names to the redo files for both the databases but placed in different directories. Any suggestions?

channel ORA_AUX_DISK_1: sid=11 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2008 14:19:15
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\NGS1\REDO03A.LOG conflicts with
a file used by the target database
RMAN-05001: auxiliary filename C:\ORACLE\ORADATA\NGS1\REDO03B.LOG conflicts with
a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\NGS1\REDO02B.LOG conflicts with
a file used by the target database
RMAN-05001: auxiliary filename C:\ORACLE\ORADATA\NGS1\REDO01A.LOG conflicts with
a file used by the target database
Re: Duplicate RMAN problem [message #361523 is a reply to message #361520] Wed, 26 November 2008 13:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have the parameters as
log_file_name_convert string D:/ORACLE/ORADATA/NGS

which means read from D:\ORACLE\..
But RMAN is reading from
C:\ORACLE\ORADATA

are you sure all those directories exist?
Seems you have redologs spread across in C: and D:
and you are considering only D:

[Updated on: Wed, 26 November 2008 13:34]

Report message to a moderator

Re: Duplicate RMAN problem [message #361524 is a reply to message #361523] Wed, 26 November 2008 13:43 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
Nice catch Sir! Actually I've my redo file spread over 3 drives C:, D: and E:. But I've only put the D: redo files in the log_file_name_convert parameter. So if I have redo in 3 drives, do I manually type log_file_name_convert=
(C:/ORACLE/ORADATA/PRODDB','C:/ORACLE/ORADATA/AUXILIARYDB,
D:/ORACLE/ORADATA/PRODDB','D:/ORACLE/ORADATA/AUXILIARYDB
E:/ORACLE/ORADATA/PRODDB','E:/ORACLE/ORADATA/AUXILIARYDB)?
Re: Duplicate RMAN problem [message #361526 is a reply to message #361524] Wed, 26 November 2008 14:18 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
I made the above mentioned change in the log_file_name_convert parameter and the datafiles are getting restored. Since I didn't connect to the catalog and used control files instead, I'm not sure of when to use the catalog for backup/restore.
Re: Duplicate RMAN problem [message #361700 is a reply to message #361526] Thu, 27 November 2008 10:45 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I do not understand in what context you are asking that question.
It is all explained in docs. quoting docs
If you are not using a recovery catalog, the control file is the sole storage for the RMAN repository,
 so it is doubly important that you protect it. Maintain alternate control files through multiplexing or 
operating system mirroring, and back up the control file frequently.

Configure CONTROLFILE AUTOBACKUP to ON to ensure extra protection for your control file.

So long as a control file autobackup is available, RMAN can restore the SPFILE and backup 
control file, and mount the database. After the control file is mounted, you can restore the 
remainder of the database.

Note that, if you restore a control file from autobackup, any persistent settings you set with 
the CONFIGURE command will revert to the values they had at the time of the control file autobackup.
 You should review the settings with the SHOW ALL command after restoring the control file.

Just to be in safer side, I always keep a text copy of spfile, traced control file in text format
and the contents of RMAN show all command after every change.

Catalog is just an option. Not a must. In previous versions, there used to be serious limitations with
nocatalog mode. Still there are some restrictions as some features cannot be used in nocatalog mode.
CHeck the docs.

[Updated on: Thu, 27 November 2008 10:47]

Report message to a moderator

Previous Topic: Duplicate RMAN issue
Next Topic: Backing up temporary tablespace
Goto Forum:
  


Current Time: Mon Dec 05 19:15:52 CST 2016

Total time taken to generate the page: 0.06859 seconds