Re: Table recovery from RMAN backup

2003-12-12 Thread Andy Rivenes
Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At

Re: Table recovery from RMAN backup

2003-12-12 Thread Mladen Gogala
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've

RE: Table recovery from RMAN backup

2003-12-12 Thread Josh Collier
Metalink Note:223543.1 has good information on how to recover just a single table using a modified TSPITR. I performed this operation successful on a data warehouse. Josh -Original Message- Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Jay, if it is

Re: Table recovery from RMAN backup

2003-12-12 Thread jaysingh1
Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami - Original Message - Date: Friday, December 12, 2003 11:34 am Take a look at TSPITR (tablespace point

Re: Table recovery from RMAN backup

2003-12-12 Thread Tanel Poder
Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 6:59 PM Jay,

Re: Table recovery from RMAN backup

2003-12-12 Thread Simon . Anderson
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Table recovery from RMAN backup Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. -- Please

Re: Table recovery from RMAN backup

2003-12-12 Thread Andy Rivenes
The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I

Re: Table recovery from RMAN backup

2003-12-12 Thread Mladen Gogala
Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of

Re: Table recovery from RMAN backup

2003-12-12 Thread Joe Testa
Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for

Re: Table recovery from RMAN backup

2003-12-12 Thread Ron Rogers
Sami, While you are purchasing the reading material also look at the 101 series as excellent references. Oracle Performance tuning 101, Oracle dba 101, Oracle backup and recovery 101.There are a lot of excellent references on the market and a lot of authors participate on this list. You can

Re: Table recovery from RMAN backup

2003-12-12 Thread Michael Thomas
My Question: I just tried to locate the web site for Joe's scripts, and I got an error or something. Wasssup? My Contribution (xmas season and all...): http://www.secunia.com/internet_explorer_address_bar_spoofing_test Is it too early to wish merry xmas to all? Thanks in advance. Regards, Mike