Home » RDBMS Server » Backup & Recovery » ORA-01033 ORACLE initialization or shutdown in progress
ORA-01033 ORACLE initialization or shutdown in progress [message #266281] Mon, 10 September 2007 06:26 Go to next message
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 #266288 is a reply to message #266281] Mon, 10 September 2007 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01207: file is more recent than controlfile - old controlfile
 *Cause:  The controlfile change sequence number in the data file is
         greater than the number in the controlfile. This implies that
         the wrong controlfile is being used. Note that repeatedly causing
         this error can make it stop happening without correcting the real
         problem. Every attempt to open the database will advance the
         controlfile change sequence number until it is great enough.
 *Action: Use the current controlfile or do backup controlfile recovery to
         make the controlfile current. Be sure to follow all restrictions
         on doing a backup controlfile recovery.

Regards
Michel
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266429 is a reply to message #266281] Mon, 10 September 2007 21:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Recreate Control file.
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266443 is a reply to message #266429] Mon, 10 September 2007 23:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, the "action" section is very clear.
If you use an old (or backup) control file, you have to specify a recovery "using backup controlfile", that's all.

Regards
Michel

[Updated on: Mon, 10 September 2007 23:06]

Report message to a moderator

Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266445 is a reply to message #266281] Mon, 10 September 2007 23:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel, if I don't have any backup of control file then what is the way to recover the database.
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266448 is a reply to message #266281] Mon, 10 September 2007 23:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
(RE)create the controlfile
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266463 is a reply to message #266281] Mon, 10 September 2007 23:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I wanted to mean that ((Re)Create controlfile) is the last action that questioner should follow if he is unable to follow Michel's Solution.(Possible reason he don't have backup control file).
But I became a little bit confused when I saw Michel's quote "That's all."
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266466 is a reply to message #266281] Mon, 10 September 2007 23:48 Go to previous messageGo to next message
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.
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266498 is a reply to message #266463] Tue, 11 September 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But OP HAS a control file, it is just older than the files.
So it does not need to rebuild it.
It just have to can recover its database "using backup controlfile".

Regards
Michel
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266551 is a reply to message #266288] Tue, 11 September 2007 02:16 Go to previous messageGo to next message
anujitkumar
Messages: 3
Registered: August 2007
Location: Pune
Junior Member
1.How to make the controlfile current.
2.Pl send the command or steps to make the controlfile current if i have no backup.
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266552 is a reply to message #266429] Tue, 11 September 2007 02:17 Go to previous messageGo to next message
anujitkumar
Messages: 3
Registered: August 2007
Location: Pune
Junior Member
How to create the control file
Re: ORA-01033 ORACLE initialization or shutdown in progress [message #266571 is a reply to message #266551] Tue, 11 September 2007 02:48 Go to previous message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How to make the controlfile current.

Open reset logs.

But you have to first complete your recovery.

Quote:
How to create the control file

You don't need it but if you want see Ana's post.

Regards
Michel
Previous Topic: Export User and conserves his userid
Next Topic: Installation Oracle is GONE, how to recover?
Goto Forum:
  


Current Time: Fri May 17 04:16:46 CDT 2024