Recreating control file fails after restore/recover
Hi!
I have recovered a database to a new location.
Im trying to recreate the controlfile, to reflect the new environment.
CREATE CONTROLFILE REUSE DATABASE "NEWDB" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/newdb/rdo2/NEWDB01a.rdo'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Of course the file dont exist! Any way around the problem? I tried create the file using touch, but Oracle did not like the header.
= I used resetlogs instead, worked like a charm
Regards
U
I have recovered a database to a new location.
Im trying to recreate the controlfile, to reflect the new environment.
CREATE CONTROLFILE REUSE DATABASE "NEWDB" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/newdb/rdo2/NEWDB01a.rdo'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Of course the file dont exist! Any way around the problem? I tried create the file using touch, but Oracle did not like the header.
= I used resetlogs instead, worked like a charm
Regards
U
0