Recover database 9.2.0.1

Hello,

Friday, the 31st we needed to restore the last backup of our Oracle 9.2 database.
We backup all the days only the oradata/SID directory.

So, I shutdown immediatly the DB.
I rename the oradata/SID to oradata/SID_OLD I copy the oradata/SID (representing the backup).

I attempt to start the DB :
I had an ORA-01113 + ORA-01110 error on a UNDOxx.DBF file.

I read on newsgroups and I do :
Recover database using backup controlfile until Cancel;

But, now I have an ORA-01194 error on the SYSTEM01.DBF !

What can I do ?

I thank that I could only :
- Stop DB

• Rename the oradata/SID directory and create another oradata/SID (from backup)
• restart DB

PS : I don't have any ARC files, only the REDOLOGS01 to 03 on my oradata/SID directory.

Any ideas ?
Thanks ! Received on Mon Apr 03 2006 - 06:29:33 CDT