Urgent..Oracle Recover from Crashed OS

Arijit Chatterjee · *nix forums beginner Joined: 10 Jun 2005 Posts: 35

Dear Sir,
I have a query in oracle but I don't know how much foolish it is!!!
In my company who ever was the previous dba didn't take any backup
of the DB.Yesterday only the OS crashed.Even I don't know the oracle
Version ..think within 7i to 8i.Now the problem is if I reinstall
the os I will get back all my DB files but I need the help how should
Only information Os is Windows NT 4.0
I recover my DB.First of all is it possible?
If yes please help me out.
Regards
Arijit Chatterjee

Steve H · *nix forums beginner Joined: 14 Apr 2005 Posts: 13

If all the database files (i.e. control files, redo logs, datafiles)
are still there, then I think you should be ok.

When you start your database instance and open the database, the SMON
process will detect that there was a crash. Then, it will apply
everything available on the redo logs to re-synchronize the datafiles
and finally will rollback any uncommitted changes.

This will be automatic, you just need to start the database.

Your urgent priority will be to setup and test a backup/recovery
process once the database is online.

(Note: 'recovery' is the important part here, hence you will need to
test it)

Arijit Chatterjee · *nix forums beginner Joined: 10 Jun 2005 Posts: 35

Thanks Sir,
But When I reinstall my OS then I need to Reinstall the Oracle also.
Now how can I inform my new oracle server that previous DB is there?
Thanks once again
Regards
Arijit Chatterjee

Peter Mubaiter · *nix forums beginner Joined: 11 Feb 2005 Posts: 2

arijitchatterjee123@yahoo.co.in schrieb:

Arijit Chatterjee · *nix forums beginner Joined: 10 Jun 2005 Posts: 35

Thanks Sir,
So First I am trying to explain the steps
1.Reinstall OS
2.Reinstall Oracle
3.Through oradim create service.
4.Start that service
5.Startup Database.
That is all?? If I am missing anything please suggest me.
Thanks a lot
Regards
Arijit Chatterjee

StefanKapitza · *nix forums beginner Joined: 25 May 2005 Posts: 48

arijitchatterjee123@yahoo.co.in wrote:

Arijit Chatterjee · *nix forums beginner Joined: 10 Jun 2005 Posts: 35

Thanks Sir,
Backup means all the file/Folders in oracle folder???
Or Anything else???
Thanks once again for your kind help.
Regards
Arijit Chatterjee

pauljmcclure@gmail.com · *nix forums beginner Joined: 11 Feb 2005 Posts: 1

2b) find the SID of the database - you could search for the
tnsnames.ora file that was on the server when the db was up. lets
assume SID = sid1
2c) find the initsid1.ora file
3.Through oradim create service.
(ex. ORADIM -NEW -SID sid1 -INTPWD oracle -STARTMODE auto -PFILE
c:\path_to_init_file\initsid1.ora)
4.Start that service
5.Startup Database.
cmd prompt>sqlplus /nolog
conn sys/oracle@sid1 as sysdba
startup

good luck!

Frank van Bortel · *nix forums Guru Joined: 19 Apr 2005 Posts: 804

pauljmcclure@gmail.com wrote:

Google