RE: DR technique

  • From: "Hubler, Daniel" <daniel.hubler@xxxxxxxxxx>
  • To: Andy Gmail <andrew.kerber@xxxxxxxxx>
  • Date: Tue, 13 Aug 2013 20:44:20 +0000

First:  thanks to all the folks who responded.

Next:  After reading through the replies that I received,
I think I did a poor job of explaining what our idea is.
So I am going to try again . . . . 

This would be Oracle DB & Grid  v11.2.0.3 on AIX v6.1

Our idea is to go to the DR hot site,
with just a single node to run from, instead of the 2 that exist in our RAC.

That node would NOT be equipped with a switch, or a private network,
. . . the entities that I labeled "RAC stuff".

We would restore the node using a mksysb of one of our RAC nodes.
(mksysb = root volume restore)
We would then lay down all the other file system stuff from a tape backup of 
that same node.
This should give us the operating system software and the Oracle software needed
to run. 

After that, I think it would go something like:
a)  stop CRS (because it might have been started during a reboot)
b)  start CRS in exclusive mode (I believe this allows ASM to start without a 
voting disk)
c)  use sqlplus (for ASM) to create the disk group that will house the OCR
(create diskgroup xxxx disk 'ssssss')
d)  restore the OCR from the latest OCR backup
e)  recreate the voting disk (crsctl replace votedisk +XXXXX)
f)  create ASM pfile/spfile parameters
g)  shutdown CRS
h)  start CRS
i)  rebuild other disk groups in ASM
j)  start DB instance
k)  restore/recover database using RMAN

Again. . . . .any comments, thoughts, experiences would be welcome.

Thanks.




-----Original Message-----
From: Andy Gmail [mailto:andrew.kerber@xxxxxxxxx] 
Sent: Monday, August 12, 2013 7:59 PM
To: Hubler, Daniel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: DR technique

Yes.  It's possible.  I've done it in Linux.  It's pretty straightforward.

Sent from my iPhone

On Aug 12, 2013, at 5:33 PM, "Hubler, Daniel" <daniel.hubler@xxxxxxxxxx> 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?
> 
> 
> 
> 
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: