RMAN: DUPLICATE DATABASE to same disk group? [message #246778] |
Thu, 21 June 2007 22:02 |
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 #246780 is a reply to message #246779] |
Thu, 21 June 2007 22:24 |
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 |
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 |
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 |
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.
|
|
|