DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 43

Thread: what backup solution do you use?

  1. #1
    Join Date
    Jun 2001
    Posts
    132
    Hello there dba's

    just curious, what backup software(s) are you guys using? is RMAN and hot file backups (and exp) enough? or do you recommend a commercial backup software? also, some suggestion on backup hardware would be nice. Thanks.

    You think I'm going to have an affair with you? --Stanley Kowalski

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Find out what your customers requirments are first and then take it from there.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    Hi Jeff,

    You have suggested 3 different solutions for backup. But, in most of the places there will be some
    constraints like
    1. Cost involved in buying all the required softwares
    2. Cost involved in buying the necessary storage devices etc.

    That is true in my case also.
    This is what I follow:

    1. Every week I take a cold backup and move it to the backup server.
    2. We have veritas backup agent which will take online backup of the databases in a daily
    basis and move them to the (same) backup server.
    3. Users will take a user level export on a daily basis.

    In this kind of a situation what other method can be followed.

    Thanks.
    Vijay.
    Say No To Plastics

  5. #5
    Join Date
    Jun 2001
    Posts
    132
    thanks for the reply Jeff, I'd be interested to hear from other people as well. Also, it would be nice to hear about their backup and recovery strategies too for databases of different sizes, from 100 GB's to multi-terabyte databases.
    You think I'm going to have an affair with you? --Stanley Kowalski

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    shell scripts + sqlbacktrack + control-m

  7. #7
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Lightbulb

    Hi Guys,

    I would also like to hear from the Oracle Gurus and those who work in Big shops what their backup strategies are , and how do they go about it.

    This will allow people like me who work in small shops with small databases 5-10 Gigs a peek into the real world.

    When it comes to solid backup strategies i have no clue and the only strategy we small timers generally follow is a full cold backup every day/week and full exports.



    Hence I would request on behalf of myself and my fellow members a brief peek into the real world of backup and recovery. It would be nice if you all share your experience and also point out some case studies which will help us gear to be better DBA's.

    Thanks a lot in Advance.

    Ronnie

    ronnie_yours@yahoo.com



    [Edited by ronnie on 05-07-2002 at 09:51 AM]
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by ronnie
    Hence I would request on behalf of myself and my fellow members a brief peek into the real world of backup and recovery. It would be nice if you all share your experience and also point out some case studies which will help us gear to be better DBA's.
    1. Hot backup every day during the slower times.
    2. Archived redo logs backed up every 8 hours. Deleted with the Hot backup.
    3. $ORACLE_HOME backed up once a week.
    Jeff Hunter

  9. #9
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If you have money, go for the BCV from EMC.
    The fastest backup I have ever seen.

  10. #10
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89
    Hot backup every day during the slower times.
    Will it be a full Hot Backup everyday or incremental. Is it backed up directly to the tape or on another hard drive first.

    Originally posted by marist89
    $ORACLE_HOME backed up once a week.
    what exactly is meant by backup the oracle Home
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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