OraFAQ Forum: Server Administration » Oracle 10g database cannot open

Home » RDBMS Server » Server Administration » Oracle 10g database cannot open

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g database cannot open [message #64622]

Tue, 15 February 2005 22:15

Dinil Antony
Messages: 1
Registered: February 2005

Junior Member

SQL> startup open
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

this is the version of oracle database i use

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 16 12:47:06 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

i cannot access the database please help if any on has come across this issue

Report message to a moderator

Re: Oracle 10g database cannot open [message #64627 is a reply to message #64622]

Wed, 16 February 2005 05:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please try

--
-- Warning: whne opening the database with resetlogs
-- beware that database is acquiring a new "life"
-- any previous backup will not be seen ( with RMAN you
-- can reset that)
-- if below gives you more errors like
-- "file xxx needs media recovery"
-- then you may need to recover the database
sql> alter database open resetlogs;

Report message to a moderator

Re: Oracle 10g database cannot open [message #64628 is a reply to message #64622]

Wed, 16 February 2005 05:07

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

What was the last operation performed on the DB? Also, please post the last couple of lines from your ALERT.LOG file.

Best regards.

Frank

Report message to a moderator

Re: Oracle 10g database cannot open [message #108840 is a reply to message #64627]

Sat, 19 February 2005 01:02

Loqman
Messages: 1
Registered: February 2005

Junior Member

if below gives you more errors like
-- "file xxx needs media recovery"
-- then you may need to recover the database
sql> alter database open resetlogs;

Report message to a moderator

Previous Topic:	installation problem
Next Topic:	I DON'T HAVE THIS FILE! tnslsnr.exe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:22:45 CDT 2024