Solved

startup

Posted on 2013-01-08
5
397 Views
Last Modified: 2013-01-25
How can we startup the database..

[oracle@wtu 112]$ export ORACLE_SID=orcl
[oracle@wtu 112]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 8 14:57:27 2013

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1707446272 bytes
Fixed Size                  1336988 bytes
Variable Size            1124075876 bytes
Database Buffers          570425344 bytes
Redo Buffers               11608064 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
0
Comment
Question by:walkerdba
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38757115
issue the  'alter database open' with either resetlogs or noresetlogs.

Which parameter to use depends on what you want to do.

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrvcon.htm#BRADV89712
0
 

Expert Comment

by:shomilb
ID: 38777309
What was done to the database earlier? Did you recreate the control file?
Was the database restored? What steps did you follow to restore.
Any problem in opening the database in resetlogs? Did you give it a try?
0
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 38808151
After recovering, it is required to reset the logs in certain case, therefore use below statement, but you will loose log history.

alter database open resetlogs;
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38809725
>>therefore use below statement

It depends on the recovery.  noresetlogs  may actually be the correct action.  Anyway, both options have alreday been posted.
0
 

Author Closing Comment

by:walkerdba
ID: 38821456
yes
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now