Re: Recovery without archive log files

After the startup mount, issue a 'recover database using backup controlfile'

when a logfile is requested, enter the filename (inc. path) of the LAST used online redo log.

A 'Media Recovery Complete' message should be issued. After this issue 'alter database open resetlogs'

hope this helps,
NeilC.

Neno wrote in message ...
>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 - 10:10:27 CST