database recover

[honhwy]

Hi,everybody.
I am a chinese, sorry for my poor english.
I am a new guy in oracle,Now I have a problem need your help.
I have a oracle 7 install on window NT, but the NT crashed 3 days before, I have to reinstall the system, But How can I recover the oracle file, I never format the hard disk.All the file remained.
I have reinstalled oracle, I mean how to find the old datafile in a new oracle system?
Thanks.
you can email to me.
lyylhw@hotmail.com

[aarroyob]

Do you have anything in backup, export full, backup online/offline?

[anandharaj]

Hi honhwy

I need to know some more details, so that we can explore the possibilities...

1. Have you got Backup of your old Database ?

2. What installation method, you have selected... I mean Typical or Custom...?

If it is "Typical Installation" the datafile names will be some thing like:

SYS1ORCL.ORA, USR1ORCL.ORA,
TMP1ORCL.ORA and RBS1ORCL.ORA

If you have selected "Custom Installation", your filename will be something like

SYS1.ORA, USR1.ORA,
TMP1.ORA and RBS1.ORA

3. Have you installed into the same old ORACLE folder or New Folder ?

[honhwy]

actually, I haven't backup the database so far,
But I have all datafile and control file backup.
I just reinstall the oracle system.
I mean how can I join the oracle with the datafile?

[aarroyob]

1. Copy the files to the exact path they were.
2. Create the service with the oradim utility
3. If you have the init.ora, copy it in $ORACLE_HOME/database, if not create it
4. Try to open the database

I think it is all you need to do

Regards

Angel

[anandharaj]

Hi,

Since you have datafile and controlfile, Now you are safe...


Step 1:
Are you able to open your new Database..? If yes, then take a controlfile backup of your new db, using the following command....

ALTER DATABASED BACKUP CONTROLFILE TO TRACE

You will be having Filename.trc.

Open this file and change the filename with path of the old datafiles and save as file1.sql

Step2: Shutdown database

Step 3: SVRMGR
Connect internal
password: ("oracle is default password)


SVRMGR> startup nomount
SVRMGR> startup mount
SVRMGR> @file1.sql
- Run the just now created sql - file1.sql
- After statement is processed..
SVRMGR> ALTER DATABASE OPEN RESETLOGS

- statement processed.


Step4: Now your New database is ready with your old data.

Hope this will help you...