DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=VunUjBr6ZH33Y6i2oBJk1PsotAMxD+qR9H7rcJZqC+JpmlJ+Zyp5EdXEzRK9R9sJ9BLS21YVZZ/we2gpvBGWVbkVmso22d3agHGhWx9s2tGdg/oWz5dGS9qwWxi6AYZJxIZXvwnXeT/0os17WaUTaJV9B5FZD2z9ALraT0cSBv8=;
References: <CAK6BXVsKK50761iOe5NqTDSsaU_zqAPQNtDbBpb71ZUSZ=0nmg@mail.gmail.com>
Message-ID: <1328228525.18454.YahooMailNeo@web110001.mail.gq1.yahoo.com>
Date: Thu, 2 Feb 2012 16:22:05 -0800 (PST)
From: Mindaugas Navickas <mnavickas@yahoo.com>
Subject: Re: RMAN from Single to RAC instance
To: "ab80cwb@gmail.com" <ab80cwb@gmail.com>,
  "oracle-l@freelists.org" <oracle-l@freelists.org>
In-Reply-To: <CAK6BXVsKK50761iOe5NqTDSsaU_zqAPQNtDbBpb71ZUSZ=0nmg@mail.gmail.com>
MIME-Version: 1.0
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: mnavickas@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@gmail.com>
To: oracle-l@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-l