recover database until time...

I'm testing out various recovery procedures for Oracle 7.1.3, and I'm wondering if there is any way to perform a time-based incomplete recovery if the physical structure of the database has changed. I tried replacing the control files with earlier copies (ie. consistent with the time I'm trying to recover to) and issuing the SQL*DBA command:

SQLDBA> recover database until time '1995-03...' using backup controlfile

which appears to work, but then when I issue

SQLDBA> alter database open resetlogs;

Oracle complains about files still needing media recovery. It seems that the only way to recover from here is to do a complete recovery.

I also tried this without restoring the control files, and I get the same problems. Suggestions anyone?

TIA Michael Klein
DataTools, Inc.
klein_at_datatools.com Received on Thu Mar 02 1995 - 01:48:17 CET