Recovery without archive log files

From: Neno <neno_at_gbg.ifsab.se>
Date: Thu, 16 Dec 1999 16:37:39 +0100
Message-ID: <PQdZONi2ajDqrGzlIWA8BsStNnlj@4ax.com>

Hello

        I'm trying to recover database after some disk problems. Database is running in NOARCHIVE mode and there is no critical data in it (only development and test). During startup, it is only possible to mount database and when we try to recover it, following message is generated:

SVRMGR> startup mount pfile=E:\Oradb\G041\initg041.ora ORACLE instance started.

Total System Global Area      41206488 bytes
Fixed Size                       35760 bytes
Variable Size                 40752936 bytes
Database Buffers                409600 bytes
Redo Buffers                      8192 bytes

Database mounted.
SVRMGR> recover
ORA-00279: Change 32493925 generated at 12/12/99 16:29:59 needed for thread 1
ORA-00289: Suggestion : D:\ORANT\RDBMS73\%ORACLE_SID%21247.001 ORA-00280: Change 32493925 for thread 1 is in sequence #121247  Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'D:\ORANT\RDBMS73\%ORACLE_SID%21247.001'

ORA-09202: sfifi: error identifying file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

SVRMGR> There is no archived log file (NOARCHIVE mode) and we do not want to recover data, we only want to avoid new installation of database. The question is:
Is there any work around to open database in current state (inconsistent data), i.e. any secret switch, init.ora parameters or something...

Neno Received on Thu Dec 16 1999 - 09:37:39 CST