Re: RMAN from Single to RAC instance
From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: Thu, 2 Feb 2012 16:22:05 -0800 (PST)
Message-ID: <1328228525.18454.YahooMailNeo_at_web110001.mail.gq1.yahoo.com>
Hi Alex
I am pretty sure that using rman would be most straightforward way to do migration to ASM (first to single instance)
Basically this is a procedure, but you should fill up it with details.
Regards
Mindaugas Navickas
From: Alex Cwb <ab80cwb_at_gmail.com>
To: oracle-l_at_freelists.org
Sent: Thursday, February 2, 2012 6:37:55 PM Subject: RMAN from Single to RAC instance
Date: Thu, 2 Feb 2012 16:22:05 -0800 (PST)
Message-ID: <1328228525.18454.YahooMailNeo_at_web110001.mail.gq1.yahoo.com>
Hi Alex
I am pretty sure that using rman would be most straightforward way to do migration to ASM (first to single instance)
1. Install and configure CRS - use cluvfy utility to verify your installation/configuration 2. Install and configure (create ASM instance, allocate disks groups) ASM (in 11.2 must be in the same home as CRS, but since your version is 11.1, I would create separate homes) 3. Install Oracle database home on both RAC nodes (make sure you install RAC-enabled home) 4. On single node of target database "startup nomount" single instance 5. While your source database is live, make RMAN backup to disk and then restore into target instance - do not forget to specify datafile name conversion - database should be restored into ASM disks groups that you have created) - duplicate database won`t work in 11.1 without creating backup to disk. 6. leave target instance in recovery mode 7. ship all archived logs from source instance to target instance and apply logs on target instance 8. on cut-over day apply up-to-the last log and open the instance - it will be single instance database with datafiles, logfiles in ASM 9. migration from single instance to RAC is described in following Oracle document http://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm
Basically this is a procedure, but you should fill up it with details.
Regards
Mindaugas Navickas
From: Alex Cwb <ab80cwb_at_gmail.com>
To: oracle-l_at_freelists.org
Sent: Thursday, February 2, 2012 6:37:55 PM Subject: RMAN from Single to RAC instance
Hi,
I was wondering if it is easy to migrate an database in single instance to
RAC+ASM using RMAN.
Is it recommended using this method for any case??
My db has around 1 TB and I have the whole weekend to proceed with it. Does anyone have any tutorial or quick reference where I can check to have an idea how to proceed?
platform: HP-UX (both)
Version: 11.1.0.7 (both)
Thanks in advance
Alex
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 02 2012 - 18:22:05 CST