ORA-00344 unable to re-create
Example
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/09/2008 10:03:56
ORA-00344: unable to re-create online log 'D:ADMINDATAFILESREDOREDO03.LOG'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
In the example above we try to perform an "alter database open resetlogs" however we get an IO
error due the fact that the directory path "D:ADMINDATAFILESREDO" does not exist.
An additional side note is that in this example only the directory structure needs to be recreated ,
you do not need to have an actual redo log on file system , an "open resetlogs" will create a new
redo log as specified in the control file.
Details
ORA-00344: unable to re-create
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
ORA-00344 is an IO error , you may have tried to open a database with incorrect redo log locations
specified in the control file.
Solution
You can either recreate the directory structure as specified in the error.
Create a new control file with the desired directory structure for the redo logs.
2 comments:
try
alter database rename file 'FILE NAME WITH FULL PATH' TO
'FILE NAME WITH NEW PATH';
THEN
ALTER DATABASE OPEN RESETLOGS;
I never knew you could do that. I use to recreate the control file. Thanks for the tip rmnaveed.
Post a Comment