10G R2 ORA-01194 - messed up system db - need help
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.
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?