-
RMAN duplicate database
Hi Guys,
I am new to RMAN option of database cloning.
I have a quick question.
Do I need to copy RMAN database and archive log backup files from the Target DB node to the Auxiliary node where I will be performing Duplicate Database command?
Also, Do I need to copy archive log files from the target to Auxiliary node under Archive log destination?
Thanks in Adv
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Yes and Maybe (you can state another location in the auxiliary init.ora file).
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Make your life easy, backup to a common share/mounted filesystem.
You'll recover from RMAN "backup pieces". And you could need additional .arc files beyond the backup that'll need to be accessable to the recovered db/system.
Ken
-
Hi,
I forgot to mention that we are on Windows. So, I don't think I can have a common shared place for RMAN backup.
Also, I am using set newname for datafile command instead of making any changes in the Auxiliary init.ora file.
In such scenario, is it OK, if I don't copy all the RMAN backup pieces from the target node and instead map the target drives on the auxiliary db node with the same drive letter and folder name? Will RMAN be able to read all the required backup pieces and additional archive log files during the recovery?
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
I'm not a Windows guy, but why can't you duplicate using a network share (mapped to a local drive)?
I'm guessing your TARGET and AUXILIARY file systems are not alike (different drive letters for files)?
Ken
-
Originally Posted by KenEwald
I'm not a Windows guy, but why can't you duplicate using a network share (mapped to a local drive)?
I'm guessing your TARGET and AUXILIARY file systems are not alike (different drive letters for files)?
Ken
Ken, that is exactly correct. Technically, I can map the folder of target node on auxiliary node and also the folder name and drive letter are same on both. I just didn't know whether I can do that. But, now I think I can based on your response.
One more thing, Do I need to copy target archived log files to auxilary node, which got generated on target db node since the rman backup was taken?
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|