Re: HowTo Restore RMAN Disk backups of Single Database to RAC Instance

From: Guillermo Alan Bort <>
Date: Wed, 27 Apr 2011 10:57:24 -0300
Message-ID: <>

Is this a full restore?

Lets call the RAC database RACD.

So, you do the following in RACD:
alter system set cluster_database=false scope=spfile; alter system... (set the file naming standards)

srvctl stop database -d RACD

srvctl start instance -d RACD -i RACD1 -o nomount

rman target /_at_RACD1 catalog (???)
set dbid .... (DBID from source db)
restore controlfile from '....';
set newname for datafile X to '...' (rename all the datafiles needed) restore database;
recover database;
alter database open;

sqlplus --- create any missing redo log group/file, add missing undo and tempfiles.

alter system set cluster_database=true scope=spfile;

srvctl stop database -d RACD
srvctl start database -d RACD


On Wed, Apr 27, 2011 at 6:28 AM, <> wrote:

> Hi,
> I had a production DB on oracle 10g RAC with 2 instances. I had a problem,
> so I switched to another server with a single instance.
> Now I would return to the first configuration (DB RAC), it already exists
> and I would use RMAN backup pieces.
> Have you any idea or document for this operation of restore?
> Best regards
> Chahinez
> ------------------------------
> This e-mail message has been scanned for Viruses and Content and cleared by
> *MailMarshal *
> ------------------------------

Received on Wed Apr 27 2011 - 08:57:24 CDT

Original text of this message