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

Thread: Restore from Cold Backup

  1. #1
    Join Date
    Oct 2002
    Posts
    7

    Restore from Cold Backup

    Hi

    I have recently started working with Oracle 9i (WinNT)

    I performed a cold backup on this database (server#1) of datafiles, control files and redo log files. I did not include any parameter files.

    I have now installed Oracle 9i on another server (server#2) with the same database name. To get database that was on server#1 to server#2, can I simply copy the datafiles and control files to server#2.

    I realise, by reading these forums, that I should have also copied certain parameter files. ie. init.ora.
    However, I haven't found too much information on going the other way - from cold backup data to new server.

    Any help would be greatly appreciated.

    Thanks

    Gregg

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    It's not neccesary to include init.ora file in backup plan. But, copying init.ora helps when you do cloning.
    -nagarjuna

  3. #3
    Join Date
    Oct 2002
    Posts
    7
    Thanks for the reply.

    Is cloning done in OEM, SQLPLUS ??


    Gregg

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The cloning process is fairly manual using sqlplus, once you have copied all the data files to the new server you simply need create the control files for the new location.

    It's been done several times on these forums , try searching for "cloning" for more detail instructions.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Nov 2000
    Posts
    56

    Red face

    U use the SQL*Plus for cloning databases.
    Rama
    Rama

  6. #6
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Or use RMAN for online duplicating.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

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