anybody doing thier certification on 8i, help needed guys with backup& recovery module

Report this post to a moderator

What kind of help were you looking for? I could try to answer some of your questions.
Melissa

Report this post to a moderator

Hi melissa4,
thanx for that reply, actually i have couple of doubts in the backup&recovery module.

when developing the strategy(backup&recovery) for the organizaton we consider a whole lot of things, one of it is probaly the recovery issues. while considering media recovery we check whether we are operating the DB in archive/noarchive mode, correct.
my doubt arises here,

(A) what determines the amount of blocks to be written and the time taken between each writes from the redo buffer to the log files?

(B) What do you mean by a fuzzy file with respect to checkpoint?

Looking forward to hear from you soon, and please let me know whether i can help you in any small ways,

regards,

raymark1

Report this post to a moderator

I can certainly help you with this.
Yes the you need to figure out if you want to having archiving enabled or disabled.

Fuzzy is when the datafiles have not yet been backedup. If you query the V$DATAFILE_HEADER view if the fuzzy column has a yes it means the datafiles are in backup mode. If it is null that means they have been backed up. This changes when you issue the ALTER TABLESPACE END BACKUP command. I've never really heard fuzzy in reference with checkpointing.

You can use the FAST_START_IO_TARGET= n to determine how many data blocks need to be read or written during the rollfoward phase.
Oracle automatically adjusts the checkpoint write rate to meet the specified number. This impoves the performance of crash and recovery time. but has a negitive in that the DBWn is continuously writting.

http://otn.oracle.com/docs/products...inst.htm#438086

If you read this site it should give you some more insite on your questions.
Hope this helped
Melissa

Report this post to a moderator