| Duplicate RMAN problem [message #361499] |
Wed, 26 November 2008 12:12  |
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 #361517 is a reply to message #361515] |
Wed, 26 November 2008 13:08  |
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 #361520 is a reply to message #361518] |
Wed, 26 November 2008 13:23 |
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 |
 |
Mahesh Rajendran
Messages: 10707
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
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 |
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 |
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 |
|
Mahesh Rajendran
Messages: 10707
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
