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
Printable View
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
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.
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
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.
Hi Rookie,
I am also preparing for Backup&Recovery.Thank you for your information.
GOOD LUCK
Madhu
Good luck to you too!!! I'm writing next week when do you think you'll be ready??
Good Luck!
Thanks
Hi Rookie,
Just now I passed the exam. I scored 55 out of 60.
Good Luck,
Madhu
Well done!!! Did you find it easy...or tricky...??? Do you think ya can give me some pointers???
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