| 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: TSPITR or PITR
No, TSPITR should not be the preferred method. Why not ? Because it
doesn't guarantee that you have achieved consistency of data across objects.
You must still export the "related objects" and bring them in.
Suppose you have a transactions which updates tables in three different
tablespaces. A TSPITR for one tablespace would have one table "older"
than the other two.
Similarly, indexes in a seperate tablespace are inconsistent with the data
and must be recreated.
TSPITR is to be used only when you cannot do a full recovery AND you
can gaurantee that you can recover data consistency.
Hemant
At 11:09 PM 28-06-03 -0800, you wrote:
Hello list I came across the following question in the TMH exam guide
for 1z0-032:
Chris, a DBA, while performing maintenance tasks accidentally drops a
very important table. What is the best method available for Chris to
recover this table if he is aware of the time when the table was
dropped?
A . Change-based recovery
B*. Point-in-time recovery
C . Tablespace point-in-time recovery
D . Cancel-based recovery
Answer : Point-in-time recovery
Wouldn't TSPITR be the best method available in general ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: [EMAIL PROTECTED] (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). Hemant K Chitale
---------------------------------------------------------------------
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: [EMAIL PROTECTED] (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 Sun Jun 29 2003 - 05:57:50 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |