Home » RDBMS Server » Server Administration » Need help urgently in starting DB
Need help urgently in starting DB [message #189931] Mon, 28 August 2006 11:34 Go to next message
grk28
Messages: 38
Registered: June 2006
Member
Hi Frnds,

I am using Oracle 10G DB Linux version.
We were creating one user in the server as there was no space in the machine the user creation failed.So we thought of removing some files.There is a file on machine with .dmp extension ,we thought it as backup/dump file and then removed that.It didn't give any error/warning while deleting .After deleting we were looking into the space but there is no improvement ,so we rebootedthe machine and we got some good amt of space,felt very happy .But unfortunately when we started the db it was looking into the file which we deleted and is not starting up.

Then we came to know that it is not the .dmp file and it is .dbf file of existing user which was created with wrong extension .I am thinking that it is looking forthe corresponding dbf file while starting and as it is removed it is throwing error.Please correct me if i am wrong.

So,my question is "Is there any way to start the DB or do we need to reinstall the ORacle".

Immediate help would be appreciated.

Regards,
GRK



Re: Need help urgently in starting DB [message #189933 is a reply to message #189931] Mon, 28 August 2006 11:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do you have a backup of any sort?
Re: Need help urgently in starting DB [message #189937 is a reply to message #189931] Mon, 28 August 2006 11:50 Go to previous messageGo to next message
grk28
Messages: 38
Registered: June 2006
Member
Hi Mahesh,

Thnx for immediate response.

I did not get you.You mean to say backup of the users in that server.unfortunately we are not having bkp for all users.

Is there any way to start the db ?

Regards,
GRK
Re: Need help urgently in starting DB [message #189939 is a reply to message #189937] Mon, 28 August 2006 12:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Nothing that i know about.
If you are not worried about the data, just start over.
create a new database.
Re: Need help urgently in starting DB [message #189940 is a reply to message #189937] Mon, 28 August 2006 12:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Or if you not worried about the lost datafile (and the corresponding data )
you cant try this.
sys@9i > startup
ORACLE instance started.

Total System Global Area  504858576 bytes
Fixed Size                   731088 bytes
Variable Size             167772160 bytes
Database Buffers          335544320 bytes
Redo Buffers                 811008 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/app/oracle/oradata/mutation/tools01.dbf'


sys@9i > shutdown abort
ORACLE instance shut down.
sys@9i > startup mount;
ORACLE instance started.

Total System Global Area  504858576 bytes
Fixed Size                   731088 bytes
Variable Size             167772160 bytes
Database Buffers          335544320 bytes
Redo Buffers                 811008 bytes
Database mounted.
sys@9i > alter database datafile '/u01/app/oracle/oradata/mutation/tools01.dbf' offline drop;

Database altered.

sys@9i > shutdown abort
ORACLE instance shut down.
sys@9i > startup
ORACLE instance started.

Total System Global Area  504858576 bytes
Fixed Size                   731088 bytes
Variable Size             167772160 bytes
Database Buffers          335544320 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.




Re: Need help urgently in starting DB [message #189942 is a reply to message #189931] Mon, 28 August 2006 12:25 Go to previous messageGo to next message
grk28
Messages: 38
Registered: June 2006
Member
Hi Mahesh,

It worked.Thanks alot.

It reduced my work alot.Thanx once again Smile.

Regards,
GRK
Re: Need help urgently in starting DB [message #190109 is a reply to message #189942] Tue, 29 August 2006 05:18 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
.. ha ha ha ... Very Happy

GRK you need DBA for your database ...

I am not kidding.... Maheshji is good enough to start any database he got an idea from your second post that you dont have backup of datafile which was deleted ... ha ha Very Happy

[Updated on: Tue, 29 August 2006 05:22]

Report message to a moderator

Re: Need help urgently in starting DB [message #190122 is a reply to message #189931] Tue, 29 August 2006 05:41 Go to previous message
grk28
Messages: 38
Registered: June 2006
Member
Hi Sunil,

Thanks for your suggestion..

Well the thing is it is not the production server it is just a test server .We generally have the backups in the same machine but for this we don't have a backup as we are having replicas of the same instance in many other machines.We were in need of this DB but it is not starting coz of the file which was missing,so apporached you ppl so that i can get some info.


Here the file which we deleted is not so important but the starting of DB is more important as there are many other instances in that machine.So,Mahesh has given the procedure to start DB.

I do agree with you Sunil cause i am having very little exposure to DBA concepts.

Regards,
RK


Previous Topic: REF dependency
Next Topic: CKPT Process Fails
Goto Forum:
  


Current Time: Sat Dec 10 03:08:30 CST 2016

Total time taken to generate the page: 0.09241 seconds