| Oracle startup problem [message #61317] |
Wed, 14 April 2004 01:05  |
Bharath Kumar ,V
Messages: 18
Registered: February 2004
|
Junior Member |
|
|
Hi,
I've Windows oracle 9iR2 server, when I start my oracle server I got the following error. Could any please help me out regarding this issue.
SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'D:ORACLEORADATAORCLEXAMPLE01.DBF'
I think EXAMPLE01.DBF file has been corrupted. In this case how do I start my oracle server. Is there any possibilities to start the oracle server without EXAMPLE01.DBF?
|
|
|
|
| Re: Oracle startup problem [message #61318 is a reply to message #61317] |
Wed, 14 April 2004 01:48  |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
Hi Bharat,
Since this Datafile is corrupted and database is not starting up, What you can do is, start the database in mount state and take this datafile offline and start the database.
SQL>alter database datafile 'D:ORACLEORADATAORCLEXAMPLE01.DBF' offline;
SQL>alter database open;
I hope this would work for you and let me know this.
with rgrds
Sujit
|
|
|
|
| Re: Oracle startup problem [message #61329 is a reply to message #61318] |
Thu, 15 April 2004 01:16 |
Bharath Kumar ,V
Messages: 18
Registered: February 2004
|
Junior Member |
|
|
Hi Sujit,
Thanks for the reply, I've some problem to posting in orafaq.com,
I got the following error :(
SQL> startup mount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database datafile 'D:ORACLEORADATAORCLEXAMPLE01.DBF' offline;
alter database datafile 'D:ORACLEORADATAORCLEXAMPLE01.DBF' offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
But Now I fix it..
First I do
ALTER DATABASE ARCHIVELOG; then I did your commands
After I did the above I'm not able to import the dmp file to the above oracle server, when I tried to imp the dump file it gets hang.
Please help me out regarding this issue.
Thanks and Regards
Bharath.
|
|
|
|
| Re: Oracle startup problem [message #61333 is a reply to message #61329] |
Thu, 15 April 2004 05:35 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If your database is in Noarchivelog mode, you would need to
alter database datafile 'filename' OFFLINE DROP;
to offline the datafile and open the database.
When you switch to ARCHIVELOG mode, did you start archiver process? ie) LOG_ARCHIVE_START = true . You could also start archiver process manually by 'archive log start;' at sqlplus , but if you are going to switch to ARCHIVELOG mode permanently ( and this is probably not the right time to switch logging mode , in the middle of recovery),then you would rather start arch process automatically ,by enabling log_archive_start.
Otherwise LGWR would not be able to overwrite the online redolog file since it hasnt been archived by the ARCH process and your database operations(like import) would hang.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
