ORA-01033: ORACLE initialization or shutdown in progress
Answers were Sorted based on User's Feedback
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 |
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 |
IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter
ORA-12341: maximum number of open mounts exceeded
ORA-25213: message with specified RELATIVE_MSGID has been dequeued
NNO-00622: warning: too many auto-refresh failures for name "string", query expired
ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.
UDI-00014: invalid value for parameter, 'string'
ORA-29291: file remove operation failed
ORA-16576: failed to update Data Guard configuration file
NNO-00252: invalid administrative region parameter string value "string"
ORA-01070: Using an old version of Oracle for the server
ORA-13220: failed to compare tile with the geometry
ORA-22163: left hand and right hand side collections are not of same type