ORA-01033 ORACLE initialization or shutdown in progress [message #266281] |
Mon, 10 September 2007 06:26 |
anujitkumar
Messages: 3 Registered: August 2007 Location: Pune
|
Junior Member |
|
|
I am using Oracle 9i server.
When try to log in sqlplus I am facing the ORA-01033 ORACLE initialization or shutdown in progress.
I have trid following
1. connect as sys dba
2.shutdown
3.startup
4. alter database recover datafile 1; (Line no 1 have error)
After fire above command i found this error
1.ora 00283:recovery session cancel due to errors
2 ora-01122:dabase file 1 fail verificatin check
3. ora-01110:datafile 1 : 'c:/oracle/oradata/ora90/system01.dbf
4. ora-01207:file is more recent- controlfile-old controlfile
I have searched the forum but not yet found any solution
can any help me for getting out of the problem
Thnx
Anujit Kumar
|
|
|
|
|
|
|
|
|
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266466 is a reply to message #266281] |
Mon, 10 September 2007 23:48 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DBX1" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 '/a/oracle/oradata/dbx1/redo01.log' SIZE 50M,
GROUP 2 '/a/oracle/oradata/dbx1/redo02.log' SIZE 50M,
GROUP 3 '/a/oracle/oradata/dbx1/redo03.log' SIZE 50M,
GROUP 4 '/a/oracle/oradata/dbx1/redo04.LOG' SIZE 50M,
GROUP 5 '/a/oracle/oradata/dbx1/redo05.LOG' SIZE 50M,
GROUP 6 '/a/oracle/oradata/dbx1/redo06.LOG' SIZE 50M,
GROUP 7 '/a/oracle/oradata/dbx1/redo07.LOG' SIZE 50M,
GROUP 8 '/a/oracle/oradata/dbx1/redo08.LOG' SIZE 50M,
GROUP 9 '/a/oracle/oradata/dbx1/redo09.log' SIZE 50M,
GROUP 10 '/a/oracle/oradata/dbx1/redo010.log' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/a/oracle/oradata/dbx1/system01.dbf',
'/a/oracle/oradata/dbx1/undotbs01.dbf',
'/a/oracle/oradata/dbx1/sysaux01.dbf',
'/a/oracle/oradata/dbx1/users01.dbf',
'/a/oracle/oradata/dbx1/security_data01.dbf',
'/a/oracle/oradata/dbx1/statmarket_data01.dbf',
'/a/oracle/oradata/dbx1/tester_data01.dbf',
'/a/oracle/oradata/dbx1/license_data01.dbf',
'/a/oracle/oradata/dbx1/sample_data01.dbf'
CHARACTER SET AL32UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/a/oracle/product/admin/dbx1/arch/1_1_594126712.dbf';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/a/oracle/oradata/dbx1/temp01.dbf'
SIZE 70254592 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
-- End of tempfile additions.
|
|
|
|
|
|
|