Back up Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Back up Question

  1. #1
    Join Date
    Sep 2000
    Posts
    56
    we are having 2 databasees running in WindowsN/T.They are going to replace the machine with a new one.So I would like to know what all files needed to be backed up so that later I can use for the same database creation in the new machine.Presently I need to backup files from machine A to Machine B & later from Machine B to new machine.So do send the step by step approach to back up whatall files from Machine A to Machineb.I am running oracle 8.1.5 & it is a test database.As of such no archiving & it's not a 24X7.Thanks in advance for all the suggestions
    Thanks
    G.Suresh

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If you use same directory on both machines and same release of Oracle, take backup of control files, redo log files, data files, init.ora , config,ora and then copy them into new machine.

    If the Oracle release is different, do export and import or Migration utility.

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking cold backup


    Basically if you do a cold backup and then insert all those files into the proper directories in the new server, you should be all set.

    Otherwise you can also jsut do a full Export like Tamil said.

    - Magnus

  4. #4
    Join Date
    Sep 2000
    Posts
    56
    Thanks!!!!!!!!!!!

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