Re: Oracle rman SCN

"Daniel" <Daniel.Chmielewski_at_gmail.com> wrote in message news:1176148144.749130.3370_at_q75g2000hsh.googlegroups.com...
> 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
>

Also if you are on 10G and your goal is to restore the table before the drop you can always use the command

 flashback table orders to before drop;

instead of going will a full rman restore.

HTH
Scott Received on Tue Apr 10 2007 - 07:03:24 CDT