I have Oracle 8i and Unix AIX 4.3.3. I removed a small datafile and I don't have all archives, but I have an old backup of this datafile. This datafile had only four tables. If I can restore the data from this old datafile, it's OK, because the table's data didn't change. How can I restore this data? Thanks.
Since you do not have all of the archived redo logs, your only option is incomplete recovery. You can only roll forward to the point right before your first missing archived redo log file. This means any transactions in the database after and including this missing archived redo log file will be lost. Since you are only looking for these four tables, then I would suggest restoring this database to a different AIX 4.3.3 server. Once you have restored to this other server and opened the database, you can use the export utility to dump just these four tables and then import them into your other database.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.