Point in Time recovery
Hi All,
If a table is dropped at 12pm and I need to recover it using point in time recovery on say a Oracle 7.3.2. DB on AIX box ; I assume this is the right strategy :
1. Restore the previous full backup
2. Make sure all the arch logs are available on disk
3. startup mount
4. recover database until time 'YYYY-MM-DD:HH24:MI:SS'
time being used say : 11:55am - 11:59am ; I should be able to recover the table I'd presume ?
Is this the right step ? Or should I resort to another recover syntax based on cancel ?
I cant try on a test server on identical config however I did try get this to work ( i.e. recover the missing table ) on a 10g DB; but wasnt successful.
Your advice please.
Edited by: user4874781 on Apr 28, 2009 11:00 PM