Error re-creating controlfile
374956May 31 2006 — edited May 31 2006I am trying to recreate the control file from the text trace file I created.
When I run the script in the trace file I get errors, so I'm breaking it down into little steps.
After running this:
STARTUP NOMOUNT;
CREATE CONTROLFILE REUSE DATABASE "D3P" RESETLOGS ARCHIVELOG;
I get this error:
SQL> CREATE CONTROLFILE REUSE DATABASE "D3P" RESETLOGS ARCHIVELOG;
CREATE CONTROLFILE REUSE DATABASE "D3P" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
I have no ideas where this file is coming from:
?/dbs/dbs1@.dbf'
Any advice?