DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: cloning database and others

  1. #1
    Join Date
    Apr 2002
    Posts
    29
    there are three questions
    1)what are the steps involved in cloning a database
    2)I have cold backup 0f 8.1.5 database which i want to clone in a 8.1.6 environment
    3)what are the steps involved in migrating from 8.1.5 to 8.1.6
    in solaris 2.8 environment

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    1.take a backup of control file binary.
    alter database backup controlfile to trace;
    2.Look at the user_dump_dest for the trace file created at the time the command was executed the above command.
    3.This controlfile will contain a sql script for create a new database.
    4.Then in the new database after installing the oracle binary.
    start the database in nomount stage.
    5.execute the script got for above controlfile.If you want to change the drive name or datafile name you can do it.
    6.Once the command is executed.
    7.Restore the datafile of your source database to the new clone database.
    8.execute the command, 'recover database';
    9.You will have a new database,an exact clone of you old database.



    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Cloning a database means creating a copy of production database onto another machine which can act as a standby database if incase your primary database fails ,your standby database can act as your primary database.See standby database manual to create a standby database.

    In order to migrate from 8.1.5 to 8.1.6 in Solaris 2.8 enviroment you can clone in 2 different ways

    Way 1:Take a cold database backup of datafiles.controlfiles,logfiles .Unistall Oracle 8.1.5 .Install Oracle 8.1.6 in different ORACLE_HOME and restore the cold backup.

    Way 2:Take an full export of the database.Uninstall Oracle 8.1.5 ,Install Oracle 8.1.6 software and import the full database export.

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width