Scribd Logo
Upload

Welcome to Scribd!

  • 135 views

    Conversion From Single Instance Database To Rac Database

    Uploaded by

    Wysheid Learning Portal
    This document explains the step by step instructions of converting a single instance database to a RAC database

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Conversion From Single Instance Database To Rac Database

    Uploaded by

    Wysheid Learning Portal
    135 views3 pages
    This document explains the step by step instructions of converting a single instance database to a RAC database

    Original Title

    Conversion From Single Instance Database to Rac Database

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document explains the step by step instructions of converting a single instance database to a RAC database

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    135 views3 pages

    Conversion From Single Instance Database To Rac Database

    Uploaded by

    Wysheid Learning Portal
    This document explains the step by step instructions of converting a single instance database to a RAC database

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 3

    Conversion from single instance database to rac database

    we can follow any of the following methods to convert a single instance database to rac database

    using export and import method

    using templates

    using RMAN

    using rconfig utility

    In all them these methods, we have to install and configure rac setup before attempting to convert
    single instance database to rac database

    Using export and import method.

    In this method we create an empty database using the DBCA utility from the rac environment

    once the empty databases created we can take the full database export from the source the database
    and import it on the empty target database which we created.

    Using templates

    in this method we use the templates option given in DBCA. From the source database create a template
    with the data using DBCA. Copy the template file created to the target server which is our RAC .

    Start the DBCA on the RAC environment, select template which we copied from the source database and
    create a new rac database based on the template.

    Using RMAN.

    While using the RMAN , the suitable method is to use a clone database option.

    As explained in this example create the backup on the target database.

    Copy the backups to the target server

    Startup and auxiiliary instance on the target instance

    Clone the source database to the target database.

    Startup the additional instances based on the number of nodes in the rac setup.
    Add the database instances and the database to the cluster by using srvctl utility

    RMAN is the preferred method in the following conditions

    the source database size is huge

    the source database is located on a different server

    the source database on a local filesystem and we wanted to use ASM on the target database.

    Conversion using RCONFIG utility

    ==============================

    1) Preferred method if the source database is on the same RAC server

    2) The database and the database instance is added to the Cluster

    3) Rconfig utility is located at $ORACLE_HOME/bin

    4) Rconfig utility’s input is an xml , which contains the information of the source databases and the
    target server details

    5) The sample xml file location is $ORACLE_HOME/assistants/rconfig/samplexmls/

    6) Two sample files are available in this location

    1) ConvertToRAC_PolicyManaged.xml

    2) ConvertToRAC_AdminManaged.xml

    Working with rconfig utility

    We can run the rconfig utility in 3 mode .

    1) Verification mode

    2) Verify and convert

    3) Convert ( perform the conversion with out verification )


    This is accomplished by specifying ‘verify’ option in the xml input file

     YES: Checks to ensure all the prerequisites for converting a single-instance database to an
    RAC database have been met before the conversion process starts
     NO: Bypasses the prerequisite checks and starts the conversion straightaway
     ONLY: Only prerequisite checks are performed; no actual conversion will take place

    Steps

    ======

    1) Make a copy of the existing ConvertToRAC_AdminManaged.xml to another file

    2) Change the parameters as required

    3) $ rconfig ConvertToRAC_AdminManaged.xml

    4) Check the log file for any errors

    Behind Screen

    =================

    On the behind screen, rconfig does the following things

     Migrating the database to ASM, if specified


     Creating RAC database instances on all specified nodes in the cluster
     Configuring the Listener and NetService entries
     Registering services with CRS
     Starting up the instances and listener on all nodes

    You might also like