Home » RDBMS Server » Backup & Recovery » Test Server....
Test Server.... [message #264698] Tue, 04 September 2007 04:25 Go to next message
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
Re: Test Server.... [message #264700 is a reply to message #264698] Tue, 04 September 2007 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Test Server.... [message #264702 is a reply to message #264700] Tue, 04 September 2007 04:36 Go to previous messageGo to next message
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
Re: Test Server.... [message #264705 is a reply to message #264698] Tue, 04 September 2007 04:53 Go to previous messageGo to next message
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
Re: Test Server.... [message #264708 is a reply to message #264705] Tue, 04 September 2007 04:56 Go to previous messageGo to next message
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
Re: Test Server.... [message #264715 is a reply to message #264698] Tue, 04 September 2007 05:17 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Test Server.... [message #264719 is a reply to message #264698] Tue, 04 September 2007 05:26 Go to previous messageGo to next message
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.
Re: Test Server.... [message #264721 is a reply to message #264698] Tue, 04 September 2007 05:57 Go to previous messageGo to next message
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
Re: Test Server.... [message #264736 is a reply to message #264702] Tue, 04 September 2007 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Test Server.... [message #264894 is a reply to message #264736] Tue, 04 September 2007 23:22 Go to previous messageGo to next message
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
Re: Test Server.... [message #264925 is a reply to message #264894] Wed, 05 September 2007 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Test Server.... [message #264936 is a reply to message #264698] Wed, 05 September 2007 01:25 Go to previous messageGo to next message
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.
Re: Test Server.... [message #264963 is a reply to message #264698] Wed, 05 September 2007 02:20 Go to previous message
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
Previous Topic: FRA size issue
Next Topic: Problem with RMAN and TAPE on AIX
Goto Forum:
  


Current Time: Sat Dec 03 01:14:10 CST 2016

Total time taken to generate the page: 0.06569 seconds