If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

10G R2 ORA-01194 - messed up system db - need help

hi!
Recently I was told to become an Oracle DBA. Because I am an MCP for the MS SQL Server I have a strong background , but unfortunately this is far away from being convertible to the Oracle world.

The last 2 days I spent to repair a damaged Oracle 10 instance. I had to recreate the control files, I had to rebuild the initInstancename.ora file, I have rebuilt the spfile.... after solving a dozen ORA messages I ended at this situation:

The instance doesn't come up and tells me
ORA-01194 file needs more recovery to become consistent.
ORA-01110 'f:\path\system01.dbf'

The only option left in the EM console was a database recovery, and I did it.
The recovery failed because there were no information to recover.... so it is messed up and we don't have any backups.

I have four dbf files with several tablespaces in int - Is there a way to copy this dbf file to a new installation and use them there?