Originally posted by hrishy
Hi Amar

Yes..i would surely try it out..but i am kind of curious on how to reproduce this kind of thing probably at home on my home computer..any ideas ;-) ?

Thanks for the suggestions so far..

regards
Hrishy
He he he...

create a default database, ORCL with archive log mode enabled. use hotbackup to backup the tablespaces. meanwhile do some inserts, updates or deletes. end backup, delete the sample database .

use the bakups and archived redologs to restore and recreate the new database, apply archive logs should get the same scenario

best of luck, if i get time and can find space i'll try it too