Backup&Recvory Question

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

Do not forget to refer to MAXCORRUPT parameter for backup and recovery context.

Thanks again. I think you're right about it as I have caught myself on a practice exam almost choosing the wrong answer such as alter database rename file, alter database rename datafile etc.

Do you know what the difference is between Set Autorecovery on, recover ... and just using Recover automatic ... etc. What is the recommended use for this?

Yay!!! I passed backup & recovery today 56/60.
Thanks to Sybex and Examcram. The practice paid off well!.

Hi Rookie,

Congratulations !!.

-Madhu

LOG_BLOCK_CHECKSUM is invalid for 8i.

DB_BLOCK_CHECKSUM checks redo logs for corruption. The system tablespace is automatically checked and you can't turn that off.

Re blockchecksum info. Thanks for the tip. I'll remember if I decide to take the 8i upgrade exam. Right now I am preparing for Netadmin 8.0 but I am using 8i Sybex to study for it. Has anyone written this exam and what's it like???

Madhu,
If u set db_block_checksum parameter, preformance won't decrease. Oracle suggest not set the db_block_checksum parameter, correct me if i am wrong...

--Sriram.

Quote:

---

Originally posted by pv_sriram

If u set db_block_checksum parameter, preformance won't decrease. Oracle suggest not set the db_block_checksum parameter, correct me if i am wrong...

--Sriram.

---

DB_BLOCK_CHECKSUM checks all blocks, every temp blocks and the computation result is stored in each blocks header. It decreases overall perforamance.

DB_BLOCK_CHECKING checks if changed data and index blocks are logically OK.

I would suggest that you use "analyze table validate structure" to get the rowids of rows within corrupted blocks. Run first utlvalid.sql to create the INVALID_ROWS tables which will store those "corrupted" id:s.

I've tried also dbverify but it does not work on online files.

Finally, if you are really into "corruption", try DBMS_REPAIR. However, if you do not have the latest release of 8i, then FIX_CORRUPT_BLOCKS fixes nothing. If you run OPS and create your tables with multiple freelists, REBUILD_FREELISTS is useful.

Dear madhu
congratulations on passing the exam
as said

db_block_checksum is for checking block corruption in datafiles and
log_block_checksum is for checkin in redo log file till oracle 8

From 8i both of them r checked in only one parameter
db_block_checksum


Thanks


[email protected]

[Edited by marist89 on 07-12-2001 at 09:03 AM]

Hi all, the RMAN section in the B&R 8i exam make up 1/3 of the whole exam. Total of 22 questions on RMAN,recovery catalog and standby database.

Questions, like someone said earlier are easy but answers are tricky.

Good Luck!

Hi,

Just now passed the Perf &Tuing(1ZO-24).I scored 55 out of 57.

-Madhu

Hi,
I want to take the ocp for 8i test. Is there anybody cant tell me the exact number of question in its chapter on real ocp test for IZ0-023,IZ0-024,IZ0-025,IZ0-026

.....thanks
dbatobe

[Edited by dbatobe on 07-16-2001 at 10:10 AM]