Hello everybody
I'm trying to recover a full database from a hot backup.
When I execute the following instruction:
SQL> recover database using backup controlfile until cancel;
Then I obtain the error ora-00331,
This is the output:
ORA-00279: change 1581950488 generated at 01/18/04 21:00:01 needed for thread 1
ORA-00289: suggestion : C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
ORA-00280: change 1581950488 for thread 1 is in sequence #9537
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
ORA-00331: log version 8.1.0.0.0 incompatible with ORACLE version 8.0.5.0.0
ORA-00334: archived log: 'C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\ORADATA\CAMBIOS\SYSTEM01.DBF'
In the Oracle Documentation The solution to the error ora-00331 is to recover the database using the old software. The problem is tha I don't have the old software.
Is there a way to change the log version or what can I do?
Regards,
Mauricio Vélez
Do you Yahoo!?
Yahoo! Hotjobs:
Enter the "Signing Bonus" Sweepstakes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vélez"
INET: oraclemavelgo_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jan 20 2004 - 18:34:37 CST
