On Apr 9, 12:49 pm, "Daniel" <Daniel.Chmielew..._at_gmail.com> wrote:
> Hi everybody,
> I have a question connected with recovering data from oracle 9/10.
> elow is description and question. Please HELP. The question is a
> little teoretical but very important ;-) Please be patient for my
> mistake ;-) I am new to Oracle ;-|
>
> Shortly my question is: It is possible recover only some part of the
> data from (archive log + redo)?
> Exactly, I'd like to recover only some transactions without some
> others.
>
> Full description below:
>
> DB: oracle 10i and Oracle 9 (with ArchiveLog)
> Database has 3 tables: PERSON, SALES, ORDERS
> Below there are rows with all transactions (DATA/TIME OF TRANS/ SCN/
> AND DESCRIPTION):
>
> TIME SCN DESCRIPTION
> 11:00 1 User adam did: INSERT INTO PERSON SOMEDATA
> 11:05 2 User robert did: INSERT INTO PERSON SOMEDATA
> 11:05 3 User anna did: Insert into ORDERS SOMEDATA
>
> 11:10 4 DBA (or user) did: DROP TABLE ORDERS
>
> 11:11 5 User adam did: INSERT INTO PERSON SOMEDATA
> 11:11 6 User adam did: UPDATE PERSON SOMEDATA
> 11:11 7 User roger did: INSERT INTO PERSON SOMEDATA
> 11:13 8 User roger did: INSERT INTO SALES SOMEDATA
>
> My question is: It is possible to recover ALL DATA without SCN number
> 4?
>
> I think about syntax:
>
> RECOVER UNTIL SCN=3;
> RECOVER FROM SCN=5 TO SCN=8;
> Is it possible?? How?
>
> Please help,
> Daniel
No. You can not "skip" during point-in-time recovery. But if you need
restore deleted table then just create a database clone restored up to
SN=3. Copy droped table into live database. Is this what your goal is?
Received on Mon Apr 09 2007 - 15:47:00 CDT
