DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Need Backup Clarification

  1. #1
    Join Date
    Jul 2000
    Posts
    50
    Hi All!

    I read, some where only logical backup check the corruption (I guess they meant block corruption). One will realize block corruption for hot/cold backups only when one try to recover DB from that backups. It mean I have to recover my DB from last backup i.e. prior to corrupted backup and have to apply the archives for the most updated DB state.

    I would like to know how can I check this cirruption at time of backing up my data by cold/hot backup procedure.

    Is there any method that I could simulate the above test.

    I appreciate your view in advance.

    abhijit

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

    exp system/manager file=/dev/null direct=y log=exp.out
    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."

  3. #3
    In 8i RMAN stops when it found a corrupted block.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  4. #4
    Join Date
    Jul 2000
    Posts
    50

    Exclamation

    Thanks for your prompt reply.

    marist89: You are doing logical backup. I want to know for non-logical(cold/hot) backup.

    rcaballe: Do you have any idea about Oracle 8.0.x. You said 8i RMAN stop, does it gives any error specification with corrective steps.

    Regards,

    abhijit

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You can use dbverify utility on hot/cold backup data files for block corruption.

  6. #6
    Join Date
    Jul 2000
    Posts
    50
    Thanks

    abhijit

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