Re: Duplicate v9i database to P-I-T
Date: Tue, 21 Mar 2023 18:08:31 +0000
Message-ID: <DM6PR15MB410802925D2665927E3070B9C5819_at_DM6PR15MB4108.namprd15.prod.outlook.com>
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)
OS: Solaris 5.8
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?
--
--
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
Oracle: 9.2.0.8 ( I knew this would bite us one day, but I have no control over it.)
Sandy B.
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 21 2023 - 19:08:31 CET