Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table point-in-time recovery with only one instance / database

Table point-in-time recovery with only one instance / database

From: <jms.news_at_gmail.com>
Date: Thu, 07 Jun 2007 23:48:45 -0000
Message-ID: <1181260125.163347.56730@q19g2000prn.googlegroups.com>


I am doing a performance and regression testing of an application
( irrelevant at this point ). What that I am trying to do is:

  1. Export all of the user's data
  2. Run the application
  3. Drop all of the user's objects and import the user's data from step [1].
  4. Run modified application
  5. Compare run-time and performance between [2] and [4].

Instead of doing an export and import of all of the user's data
( tables, indexes, etc... ), I was wondering if it would be possible
to do a tablespace point-in-time recovery instead as some of the table are large, and doing an import will take several hours specially when the indexes are built. The user has data and indexes stored only on a few tablespaces.

However, after reading the docs for TSPITR via transportable tablespaces, it is saying that you need 2 databases: 1) The primary and 2) The auxiliary. But I don't have such luxury. Is there anyway to do a TSPITR with just the one database ?? Received on Thu Jun 07 2007 - 18:48:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US