Re: Can't open database

--- 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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: