Re: Recovery without archive log files

No secret switch, just load up your last backup and start the database. NOARCHIVELOG mode means just that. No recovery commands will work because you have overwritten the redo logs without archiving them.

HTH. Pete

Neno wrote:

> 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:36:22 CST