Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Cold backup procedure

    Hi experts

    I am completely new to Oracle.
    And i have to take the cold backup of Oracle 8.0.6 on HPUX 11i machine.
    So can anyone let me know the procedure to be followed to perform the cold backup of the database & then recover the same.

    Your quick response will be of great help to me.

    Thanks a lot
    Sumana

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    1.Shut Oracle Down
    2. Take copy of all the database files
    3. Start Oracle back up again.

    Recovery is exactly the same, except you copy the database files back into the database areas as step 2.

    Hope this helps
    Regards
    Dbabren

  3. #3
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Cold backup procedure

    A cold backup just means that the database is down when you backup the files.

    You need to do a shutdown on the db. (I don't know the unix paths, but look for an oradim executable, and use its help function to give you shutdown parameters.)

    Then using whatever BU software you have, do your backup.

    After the backup is complete then again use oradim to start the database.

    Note: I work with WinXX and not *NIX. But this is all in the same ballpark for Oracle, I think.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

Posting Permissions

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