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 |
ORA-21523: functionality not supported by the server (object mode only)
ORA-31047: Could not retrieve resource data at path string
DRG-12015: The source document for this operation has moved - continue?
LPX-00225: end-element tag "~1S" does not match start-element tag "~2S"
ORA-02333: cannot create constraints on attributes of this column
ORA-25964: column type incompatible with join column type
ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified
ORA-07208: sfwfb: failed to flush dirty buffers to disk.
ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid
ORA-19008: Invalid version of the XMLType
ORA-31429: subscription has not been activated
ORA-13832: category name specified is invalid