Change based incomplete recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Change based incomplete recovery

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Change based incomplete recovery

    Hi,

    I've problem with doing change based incomplete recovery,can anyone explain me how to do it.

    In my database,these are all the things i did after connected as sys,

    SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
    1 1 0 104857600 1 YES UNUSED 0
    2 1 0 104857600 1 YES UNUSED 0
    3 1 1 104857600 1 NO CURRENT 450829 17-MAR-06


    SQL> select * from emp;
    ID
    9
    SQL> alter system switch logfile;
    System altered.

    SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
    1 1 2 104857600 1 NO CURRENT 472676 28-MAR-06
    2 1 0 104857600 1 YES UNUSED 0
    3 1 1 104857600 1 YES ACTIVE 450829 17-MAR-06


    SQL>insert into emp values(10);

    SQL> commit

    SQL> select * from emp;

    ID
    ----------
    9
    10

    SQL>shutdown

    Then,i restarted the database to do incomplete recovery such that the newly inserted row shouldn't be there,

    SQL>startup mount

    SQL> recover database until change 472676;
    Media recovery complete.
    SQL> alter database open resetlogs;

    Database altered.

    SQL> select * from emp;

    ID
    ----------
    9
    10


    But the newly inserted row(10) still exists.

    My questions,

    1) What is wrong with my way of doing change based incomplete recovery?

    2) What I've to do such that newly inserted row shouldn't be there?


    Please anyone help me to get out of this problem

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to restore an old backup to be able to go back in time

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