restore/recover database

[dbstudent]

I backed up my database using the controlfile instead of the recovery catalog.I created two tables, call them A and B.I executed some INSERT and UPDATE commands on these two tables. Then i executed a DELETE command in table B. I tried to restore/recover the database to a point in time before the delete. The restore and recover run with no errors:

RESTORE DATABASE UNTIL TIME "TO_DATE('25/02/2005 20:30:34','DD/MM/YYYY HH24:MI:SS')";

RECOVER DATABASE UNTIL TIME "TO_DATE('25/02/2005 20:30:34','DD/MM/YYYY HH24:MI:SS')";

But when i query the tables, i get the first insert made on tables A and totally nothing from table B(the table is empty). What am i doing wrong?

 

[SantaMufasa]

Did you commit before your RECOVER? If not, that is why you did not get any of your transaction upon recovery.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.