RE: Tablespace recovery

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 19 Oct 2004 12:02:49 -0400
Message-ID: <001401c4b5f5$14dd7810$8459000a@vttaxnet.tax.state.vt.us>

Backup you test database,open it in mount state, restore the tablespace in question, do not try to recover because you do not have archivelogs, and open. Export the table from the test database and import it into the target database. This may fail along the way, and if it does let me know, but this should do it.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of steve noyle Sent: Monday, October 18, 2004 4:27 PM
To: oracle-l_at_freelists.org
Subject: Tablespace recovery - TSPITR??

I have a table that I need to recover from an old backup. I seem to recall reading somewhere that I can just plug in the old datafile into my test database and access the table that way. The table is the only object in the datafile. Unfortunately I do not have any archived logs available. What I have available is a test database and an old backup file where the table resides.

If that is not possible, what are my options?

test database - 9.2.0.3 on HPUX
the old backup file was originally also from a 9.2.0.3 database on HPUX.

thanks.

steve

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 19 2004 - 10:58:21 CDT

RE: Tablespace recovery - TSPITR??