DR technique (part 2)

From: Hubler, Daniel <daniel.hubler_at_aurora.org>
Date: Wed, 14 Aug 2013 16:32:46 +0000
Message-ID: <850425C04FB76547AC0ED12C5F7E0B80174DAB_at_HEIMSEAT021.ahc.root.loc>

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:

1. stop CRS (because it might have been started during a reboot)
2. start CRS in exclusive mode (I believe this allows ASM to start without a voting disk)
3. use sqlplus (for ASM) to create the disk group that will house the OCR (create diskgroup xxxx disk 'ssssss')
4. restore the OCR from the latest OCR backup
5. recreate the voting disk (crsctl replace votedisk +XXXXX)
6. create ASM pfile/spfile parameters
7. shutdown CRS
8. start CRS
9. rebuild other disk groups in ASM
10. start DB instance
11. restore/recover database using RMAN

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

Thanks.

Daniel P. Hubler
Database Administrator
Aurora Health Care
Daniel.hubler_at_aurora.org

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 14 2013 - 18:32:46 CEST