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

On Apr 9, 2:49 pm, "Daniel" <Daniel.Chmielew...@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, it is not possible. You can recover UNTIL a specified SCN but you
cannot specify a starting SCN.


David Fitzjarrell

Daniel wrote:

> I think about syntax:
>
> RECOVER UNTIL SCN=3;
> RECOVER FROM SCN=5 TO SCN=8;
> Is it possible?? How?
>
> Please help,
> Daniel

3? 5? 8?

Run this query:

SELECT current_scn
FROM gv$database;
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Apr 9, 12:49 pm, "Daniel" <Daniel.Chmielew...@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?

- Roman

On Apr 9, 12:49 pm, "Daniel" <Daniel.Chmielew...@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.

http://download-west.oracle.com/docs...iner.htm#24656

jg
--
@home.com is bogus.
Master Cylinder! http://www.nydailynews.com/news/2007...elix_flap.html

"Daniel" <Daniel.Chmielewski@gmail.com> wrote in message
news:1176148144.749130.3370@q75g2000hsh.googlegrou ps.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

> 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
>

Or maybe the table is still in the recycle bin : SELECT * FROM
DBA_RECYCLE_BIN;


Matthias

On 10 Kwi, 17:16, "Matthias Hoys" <a...@spam.com> wrote:
> > 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
>
> Or maybe the table is still in the recycle bin : SELECT * FROM
> DBA_RECYCLE_BIN;
>
> Matthias

THANKS VERY VERY MUCH FOR YOUR HELP. THANKS TO EVERYBODY.