Re: ASM & split-mirrors

From: Ls Cheng <exriscer_at_gmail.com>
Date: Sun, 3 Mar 2013 19:46:55 +0100
Message-ID: <CAJ2-Qb9_-3=xYNxfbTj2JPmt+TXaj2UaF1ensaK2v=tsmC8UTQ_at_mail.gmail.com>

Hi
The process is not much different compared with other File System Split Mirrors.

Make sure each each Disk Group contains only one database, redo and controlfiles are not in FRA or DATA diskgroups. For ASM I suually have 4 Disk Groups

DATA
ARCH (or FRA)
REDO1
REDO2 When doing Snap or third mirror:

source:

1. alter system archive log current
2. alter database begin backup
3. snap data disk group LUNs
4. alter database end backup
5. alter system archive log current
6. snap archived log disk group LUNs
7. backup controlfile

target (no disk groups and database exists):

1. present the snap to the server or servers (if RAC)
2. in ASM mount the disk groups, DATA, ARCH
3. create init.ora and make controlfile point to DATA and ARCH Disk Groups
4. startup nomount
5. restore controlfile from the backup
6. alter database mount
7. recover database until cancel using backup controlfile
8. rename redo logs so they point to DATA and ARCH disk groups
9. alter database open resetlogs
10. change db name with NID if you want to call it something else

I think I havent missed any step

Regards

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

Received on Sun Mar 03 2013 - 19:46:55 CET