walkerdba
asked on
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
[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
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?
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?
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;
alter database open resetlogs;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes
Which parameter to use depends on what you want to do.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrvcon.htm#BRADV89712