Re: setps for refreshing a non RAC DB with RAC DB.

From: Leyi Zhang (Kamus) <"Leyi>
Date: Wed, 23 Feb 2011 01:19:02 +0800
Message-ID: <AANLkTikZZTyW0r7OOVH8243XM8yQepZd4j0TvBTzZwX2_at_mail.gmail.com>

Yes, it's really nothing special, but if you wanna do perfectly: 1. Some initial parameter should be changed for single instance database. eg. cluster_database=false
2. Drop the redolog groups which are for other instance 3. Remove undo_tablespace parameter which points to other instances and also drop those undo tablespaces.

Maybe you should check MOS note 358552.1: How to Convert RAC Database to Single Instance, although it's for covert, it's also fit your request, just ignore “Relink Oracle executable” step.

Good luck!

--
Kamus <kamusis_at_gmail.com>

Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org



On Mon, Feb 21, 2011 at 10:11 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:


> There is really nothing special to do.  just run a restore/recover/open.

>

> On Mon, Feb 21, 2011 at 6:55 AM, nilesh kumar <nileshkum_at_gmail.com> wrote:

>>

>> Hello All,

>>

>> Good Morning Everyone!!,

>> Hope everyone is doing great!!

>>

>> I have a question

>>

>> Here is my scenerio.

>> OS  :- Solaris

>> Database version:- 10g

>>

>> My production database reside on RAC( oracle RAC) and test database reside

>> on non RAC.

>> I have to refresh the non RAC test database with RAC produciton database.

>> The backup is run on both with RMAN to tape.

>> I use to refresh non RAC test database  with non RAC production database.

>> But now i have a challenge to refresh a non RAC test with RAC prod.

>> Could you please advise what steps should i follow. Or if you have any

>> checklist could you please share.

>>

>> Thank You

>> Nilesh Soni

>> Oracle DBA

>

>

>

> --

> Andrew W. Kerber

>

> 'If at first you dont succeed, dont take up skydiving.'

>

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

Received on Tue Feb 22 2011 - 11:19:02 CST