It likely has been too long at this point, but I believe flashback existed in
9i. You may be able to select the data using flashback query and insert it
into a new table for analysis.
Mike
---
Michael J Pecoraro
Database Administrator | Enterprise Infrastructure Services
University at Buffalo Information Technology (UBIT)
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sandra Becker <sbecker6925@xxxxxxxxx>
Sent: Tuesday, March 21, 2023 1:20 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
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.