ORA-01033: ORACLE initialization or shutdown in progress

Answers were Sorted based on User's Feedback



ORA-01033: ORACLE initialization or shutdown in progress..

Answer / guest

Cause: An attempt was made to log on while Oracle is being
started up or shutdown.

Action: Wait a few minutes. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

ORA-01033: ORACLE initialization or shutdown in progress..

Answer / pankaj

1. Startup the database with the mount option

SQL> startup mount
ORACLE instance started.

Total System Global Area 2684354560 bytes
Fixed Size 1981064 bytes
Variable Size 436209016 bytes
Database Buffers 2231369728 bytes
Redo Buffers 14794752 bytes
Database mounted.


2. Find the name of the redo log file which belongs to
the active group

SQL> SELECT MEMBER FROM V$LOG G, V$LOGFILE F WHERE
G.GROUP# = F.GROUP#
2 AND G.STATUS = 'CURRENT';

MEMBER

--------------------------------------------------------------------------------
/OraRedo/RedoLogFiles/siamst_log01.dbf


3. Using a backup control file, start the cancel based
recovery. The system may suggest a non-existing archive log
-- ignore it and specify the log file name {with full path}
that you got in the above step

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL
CANCEL
ORA-00279: change 21375038 generated at 09/21/2007
20:12:47 needed for thread 1
ORA-00289: suggestion :
/export/pspp/oracle/dbs/arch1_4_633901491.dbf
ORA-00280: change 21375038 for thread 1 is in sequence #4

Specify log: {=suggested | filename | AUTO | CANCEL}
/OraRedo/RedoLogFiles/siamst_log01.dbf
Log applied.
Media recovery complete.


4. Finally open the database in RESETLOGS mode. It is
recommended to reset the online logs after incomplete
recovery or recovery with a backup control file

SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

1 Answers  


ORA-12341: maximum number of open mounts exceeded

1 Answers  


ORA-25213: message with specified RELATIVE_MSGID has been dequeued

1 Answers  


NNO-00622: warning: too many auto-refresh failures for name "string", query expired

1 Answers  


ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

1 Answers  


UDI-00014: invalid value for parameter, 'string'

1 Answers  


ORA-29291: file remove operation failed

1 Answers  


ORA-16576: failed to update Data Guard configuration file

1 Answers  


NNO-00252: invalid administrative region parameter string value "string"

1 Answers  


ORA-01070: Using an old version of Oracle for the server

1 Answers  


ORA-13220: failed to compare tile with the geometry

1 Answers  


ORA-22163: left hand and right hand side collections are not of same type

1 Answers  


Categories