This content has been marked as final. Show 4 replies
The simple answer would be "Active database using RMAN" I don't have an ASM example but my Non-ASM example covers almost all of it :
Create a Standby database from an active database using RMAN
Since RMAN sees ASM without any issue this may be your best option.
There's an ASM example here :
Step By Step Guide On Creating Physical Standby Using RMAN(ASM)
Edited by: mseberg on Oct 25, 2012 7:10 PM
Thanks for your reply mseberg.
But in both examples the rman is used connecting one server to another. I need some example of the backup being made to a stagging area, and then restored on the other side...
Thanks again though
I have a non ASM example of that too :
Again most of this applies :
The examples you have been given so far are either using FROM ACTIVE DATABASE (which you can't use because of network limits) or I think assume that the backup is visible to bith sites in some sort of shared storage (which you don't have).
The answer in your case is to mount the external HD and the primary and use RMAN to back up the entire database and archivelogs to the external HD. Then take te HD to the standby site, and mount it on the same path. After that, the usual routine:
Create a pfile and password file for the standby, start it nomount, connect with RMAN to both the target and to the standby as the auxiliary, and DUPLICATE TQARGET DATABASE FOR STANDBY. This technique does require connection across the network to the primary, but that is not a problem - only a minimal volume of data will come across it.
Edited by: JohnWatson on Oct 26, 2012 9:14 AM
Typo: "..and the primary" should read "...on the primary". Sorry about that.