| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: incomplete RMAN recovery
No no no... I'm using the new stealth XML technology....
intellegent parser, requires no tags.
:-)
RF
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 4/21/2003 5:41 PM
Robert, you forgot the <shameless plug> </shameless plug> tags. :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
RMAN will to tablespace point and time recovery (TSPITR) using Oracle's
transportable tablespace feature. You have to setup an auxillary
database,
the tablespace must be transportable, etc....
Off the top of my head I don't recall if it does it in 8i or not, but I
know
it does in 9i.
This is covered in my book, Oracle9i RMAN Backup and Recovery, in detail.
RF
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 4/21/2003 3:57 PM
Thanks for the suggestion . Actaully I already do the point in time
recovery for the complete db . I was guessing if RMAN has got some cute
stuff which can do tablesapce PIT on fly . It might check for the data
integrity and then do the PIT recovery for the tablesapce . This
tablespace
is indepenedent .
-ak
You R doing a NO NO.
Incomplete Tablespace recovery... REALLY... now .. Ask youself ... If I recovery a tablespace to a point in time where does that leave the rest of my database...
You are breakin the fundamental rules.. Point in time Recovery for a
tablespace is more complicated because
you have to recover the entire backup to a point in time... and then use
the
plug in a tablespace method to
get that into your orginal database...
Hope that rings some bells.
Brian Spears
-----Original Message-----
Sent: Monday, April 21, 2003 12:17 PM
To: Multiple recipients of list ORACLE-L
I am testing incomlete tablespace recovery using rman . I dropped a
table at
21-apr-2003 at 8:10 . Using following script to reocery the tablespace.
Script does work . But I am not able to see dropped table . Why is it
not
recovering until time 8:03 .
Any Idea ?
run {
SQL "ALTER SESSION SET NLS_DATE_FORMAT=''DD-MON-YYYY HH24:MI:SS''";
set until time '21-apr-2003 08:03:00';
sql "alter tablespace akdata offline temporary";
allocate channel ch1 type disk;
restore tablespace akdata;
recover tablespace akdata ;
release channel ch1;
sql "alter tablespace akdata online";
}
thanks,
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: FREEMANR_at_tusc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Sharman
INET: peter.sharman_at_oracle.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 21 2003 - 18:06:38 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |