Re: Can't open database
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Jul 2004 07:13:22 -0700 (PDT)
--- Rivaldi Bahar <rbahar99@xxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
