Backup&Recvory Question

[kmadhu]

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

[dknight]

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.

[kmadhu]

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

[Rookie]

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.

[kmadhu]

Hi Rookie,
I am also preparing for Backup&Recovery.Thank you for your information.

GOOD LUCK

Madhu

[Rookie]

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

[akash]

Good Luck!

Thanks

[kmadhu]

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

Good Luck,
Madhu

[Rookie]

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

[kmadhu]

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