Re: Startup Error

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 17 May 2005 14:18:33 -0700
Message-ID: <1116364476.899297@yasure>

Deke wrote:
> 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

Two things Deke:

1. Do not top post.
2. Advice received in this group may be well meaning but may be incomplete and cause grevious harm. Stop posting here and open a TAR with Oracle ASAP.

    At this point you can easily make things far worse than they     already are.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue May 17 2005 - 16:18:33 CDT