Verify success of database backup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Verify success of database backup

Hybrid View

  1. #1
    Join Date
    Jan 2008
    Posts
    39

    Verify success of database backup

    Hi,

    I am using oracle 10.2.0.1.0 on my server. I am taking daily export backup on HP-UX. I do have log file through which i can able to verify the success of the export database backup.

    Is there any dynamic performance view available in oracle to verify the success of the export database backup.

    Thanks
    Prashant Hirani

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, you need to test out your backusps by restoring them

    and an export isnt a backup

  3. #3
    Join Date
    Jan 2008
    Posts
    39
    Hi,

    Thanks for the reply.

    can you please clarify "an export isnt a backup"

    Thanks
    Prashant

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    With export you cannot recover to the point of failure, you cannot recover if you lose a datafile, you must recreate the whole database and only able to recover until last export.

    Therefore export is not a valid backup strategy, it is used to support backkup strategy, useful to recover static tables or stored programs

  5. #5
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    Hi Pando,
    Would like to clarify on ething.
    Export is also a form of backup.

    There are two kinds of backup
    1)Logical Backups
    Example:Export.This can be used when there are logical corruptions only.

    2)Physical Backup
    Ex:All physical backups which we take using RMAN or user managed backups.These backups are used for recovery.


    Correct me if i am wrong.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    export is not a backup - never will be

    you cant recover using it

    export arent only useful for moving data between databases and static tables

  7. #7
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    @@Davey

    If you go through my previous post i had mentioned that exports are logical backups.

    Please go through the below links

    http://www.orafaq.com/wiki/Oracle_da...d_Recovery_FAQ

    http://www.oracle.com/technology/dep...R_Overview.htm

    http://www.orafaq.com/wiki/Logical_Backups/Exports

    WHATS YOUR VIEW ON THIS

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    exports arent backups - anyone who things they are - are wrong

  9. #9
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Hi Dave -

    Interesting ! Oracle says exports are " LOGICAL Backups " but you are not accepting it.

    I know one can not do any kind of recovery using the so called logical backups. Does it the only reason you are saying exports are not (logical) backups?

    Appreciate your clarification.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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