Time based Recovery to recover a dropped table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Time based Recovery to recover a dropped table

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Time based Recovery to recover a dropped table

    To learn time based recovery to recover a dropped table practically,i did the following.

    SQL> create table emp(id number)

    Table created.

    SQL> insert into emp values(1);

    1 row created.

    SQL> commit;

    Commit complete
    .

    I dropped the table at March 15,2006-2:25P.M.

    SQL> drop table emp;

    Table dropped.


    To do time based recovery,I shutdown the database..

    SQL> shutdown
    Database closed.
    Database dismounted.
    ORACLE instance shut down.


    Then,i mount the database..

    SQL> startup mount

    Then,i issued the following command,to do time based recovery & to recover the table..

    SQL> RECOVER DATABASE UNTIL TIME '2006-04-15:02:20:00';
    Media recovery complete.


    Since i recovered the database to the time 2:20P.M,the dropped table EMP should be there now,but when i tried to look at the table,it shows the table doen't exist,

    SQL> SELECT * FROM EMP;
    SELECT * FROM EMP
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    My questions are,

    1)Why the table "EMP" is not recovered?

    2)Did i do anything wrong while doing the time based recovery?

    3) If the procedure i followed to do time based recovery is wrong,can anyone explain me,how to do this & recover a dropped table?


    Thanks,
    Malru

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    I wonder whether the 02:20:00 in your recovery should be 14:20:00, as you dropped your table at 02:25:00PM according to 'I dropped the table at March 15,2006-2:25P.M.' earlier.
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you recovered until 15th April 2006, you went right past the point at which you dropped the table

  4. #4
    Join Date
    Feb 2006
    Posts
    162

    Time based Recovery to recover a dropped table

    Hi,

    As you told i did the following,I created a table "EMP" at March 15,2006,3:40P.M,


    Then i dropped the table at 3:45,

    I issued the following command to recover the table,


    recover database until time '2006-03-15:15:43:00';

    But the table "EMP" is not recovered,still it shows table "EMP" doesn't exist.

    Please anyone help me in how to recover the dropped table.


    Thanks,
    Malru.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    in your original post you had this


    SQL> RECOVER DATABASE UNTIL TIME '2006-04-15:02:20:00';
    Media recovery complete.

    That is the 15th March 2006, if that isnt what you did then stop writing crap in your posts and post the real examples from a copy and paste from the screen

    Who knows what else you are making up

  6. #6
    Join Date
    Feb 2006
    Posts
    162

    Time based Recovery to recover a dropped table

    Mr.davey23uk,

    I'm new to DBA,i'm in learning process,i just copied & pasted the work i did in SQL* Plus & you know my mistake i gave the query as April 15th,2006 only & it gave the result exactly what i posted.

    ok.. anyway after seeing your reply,i found my mistake & corrected it,issued the query with the date March 15,2006.This time also,i'm getting the same problem and i made it clear to you.

    As a Senior member,you found the mistake i made & i corrected it next time,now it's your responsibility to give the proper answer,but it's not the way to behave,if you're really interested and able to help me,do so,otherwise don't send rubbish replies..

    Good bye...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width