Re: DR technique
Date: Tue, 13 Aug 2013 10:50:27 -0500
Message-ID: <520A55C3.4070402_at_multiservice.com>
I think someone may have covered this in a similar thread a few days ago, but there really is no concept of restoring an individual node. You're restoring the database, which will only be serviced by one node. As such, restoration is pretty standard RMAN fare. MOS note 415579.1 should have all your required steps. (HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node) As David stated, If it will always be a single instance you really don't even need the remaining grid related items. In that situation, after the restore you will still have your "extra" redo threads, log files, and undo tablespaces hanging around. If you're using the original spfile you may also have unnecessary instance specific parameters set. While none of this absolutely needs to be dropped, you may want to in the interest of cleanliness.
On 08/13/2013 10:37 AM, David Barbour wrote:
> 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
>
>
-- ------------------------------------------------------------------ This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.. ------------------------------------------------------------------ -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 13 2013 - 17:50:27 CEST