OraFAQ Forum: Backup & Recovery » Duplication of db with rman

Home » RDBMS Server » Backup & Recovery » Duplication of db with rman

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Duplication of db with rman [message #70364]

Tue, 04 June 2002 02:30

krishna
Messages: 141
Registered: October 1998

Senior Member

2.I want to duplicate my 'summer' database. My recovery catalog is in a db called 'kris'. I successfully set up the auxiliary db 'dupl'.
Then i gave the command
rman target internal/summer@summer rcvcat rman/rman@kris auxiliary internal/dupl@dupl

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: SUMMER (DBID=2912805942)
RMAN-06008: connected to recovery catalog database
RMAN-06020: connected to auxiliary database

Then i gave the command
run {
set until time '04-JUN-2002';
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
allocate auxiliary channel ch3 type disk;
duplicate target database to dupl;
}

I got this error

RMAN-03022: compiling command: set

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch2
RMAN-08500: channel ch2: sid=15 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch3
RMAN-08500: channel ch3: sid=16 devtype=DISK

RMAN-03022: compiling command: Duplicate Db
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-08031: released channel: ch2
RMAN-08031: released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERROD.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERKRISHNA.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERDR01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERINDX01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERTOOLS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERTEMP01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERUSERS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERRBS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERSYSTEM01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERREDO01.LOG conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERREDO02.LOG conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:ORACLEORADATASUMMERREDO03.LOG conflicts with a file used by the target database

What should i do to set this right?

Report message to a moderator

Re: Duplication of db with rman [message #70365 is a reply to message #70364]

Tue, 04 June 2002 06:37

Grant
Messages: 578
Registered: January 2002

Senior Member

You need to change the file name/location. RMAN knows you would be writing over existing data files. Look at ORACLE_HOMErdbmsdemocase5.rcv. This script gives examples of what you are trying to do. This is not on the client it is on the servers ORACLE_HOME. If you do not have it let me know and I will post it.

Report message to a moderator

Re: Duplication of db with rman [message #70378 is a reply to message #70364]

Wed, 05 June 2002 00:06

krishna
Messages: 141
Registered: October 1998

Senior Member

I want to duplicate my 'summer' database. My recovery catalog is in a db called 'kris'. I successfully set up the auxiliary db 'dupl'.
Then i gave the command
rman target internal/summer@summer rcvcat rman/rman@kris auxiliary internal/dupl@dupl

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: SUMMER (DBID=2912805942)
RMAN-06008: connected to recovery catalog database
RMAN-06020: connected to auxiliary database

Then i gave this command at the rman prompt

RMAN> RUN
2> {
3> SET NEWNAME FOR DATAFILE 1 TO 'D:Oracleoradataduplone.dbf';
4> SET NEWNAME FOR DATAFILE 2 TO 'D:Oracleoradatadupltwo.dbf';
5> SET NEWNAME FOR DATAFILE 3 TO 'D:Oracleoradataduplthree.dbf';
6> SET NEWNAME FOR DATAFILE 4 TO 'D:Oracleoradataduplfour.dbf';
7> SET NEWNAME FOR DATAFILE 5 TO 'D:Oracleoradataduplfive.dbf';
8> SET NEWNAME FOR DATAFILE 6 TO 'D:Oracleoradataduplsix.dbf';
9> SET NEWNAME FOR DATAFILE 7 TO 'D:Oracleoradataduplseven.dbf';
10> SET NEWNAME FOR DATAFILE 8 TO 'D:Oracleoradatadupleight.dbf';
11> SET NEWNAME FOR DATAFILE 9 TO 'D:Oracleoradataduplnine.dbf';
12> ALLOCATE AUXILIARY CHANNEL ch1 TYPE DISK;
13> DUPLICATE TARGET DATABASE TO dupl
14> logfile 'd:oracleoradataduplredo1.log' size 1M,
15> 'd:oracleoradataduplredo2.log' size 1M,
16> 'd:oracleoradataduplredo3.log' size 1M;
17> RELEASE CHANNEL ch1;
18> }

This is the error message i got.

RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=14 devtype=DISK
RMAN-03022: compiling command: Duplicate Db
RMAN-03027: printing stored script: Memory Script
{
set until scn 984389;
set newname for datafile 1 to
"D:ORACLEORADATADUPLONE.DBF";
set newname for datafile 2 to
"D:ORACLEORADATADUPLTWO.DBF";
set newname for datafile 3 to
"D:ORACLEORADATADUPLTHREE.DBF";
set newname for datafile 4 to
"D:ORACLEORADATADUPLFOUR.DBF";
set newname for datafile 5 to
"D:ORACLEORADATADUPLFIVE.DBF";
set newname for datafile 6 to
"D:ORACLEORADATADUPLSIX.DBF";
set newname for datafile 7 to
"D:ORACLEORADATADUPLSEVEN.DBF";
set newname for datafile 8 to
"D:ORACLEORADATADUPLEIGHT.DBF";
set newname for datafile 9 to
"D:ORACLEORADATADUPLEIGHT.DBF";
restore
check readonly
clone database
;
sql clone " CREATE CONTROLFILE REUSE SET DATABASE ^"dupl^" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 ''d:oracleoradataduplredo1.log'' SIZE 1048576 ,
GROUP 2 ''d:oracleoradataduplredo2.log'' SIZE 1048576 ,
GROUP 3 ''d:oracleoradataduplredo3.log'' SIZE 1048576
DATAFILE
''D:ORACLEORADATADUPLONE.DBF''
CHARACTER SET US7ASCII";
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore

Report message to a moderator

Re: Duplication of db with rman [message #70382 is a reply to message #70378]

Wed, 05 June 2002 06:42

Grant
Messages: 578
Registered: January 2002

Senior Member

datafile 8 and 9 have the same name.

Report message to a moderator

Re: Duplication of db with rman [message #336334 is a reply to message #70382]

Fri, 25 July 2008 13:12

teeroy65
Messages: 2
Registered: July 2008
Location: Terre Haute, IN

Junior Member

I have the same problem with the duplicate file name, but I am working on two different servers. Why would this be a problem?

Report message to a moderator

Re: Duplication of db with rman [message #336335 is a reply to message #70364]

Fri, 25 July 2008 13:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Do not Hijack a 6 year on thread.
Start your own thread.

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Report message to a moderator

Previous Topic:	Applying incremental level 1 backup to backup set
Next Topic:	Database Synchronisation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 10 09:10:36 CDT 2025