| problem creating auxiliary db using RMAN, Help [message #227329] |
Wed, 28 March 2007 00:58  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
HI
I have a database on xp( oracle9), i want to clone this database on the same machine, and store all the file related to new database at the same level of directory as my old database is, like
OLD: e:\oracle\oradata\mydata2 ..... mydata2 is old db
NEW: e:\oracle\oradata\auxx ..... auxx is new db
after creating a new initauxx.ora and all other configurations.
when execute the following command on RMAN i get this error
C:\DOCUME~1\SULEMAN>rman
Recovery Manager: Release 9.0.1.1.1 - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
RMAN> connect auxiliary sys/oracle@auxx
connected to auxiliary database (not started)
RMAN> connect target/
connected to target database: MYDATA2 (DBID=3626707107)
RMAN> startup clone nomount force;
Oracle instance started
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
RMAN> duplicate target database to auxx;
Starting Duplicate Db at 28-MAR-07
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=10 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 03/28/2007 11:15:36
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\USERS01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\TOOLS01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\INDX01.DBF conflicts wi
th a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\EXAMPLE01.DBF conflicts
with a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\DRSYS01.DBF conflicts w
ith a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\CWMLITE01.DBF conflicts
with a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\UNDOTBS01.DBF conflicts
with a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\SYSTEM01.DBF conflicts
with a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\REDO02.LOG conflicts wi
th a file used by the target database
RMAN-05001: auxiliary filename E:\ORACLE\ORADATA\MYDATA2\REDO01.LOG conflicts wi
th a file used by the target database
RMAN>
Please Help
regards
Abood
[Updated on: Wed, 28 March 2007 01:03] Report message to a moderator |
|
|
|
|
|
| Re: problem creating auxiliary db using RMAN, Help [message #227354 is a reply to message #227336] |
Wed, 28 March 2007 01:41  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
Yes i have set db_file_name_convert and log_file_name_convert.
But i didn't allocate auxiliary channel previosly, now when i try to allocate it gives me error like.
RMAN> run {
2> allocate auxiliary channel c device type disk;
3> duplicate target database to auxx;
4> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 03/28/2007 12:06:56
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06181: multiple channels requires Enterprise Edition
RMAN>
My oracle version is 9.0.1.1.1, is it compatible for duplicate db.
regards
Abood
|
|
|
|
|
|
| Re: problem creating auxiliary db using RMAN, Help [message #227362 is a reply to message #227355] |
Wed, 28 March 2007 01:51 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
RMAN> connect auxiliary sys/oracle@auxx;
connected to auxiliary database: auxx (not mounted)
RMAN> connect target/
connected to target database: MYDATA2 (DBID=3626707107)
using target database controlfile instead of recovery catalog
RMAN> startup clone nomount force;
Oracle instance started
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
RMAN> run{
2> allocate auxiliary channel c1 device type disk;
3> allocate auxiliary channel c2 device type disk;
4> duplicate target database to auxx;
5> }
allocated channel: c1
channel c1: sid=10 devtype=DISK
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 03/28/2007 12:19:39
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06181: multiple channels requires Enterprise Edition
RMAN>
|
|
|
|
|
|
| Re: problem creating auxiliary db using RMAN, Help [message #227543 is a reply to message #227362] |
Wed, 28 March 2007 09:44 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> store all the file related to new database at the same level of directory as my old database
Very bad idea. Unless you are really vigilant, you may endup working on wrong files.
>> RMAN-06181: multiple channels requires Enterprise Edition
Cannot be anymore explicit clear information.
You must be using Standard edition.
So allocate no more than one channel.
This is a well known Oracle bug fixed in 9.2.0.8 and above.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
