Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN Backup - New physical Standby Database

Fabrício BarbosaOct 25 2012 — edited Oct 26 2012
I was not sure if posting here or in the RMAN topic... I chose here!

Ok, I'm familiar with data guard and its options, since I used to work with it in my previous company. But I never needed to create one from zero. That’s my goal in my new job.
I need to create a new physical stndby server, but here we use ASM. I've been reading a lot and came to the conclusion that the best way (maybe the only) of doing so is using RMAN.
I'm not familiar with RMAN at all. So my scenario is:
Primary DB: Oracle 11.2.0.3 RAC (3 nodes) in ASM.
Stdby: Oracle 11.2.0.3 (single instance) in ASM.

How can I create a full backup of the primary site, and have a file or pack of files to transfer to the stdby server, and restore it on the other side, in order to configure the replication.

I don't want to seem lazy at all, but the main problem is: I need to take this backup into an external HD, and carry it to the new site (since the Database is too large to transfer via the network link) where I should attach to the new server and restore it.
All documentation I’ve read the DUPLICATE DATABASE seems to be made directly from one server to the other, and not to a staging area.
Can someone please post a link or give me some tips on how to make this backup into a specific location, and later, how to restore it?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2012
Added on Oct 25 2012
4 comments
368 views