OraFAQ Forum: Server Administration » Need help urgently in starting DB

Home » RDBMS Server » Server Administration » Need help urgently in starting DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help urgently in starting DB [message #189931]

Mon, 28 August 2006 11:34

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

Report message to a moderator

Re: Need help urgently in starting DB [message #189933 is a reply to message #189931]

Mon, 28 August 2006 11:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Do you have a backup of any sort?

Report message to a moderator

Re: Need help urgently in starting DB [message #189937 is a reply to message #189931]

Mon, 28 August 2006 11:50

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

Report message to a moderator

Re: Need help urgently in starting DB [message #189939 is a reply to message #189937]

Mon, 28 August 2006 12:00

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Need help urgently in starting DB [message #189940 is a reply to message #189937]

Mon, 28 August 2006 12:07

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Need help urgently in starting DB [message #189942 is a reply to message #189931]

Mon, 28 August 2006 12:25

grk28
Messages: 38
Registered: June 2006

Member

Hi Mahesh,

It worked.Thanks alot.

It reduced my work alot.Thanx once again Smile

.

Regards,
GRK

Report message to a moderator

Re: Need help urgently in starting DB [message #190109 is a reply to message #189942]

Tue, 29 August 2006 05:18

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

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

Report message to a moderator

Previous Topic:	REF dependency
Next Topic:	CKPT Process Fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:21:54 CDT 2024