Re: DR technique

From: David Barbour <david.barbour1_at_gmail.com>
Date: Tue, 13 Aug 2013 10:37:02 -0500
Message-ID: <CAFH+ifeuKY-3M8c2s1yANttK1R-z-RCp1055qmdFOW__MRkM=g_at_mail.gmail.com>



Just got done testing precisely what you're proposing with the exception it was on a Linux box. We also have a contracted DR site and are coming up on our annual exercise which is the first that includes Linux/RAC. Working with our server, storage and backup teams, they provided a box with all the current OS software, storage and tape connections.

I had to set up multipathing, install the Grid Infrastructure, add some ACFS Filesystems, install and patch the database software and configure ASM disk groups Only issue I had was outlined here and that was with RMAN needing the database to be statically registered with the listener so I could get back a copy of the controlfile from tape. After that it was a breeze. I was using a SCAN setup as our plan is to restore the database with one node running an instance and if time permits add a second node. If you are just bringing up a single instance database without all that 'RAC Stuff' and you have a copy of the controlfile and/or access to a Recovery Catalog you shouldn't have any problems.

Just want to take this opportunity to thank the folks here who pointed me in the right direction with the listener piece. Much obliged.

On Mon, Aug 12, 2013 at 4:33 PM, Hubler, Daniel <daniel.hubler_at_aurora.org>wrote:

> Having some debate here as to whether the following idea should work.
> Looking for input. . . . . .
> Setting up contracts for DR testing at hot site.
> Going to contract for a single AIX node and
> use that to restore the database of our 2-node RAC.
>
> Thinking is that we should be able to build that single AIX node,
> without all the extra "RAC stuff" (private network, switch, etc.)
> and restore the RAC software from our backup tape.
>
> So we would basically be restoring only one node of the 2-node RAC.
>
> And then successfully restore/recover the database from an RMAN backup.
>
> Can we make this work?
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 13 2013 - 17:37:02 CEST

Original text of this message