OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Test Server....

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

Test Server.... [message #264698]

Tue, 04 September 2007 04:25

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi experts,
Suddently my test server harddisk got infected virus.i couldn't able to recover that data.But i have got my oracle database folder.Now what is the way to get my database everything. It is contains 4 gb of data. Any Experts could you help on this scenario....

Thanks in Advance

Report message to a moderator

Re: Test Server.... [message #264700 is a reply to message #264698]

Tue, 04 September 2007 04:31

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OS?
Version?
What are the file you have? data files? control files? redo logs? archived logs? init files? spfile? password files? Oracle binaries?...

Regards
Michel

Report message to a moderator

Re: Test Server.... [message #264702 is a reply to message #264700]

Tue, 04 September 2007 04:36

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi Michel,
Thanks for your Reply...
OS:Windows 2003 server R2

Ver:10gR2

I have whole oracle folder safely.

including data files,control files,redo logs, archived logs, init files, spfile, password files, Oracle binaries....

Thanks in Advance

With regards
sundar

Report message to a moderator

Re: Test Server.... [message #264705 is a reply to message #264698]

Tue, 04 September 2007 04:53

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

As you have everything. So

set ORACLE_SID=your database name
then try startup

Report message to a moderator

Re: Test Server.... [message #264708 is a reply to message #264705]

Tue, 04 September 2007 04:56

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi dear,
I said harddisk failure.i have only oracle folder including data files,control files,redo logs, archived logs, init files, spfile, password files, Oracle binaries....

with regards

Report message to a moderator

Re: Test Server.... [message #264715 is a reply to message #264698]

Tue, 04 September 2007 05:17

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Your oracle services running or not???

Try, from command prompt,

set ORACLE_SID=<your oracle sid>

[Updated on: Tue, 04 September 2007 05:40]

Report message to a moderator

Re: Test Server.... [message #264717 is a reply to message #264715]

Tue, 04 September 2007 05:20

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi dear,
My test server harddisk got virus infected and i can not open also.But two days before i have copied oracle folder to another disk. right now i have oracle folder only. i am using oracle 10gr2 under windows 2003 server R2.In this case what is the way to get the database back.Give some valuable ideas,sir....

regards
sundar

Report message to a moderator

Re: Test Server.... [message #264719 is a reply to message #264698]

Tue, 04 September 2007 05:26

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Install oracle services in windows.Then start the services

(for example start OracleServiceORCL). Now copy the datafiles archivelog files controlfiles init files, spfiles in the place that it was in previous.

Then set environemntal variable ORACLE_SID

Now from SQL*PLUS use startup.

Report message to a moderator

Re: Test Server.... [message #264721 is a reply to message #264698]

Tue, 04 September 2007 05:57

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi dear,
thanks for your reply.Right now i don't have any test database.i have to install 10gr2 then i have to create database.
then i have to copy the database to there!! then i have to start the database. then it will work fine?????

shall i try this sir....

regards

sundar

Report message to a moderator

Re: Test Server.... [message #264736 is a reply to message #264702]

Tue, 04 September 2007 06:40

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Better reinstall Oracle (in the same place). Remove ORACLE key in registry (HKLM\Software). Make an export of it before (if you don't lose your registry).
Then use ORADIM to recreate the instance service.
Then just use SQL*Plus and startup.

Before make a copy of your Oracle directory.

Regards
Michel

Report message to a moderator

Re: Test Server.... [message #264894 is a reply to message #264736]

Tue, 04 September 2007 23:22

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi Michel,
Thanks for your reply.I have to reinstall oracle.But i don't've registry backup.Just i created same database name.i copied that files to new location.I am trying now.

once again thanks

regards
sundar

Report message to a moderator

Re: Test Server.... [message #264925 is a reply to message #264894]

Wed, 05 September 2007 01:05

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't create a new database this will be useless as you can't plug your files on this new one.
Just create the service as I said.

Regards
Michel

Report message to a moderator

Re: Test Server.... [message #264936 is a reply to message #264698]

Wed, 05 September 2007 01:25

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

Just i created same database name.

Name same so you can't plug in. It would have a worth if you create a database with different name. In that case you will have 2 databases(plug previous one+new one).

If you already have created with same name from drop it.

As Michel said, do..

Quote:

Don't create a new database this will be useless as you can't plug your files on this new one.

This is the thing that I wanted to say in my previous thread.

Report message to a moderator

Re: Test Server.... [message #264963 is a reply to message #264698]

Wed, 05 September 2007 02:20

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi Michel and Arju,
Thanks for your supporting....
Successfully i recovered my test database.
Once again Thank you very much.

with regards
sundar

Report message to a moderator

Previous Topic:	FRA size issue
Next Topic:	Problem with RMAN and TAPE on AIX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:23:54 CDT 2024