FAQ
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
#####################################################################################

Search Discussions

  • Anonymous at Apr 20, 2011 at 10:22 am
    Please check MOS note:
    How to Convert 10g Single-Instance database to 10g RAC using Manual
    Conversion procedure [ID 747457.1]

    Another option is using RMAN Duplicate, Please read:
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm

    --
    Kamus

    Visit my blog for more : http://www.dbform.com
    Join ACOUG: http://www.acoug.org
    On Wed, Apr 20, 2011 at 6:12 PM, 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-l
  • Csaid_at_avl.sonatrach.dz at Apr 27, 2011 at 9:28 am
    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
    #####################################################################################
  • Guillermo Alan Bort at Apr 27, 2011 at 1:57 pm
    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, 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-l
  • Anonymous at May 2, 2011 at 1:46 am
    RAC convert to single instance or vise visa both are very simple.
    Except considering on unset/set redo and undo for new thread, RMAN
    process is exactly the same as what you ever did.

    Please check MOS note:
    How to Convert 10g Single-Instance database to 10g RAC using Manual
    Conversion procedure [ID 747457.1]

    --
    Kamus

    Visit my blog for more : http://www.dbform.com
    Join ACOUG: http://www.acoug.org
    On Wed, Apr 27, 2011 at 5:28 PM, 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-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 20, '11 at 10:12a
activeMay 2, '11 at 1:46a
posts5
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase