Solved

startup

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

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

773 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