Home » RDBMS Server » Backup & Recovery » RMAN: DUPLICATE DATABASE to same disk group?
RMAN: DUPLICATE DATABASE to same disk group? [message #246778] Thu, 21 June 2007 22:02 Go to next message
mrhtml
Messages: 3
Registered: June 2007
Junior Member
I have searched high and low for what I thought would be a simple YES/No question. Can anyone tell me:

Is it possible to take a database [QA1] in an ASM diskgroup [+DGROUP1] and use DUPLICATE DATABASE to clone a new database [QA2] in the same disk group?

Thanks,
John
Re: RMAN: DUPLICATE DATABASE to same disk group? [message #246779 is a reply to message #246778] Thu, 21 June 2007 22:08 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Yes
Re: RMAN: DUPLICATE DATABASE to same disk group? [message #246780 is a reply to message #246779] Thu, 21 June 2007 22:24 Go to previous messageGo to next message
mrhtml
Messages: 3
Registered: June 2007
Junior Member
Excellent! And thank you very much for the direct YES/NO answer (that can be amazingly hard to get out of people).

So I guess you can see my next question coming: Do you know of any document/site/etc that either details this or provides a complete example?

There are tons of posts and book examples about SFS --> ASM, DOSKGROUP1 --> DISKGROUP2, SERVER1 -->SERVER2, and a ton of other scenarios - but I am beginning to think I am the only person in the country that wants to clone within the same ASM diskgroup. Even the Oracle manuals seem to purposely avoid this scenario.
Re: RMAN: DUPLICATE DATABASE to same disk group? [message #246957 is a reply to message #246780] Fri, 22 June 2007 10:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
ASM, DOSKGROUP1 --> DISKGROUP2, SERVER1 -->SERVER2, and a ton of other scenarios - but I am beginning to think I am the only person in the country that wants to clone within the same ASM diskgroup. Even the Oracle manuals seem to purposely avoid this scenario.



I guess you should search on the FORMAT parameter of RMAN.
if you set the format for backup then it will copy your backup to single diskgroup.

some thing like this
RMAN> backup as copy database format '+DG1';

Starting backup at 26-MAY-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u02/oradata/prod1/system01.dbf
output filename=+DG1/prod1/datafile/system.257.1 tag=TAG20050526T073442 recid=1 stamp=559294642
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:49
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u02/oradata/prod1/sysaux01.dbf
output filename=+DG1/prod1/datafile/sysaux.258.1 tag=TAG20050526T073442 recid=2 stamp=559294735
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:26
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u02/oradata/prod1/undotbs01.dbf
output filename=+DG1/prod1/datafile/undotbs1.259.1 tag=TAG20050526T073442 recid=3 stamp=559294750
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u02/oradata/prod1/users01.dbf
output filename=+DG1/prod1/datafile/users.260.1 tag=TAG20050526T073442 recid=4 stamp=559294758
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
copying current controlfile
output filename=+DG1/prod1/controlfile/backup.261.1 tag=TAG20050526T073442 recid=5 stamp=559294767
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08
Finished backup at 26-MAY-05
Re: RMAN: DUPLICATE DATABASE to same disk group? [message #247000 is a reply to message #246957] Fri, 22 June 2007 15:23 Go to previous messageGo to next message
mrhtml
Messages: 3
Registered: June 2007
Junior Member
Thanks for the reply, but I am not having a problem with backing up the database.

The problem is with cloning it (using BACKUP DUPLICATE) into the same diskgroup. I can't find this addressed anywhere, and when I try to clone to the auxillary db I don't know if there is anything that ASM might do that would result in an overwrite of files in the target db.

John
Re: RMAN: DUPLICATE DATABASE to same disk group? [message #247016 is a reply to message #247000] Fri, 22 June 2007 17:58 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
The problem is with cloning it (using BACKUP DUPLICATE) into the same diskgroup



Is it neceassry to the same Disk Group?

Any logic beahind this?

I guess if we take backup to the same DISKGROUP it means we can use it with DUPLICATE command as well
But not sure.
Previous Topic: ORA-19602 during backup on closed DB (10g)
Next Topic: rman restore error
Goto Forum:
  


Current Time: Fri Dec 09 23:21:30 CST 2016

Total time taken to generate the page: 0.12970 seconds