Home » RDBMS Server » Backup & Recovery » Log file in ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG got deleted (Oracle 10g)
Log file in ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG got deleted [message #486580] Fri, 17 December 2010 00:03 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
By mistake the log fine O1_MF_1_647O6RPP_.LOG' at the path 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_647O6RPP_.LOG'
got deleted.

Now while mounting the database, I ma getting the below error:-

Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_647O6RPP_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Then I created a log file with that name and I get the error :-
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_647O6RPP_.LOG'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 38) Reached the end of the file.


Please suggest as how to solve this problem... I am stuck with no other options....


Regards,
Mahi
Re: Log file in ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG got deleted [message #486592 is a reply to message #486580] Fri, 17 December 2010 02:33 Go to previous message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi Mahi,

You can drop the recreated logfile and then execute following commands?

alter database clear logfile group <group no to which the dropped logfile belongs to>';

alter database open;


Regards,
OraKaran
Previous Topic: Recovery from SQL
Next Topic: MAXPIECESIZE configuration not working
Goto Forum:
  


Current Time: Thu Mar 28 10:08:56 CDT 2024