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

ORA-21523: functionality not supported by the server (object mode only)

1 Answers  


ORA-31047: Could not retrieve resource data at path string

1 Answers  


DRG-12015: The source document for this operation has moved - continue?

1 Answers  


LPX-00225: end-element tag "~1S" does not match start-element tag "~2S"

1 Answers  


ORA-02333: cannot create constraints on attributes of this column

1 Answers  


ORA-25964: column type incompatible with join column type

1 Answers  


ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


ORA-07208: sfwfb: failed to flush dirty buffers to disk.

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  


ORA-19008: Invalid version of the XMLType

1 Answers  


ORA-31429: subscription has not been activated

1 Answers  


ORA-13832: category name specified is invalid

1 Answers  


Categories