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
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
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
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
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,
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
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
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
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
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
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
11 matches
Mail list logo