Hi,
This is ROhit Nirkhe,Oracle DBA,OCP from India.
In order to perform point in time recovery of a dropped table first ur database must be in archivelog mode.

I will give u a scenario so that u can understand the concept.
foe e.g Say at 12:00 noon a user drop a important table and he came to u at 1:00 pm saying that u want to recover the table.In this case u have to perform incomplete recovery.U have to take ur database to the point when the table existed.

Step 1: Shutdown the database with immediate/normal option
Step 2: Backup all the datafiles,controlfiles and redo logfiles
Step 3: Copy all the datafiles from the last backup
Step 4: Mount the database
Step 5: Give the following command
RECOVER DATABASE UNTIL TIME
'2000-02-19:11:55:30';
Step 6: It will apply all the redo logs till that time
Step 7: Open the database with resetlog option
Step 8: Backup the database again.

In case of any problem,please be write to
[email protected]

regards,
Rohit Nirkhe,OCP





[QUOTE][i]Originally posted by yenni143 [/i]
[B]Hi Friends,
Can somebody send me the detailed steps for point in time recovery of a dropped table?

thanks [/B][/QUOTE]