Re: HowTo Restore RMAN Disk backups of Single Database to RAC Instance
Date: Wed, 27 Apr 2011 10:57:24 -0300
Message-ID: <BANLkTinZ51GBBhuL3rvxi=ake7qvuUJuYw_at_mail.gmail.com>
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
hth
Alan.-
On Wed, Apr 27, 2011 at 6:28 AM, <Csaid_at_avl.sonatrach.dz> 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 *
> ------------------------------
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 27 2011 - 08:57:24 CDT