Re: Duplicate v9i database to P-I-T
Date: Tue, 21 Mar 2023 17:56:00 +0000
Message-ID: <CO1PR01MB6709AF3512DECAB3C170BB72CE819_at_CO1PR01MB6709.prod.exchangelabs.com>
I do not think the backups are of any use to you in this case. I suggest you check if you have exports of the table in question and if the purge was done by a DELETE statement and not a TRUNCATE statement you can look into the log miner feature. Log miner can generate the statements to undo the transaction, that is, insert the data.
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sandra Becker <sbecker6925_at_gmail.com> Sent: Tuesday, March 21, 2023 1:20 PM
To: oracle-l <oracle-l_at_freelists.org> Subject: Duplicate v9i database to P-I-T
OS: Solaris 5.8
Oracle: 9.2.0.8 ( I knew this would bite us one day, but I have no control over it.)
Problem: Someone purged all the data from a single table, now they want it recovered to a P-I-T Backups are still on disk, but have aged out. When I list backup of datafile 1, it shows the oldest backup is one day after the one I need. Unfortunately, you can't catalog backups in 9i. We also no longer have Oracle support because the company thought it was a waste of money. Is there anything I can do to duplicate a new database from the backups I need?
Also unfortunate that the production database and the clone are on the same server. Again, I had no choice in the matter. Am I totally screwed in recovering that table?
--
Sandy B.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 21 2023 - 18:56:00 CET