DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Question on Recovery

  1. #1
    Join Date
    Dec 2000
    Posts
    138

    Hi
    I tried to do this on a test machine(win2k) to see how rocovery process works for a Point in time, it seems that it is not working - i am going wrong somewhere,

    this is how i did
    SVRMGR> alter tablespace users begin backup;

    copy datafile users01.dbf as users01.bak

    SVRMGR> alter tablespace users end backup;

    create a table T1 insert some records;
    commit it
    create a table T2 insert soem records;
    commit it;

    Time: 16:39:00
    at Time 16:40:00 I drop table T2.
    assuming now i want the table back
    I do the below.


    SVRMGR> shutdown immediate

    rename datafile users01.bak to users01.dbf

    SVRMGR> startup mount

    SVRMGR> alter database datafile 'D:\oracle\oradata\orcl\USERS01.DBF' online;
    Statement processed.

    SVRMGR> recover datafile 'D:\oracle\oradata\orcl\USERS01.DBF';
    Media recovery complete.
    SVRMGR> recover database until time '2001-05-01:16:39:00';
    Media recovery complete.
    SVRMGR> alter database open resetlogs;


    after this i log on and find the table T1 is there with data but couldnt find table T2.

    What is the problem in this procedure.
    Thanks for any help
    -dharma

  2. #2
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    recovery...

    hi,
    did you get an error like ORA-00942...table does not exist...like that.
    then locate ....it by quering
    select table_name from dba_tables where table_name like 'T2';
    If no rows are selected,then the table is not restored correctly.You will need to recover to an earlier point in time,....otherwise the steps are correct...
    Try these queries and redo it.You will get it.
    did you put this in archivelog mode?.
    Good luck.
    Thanigaivasan.

  3. #3
    Join Date
    Dec 2000
    Posts
    138
    Hi Thanigai,
    yes its in archive logmode, and i did not get any errors.its as perfect as that except for the missing table.
    Thnx a lot.
    -dharma

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution-try it again

    Hi, 5th May 2001 20:59 hrs chennai

    Did you restore properly the old datafile from last backup and tried it?

    This process you have to try by moving earlier point in time.

    Even in oracle docs its said like that try again.

    Cheers

    padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by dharma

    SVRMGR> recover datafile 'D:\oracle\oradata\orcl\USERS01.DBF';
    Media recovery complete.
    This is your problem. You have recovered until the current time. At the current time, T2 has already been dropped.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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