- Rivaldi Bahar <rbahar99_at_plasa.com> wrote:
> Hi,
>
> I'm curious if I still have an option to open the
> database....
> The database is not in archivelog mode, online
> logfiles
> are overwritten, old controlfiles gone. Undocumented
>
> parameter from metalink didn't help.
>
> Tia.
>
> -riv-
>
>
> SQL> @riv_file.sql
>
> ORACLE instance started.
>
> Total System Global Area 202868968 bytes
>
> Fixed Size 731368 bytes
>
> Variable Size 167772160 bytes
>
> Database Buffers 33554432 bytes
>
> Redo Buffers 811008 bytes
>
>
> Control file created.
>
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01194: file 1 needs more recovery to be
> consistent
> ORA-01110: data file 1:
> '/oradata/qcmscl_13072004/system01.dbf'
>
>
> SQL> spool off
did you:
- take a backup of what you had before you started?
- determine which was the current online redo log
- apply the current online redo log?
hth.
Pd
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 13 2004 - 09:10:31 CDT
