Backup strategy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Backup strategy

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    I have a client that have lost data in the past cuse he did not have a good backup strategy with oracle database.

    I put his database in archivelog mode, duplex controlfile, logfile. A hot backup is made every night and vital files are put on tape.
    The client is still insecure and wants a document that demonstrate that his backup strategy is oracle standard.

    Have any idea where i can get that beside giving him the documentation of backup stategy from oracle?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What you have done seems to be good. But make sure that you backup the archive logs and then take a hot level0 backup

    My way would be

    Sun: Level0
    Mon: Level2
    Tue: Level2
    Wed: Level1
    Thu: Level2
    Fri: Level2
    Sat: Level1

    Depending on the archive log generation, backup the archivelogs every 6hrs (your Choice).

    Once in the begining, middle and end of the months, if you can afford, take a cold backup.

    If he has more backup space, then you can initiate a logical backups too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Another approach would be to ask him for his requirements.

    Depending on the maximum time to recovery, the amount of activity on the database and the tolerance for data loss, your strategy might be different.
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    The strategy is done and is ok. The client like i said lost his data in the past, he is insecure.
    Even if we agree on every little details like recovery time and all, he needs a document that tells him everything is done by the book, like oracle want us to do it, like a good dba. The client does not want to read books and documentation that show he has a good strategy, he just want a little confirmation. That is why im asking you guys.
    A web page or something, that does not require more than 5 minutes to read.

  5. #5
    Join Date
    Oct 2002
    Posts
    23

    web site doc on Backup and Recovery

    I love this document. I use it all the time.
    The document is Backup and Recovery by Howard J. Rogers.

    http://www.chiark.greenend.org.uk/~o...ree/orabur.pdf




    Michellea
    "Live Life to the Fullest"

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