• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

startup

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
walkerdba
Asked:
walkerdba
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
shomilbCommented:
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
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
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
 
slightwv (䄆 Netminder) Commented:
>>therefore use below statement

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now