What the steps on making hot backup of Oracle7.3.4 from one NT Server to another?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What the steps on making hot backup of Oracle7.3.4 from one NT Server to another?

  1. #1
    Join Date
    Nov 2000
    Posts
    29

    Unhappy

    Please help?

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    1. Map the drive of the mapping where you want to put the backup of the db on the backup server.

    2. For every tablespace :
    -- alter tablespace ... begin backup
    -- for every datafile off the tablespace
    ---- OCOPY <datafile> <destination drive >
    -- alter tablespace ... end backup

    3. copy all the archived log files to the backup server.

    Done

    Regards
    Gert

  3. #3
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    Sorry, some text was lot in previous post.

    OCOPY :
    use this command to copy a database file to the backup destination on the backup server. This command will allow to copy an open file.

    eg. ocopy d:\oracle\db\ORCL\data01ORCL.dbf o:\backup\db\ORCL

    Regards
    Gert

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