Solved

startup

Posted on 2013-01-08
5
395 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

708 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

13 Experts available now in Live!

Get 1:1 Help Now