Backup&Recvory Question

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!