Cold Backup To Tape
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Cold Backup To Tape

  1. #1
    Join Date
    Dec 2000
    Posts
    3

    Question

    Dear All,

    I need help on getting cold backup script to tape (tar command, if possible).

    I am running ORACLE 7.3 on Digital (COMPAQ) UNIX 4.0D. My database is big because I am running a continuous batch processing of an electronic payment system. My transaction table has more that 50 million records and it is expanding at a rate of 7 to 8 million records per month.

    I am planning to do my backup every nite.

    Pls help.

    Cheers



  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268

    Answer

    1. shutdown Oracle (use dbshut)
    2. use: tar -cvf /$ORACLE_HOME/oradata /dev/nrmt0h
    3. startup oracle.

    you can add ">> report.log" at the end of the tar line to create a log file.


  3. #3
    Join Date
    Dec 2000
    Posts
    3

    Smile Re: Answer

    [QUOTE][i]Originally posted by rotem_fo [/i]
    [B]1. shutdown Oracle (use dbshut)
    2. use: tar -cvf /$ORACLE_HOME/oradata /dev/nrmt0h
    3. startup oracle.

    you can add ">> report.log" at the end of the tar line to create a log file.

    [/B][/QUOTE]

    Dear rotem_fo,

    Thanks for the info. However, my db files are located at different places. How do I tar all this files at once and in your opinoin how long will the tar process if my db is about 23GB in size?.

    Cheers
    :))

  4. #4
    Join Date
    Dec 2000
    Posts
    3

    tar

    For the files not under ORACLE_HOME

    use


    tar -rvf 'another_directory/files* ' /dev/nrmt0h


    Goodluck
    Get back if Problems Persists,
    Kenneth

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    How long it takes depends on the hardware (tapes, disk, network) involved.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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