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 |
PLS-00110: bind variable 'string' not allowed in this context
SQL*Loader-00131: Invalid multithreading option
DRG-50300: error sending message from server to client
NZE-28829: no cipher type specified
PCC-00040: Unable to open listing file "string"
ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string
ORA-22369: invalid parameter encountered in method string
ORA-39110: error deleting worker processes
RMAN-06460: Controlfile copy string cannot be backed up by proxy.
DRG-11441: gist numParagraphs string is invalid
ORA-09759: osnsbt: bad message received.
ORA-25121: MINIMUM EXTENT value greater than maximum extent size