Home » RDBMS Server » Server Administration » Is it Possible
icon2.gif  Is it Possible [message #228381] Mon, 02 April 2007 15:40 Go to next message
Messages: 59
Registered: September 2006
I have Installed a database 9i on Windows 2000 and having imp. data in it but dont know how the database gets damage and the oracle cant load on startup by automatically and manually process. It shows that database is in starting or shutdown in progress even the computer is in remain open for an hour. then i have create another database with name ORCL1 and the database of ORCL1 gets starts normally.
My question is that is there any way of retreiving data from the oradata folder consists of may files of database or any other process to get the data back. be sure that have create a new database in an existing oracle means first SID is ORCL and the 2nd is ORCL1.
Waiting for ur reply
M. Laeeque A.
Re: Is it Possible [message #228431 is a reply to message #228381] Tue, 03 April 2007 00:55 Go to previous messageGo to next message
Messages: 80
Registered: November 2006
Location: India

Try taking the copy of all files( datafiles ) , restore and try to create new control file in ur second database. But this may lose online redo.
Re: Is it Possible [message #228437 is a reply to message #228381] Tue, 03 April 2007 01:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

starting or shutdown in progress

Are you check your alert<sid>.log file why it is happen and what is reason.

Re: Is it Possible [message #228536 is a reply to message #228381] Tue, 03 April 2007 05:41 Go to previous message
Messages: 6
Registered: April 2007
Location: Kolkata
Junior Member
Generally Starting or Shutdown in progress is happened due to the copprution of Redo log files. If the log file status is current(You can see from status column from v$log view) and it is corrupted then the Error is thrown. You should recover your database manually.
Previous Topic: view table change date
Next Topic: upgrade
Goto Forum:

Current Time: Tue Aug 22 23:32:23 CDT 2017

Total time taken to generate the page: 0.01703 seconds