recovery after full import?

From: Laith Suheimat <l.suheimat_at_mdx.ac.uk>
Date: Tue, 07 Dec 1999 10:55:15 GMT
Message-ID: <82ip2i$1dp$1@nnrp1.deja.com>

Hello,

I have an Oracle Workgroup Server 7.3.4.0 on NT Server 4.0 sp5. One of the tablespaces consisted of two datafiles, one of which had been corrupted (still don't know how) and was flagged as 'missing0022' in dba_data_files.

The database is in Archivelog mode, and full backups are taken every night. A full export is also taken (perl script) every night, but hadn't been running for a while (AT Scheduler screwing up?). I therefore decided to recreate the clone database, reusing the datafiles on disk, and then doing a full import from the last export before the problem with the second datafile. I also restored the archive redo logs, but not the control files.

I now have a working clone database, but what I would like to do is apply all the archived redo logs, to bring the database up to date. Do I need to restore the control file(s) from the date on which I took the export?

Any help appreciated, even Oracle Tech Support are unsure on this one!

Laith Suheimat

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 04:55:15 CST