Home » RDBMS Server » Backup & Recovery » problem creating auxiliary db using RMAN, Help
problem creating auxiliary db using RMAN, Help [message #227329] Wed, 28 March 2007 00:58 Go to next message
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 #227336 is a reply to message #227329] Wed, 28 March 2007 01:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Are you set db_file_name_convert , log_file_name_convert parameters.
Re: problem creating auxiliary db using RMAN, Help [message #227354 is a reply to message #227336] Wed, 28 March 2007 01:41 Go to previous messageGo to next message
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 #227355 is a reply to message #227354] Wed, 28 March 2007 01:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

RMAN-06181: multiple channels requires Enterprise Edition

Set more than one channel and try...

regards
Taj
Re: problem creating auxiliary db using RMAN, Help [message #227362 is a reply to message #227355] Wed, 28 March 2007 01:51 Go to previous messageGo to next message
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 #227375 is a reply to message #227362] Wed, 28 March 2007 02:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
My oracle version is 9.0.1.1.1, is it compatible for duplicate db.
Yes,

check below link ...
http://download-uk.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90135/dupdb.htm


regards
Taj
PS> Check your previously step is done correctly or not...
Re: problem creating auxiliary db using RMAN, Help [message #227543 is a reply to message #227362] Wed, 28 March 2007 09:44 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: time for rman backup
Next Topic: RMAN - BACKUP ARCHIVELOG ALL DELETE INPUT - when arch_dest is full
Goto Forum:
  


Current Time: Sat Dec 10 06:39:14 CST 2016

Total time taken to generate the page: 0.08423 seconds