Backup&Recvory Question
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Backup&Recvory Question

  1. #1
    Join Date
    Mar 2001
    Posts
    23
    Hi,
    I have a Backup & Recovery question.Can any one tell me which parameter needs to be set to detect BLOCK CORRUPTION in redologs??

    Thanks,
    Madhu

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    In the initSID.ora file, set

    db_block_checking = true

    to check for corrupt blocks in tables, indexes and partitions.

    I don't know about checking the redo logs.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Mar 2001
    Posts
    23

    Thank you

    Hi ,
    Thank you for infomation.I konw that DB_BLOCK_CHECKING,DB_BLOCK_CHECKSUM parameters can be used for tables,indexes,partiotions.I am wondering about redo log files.I have seen this quesion in one of the OCP
    preparation material.

    Thanks,
    Madhu

  4. #4
    Join Date
    Nov 2000
    Posts
    126

    Smile

    Hello, I am currently studying for B & R 8.0, and in response to your question you'll find the following
    DB_BLOCK CHECKSUM is used to check for block corruption errors in datafiles (tables, indexes, etc.)
    Log_block checksum = true is to check for block corruption in the redo logs.


  5. #5
    Join Date
    Mar 2001
    Posts
    23
    Hi Rookie,
    I am also preparing for Backup&Recovery.Thank you for your information.

    GOOD LUCK

    Madhu

  6. #6
    Join Date
    Nov 2000
    Posts
    126

    Talking

    Good luck to you too!!! I'm writing next week when do you think you'll be ready??

  7. #7
    Join Date
    Jun 2001
    Posts
    88

    Thumbs up

    Good Luck!

    Thanks
    Akash

  8. #8
    Join Date
    Mar 2001
    Posts
    23

    Smile

    Hi Rookie,
    Just now I passed the exam. I scored 55 out of 60.

    Good Luck,
    Madhu

  9. #9
    Join Date
    Nov 2000
    Posts
    126

    Smile

    Well done!!! Did you find it easy...or tricky...??? Do you think ya can give me some pointers???

  10. #10
    Join Date
    Mar 2001
    Posts
    23
    Hi Rookie,
    Thanks. Exam is little tricky. Think twice before you chosse the answer. What I mean is Questions are easy, but the options are such that each one looks like correck choice.
    Concentrate more RMAN.

    Good Luck,
    Madhu

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