RECOVERY SCENARIO

[ggnanaraj]

A clarification please...

Consider the following scenario... I have a offline complete backup taken on Sunday. the other days of the week I have taken online backup.

Now if my whole system crashes on Thursay, how do I recover?

If I restore the offline backup of Sunday, I loose 3-4 days of data in the database.

How can I utilize the online backup that I have taken till Wednesday?

Thanks.

[vijay8282]

Hi

So you have 2 options :

1) Restore Sundays backup and then apply arch. logs then u can get ur database in consistent state.

2) If alongwith online backups u hv taken control file backup also then restire online backup alngwith control file and then apply arch files and u'll have the database up.


If someone have different views pls. post.