Re: Startup Error

From: Deke <Deke_at_nospam.com>
Date: Tue, 17 May 2005 15:06:04 -0400
Message-ID: <118kg4uep3ioja8@news.supernews.com>

Rauf Sarwar wrote:
>
> SQL> ALTER DATABASE OPEN RESETLOGS;
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: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\LAP2\SYSTEM01.DBF'

>
> Database altered.
>
> SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'E:\....\TEMP01.DBF'
> 2 SIZE 26214400 REUSE AUTOEXTEND OFF;
>
> Tablespace altered.
>
> SQL>
>
> Regards
> /Rauf
>
Received on Tue May 17 2005 - 14:06:04 CDT