Oracle Database Cannot Open
I have Oracle Real Application Cluster (RAC) Database 10g installed on Windows 2003 Server
Database can be in mount state using RMAN
However, Alter database open; gives an error
RMAN-03002: failure of alter db command at 04/07/2010 10:06:53
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\SYSTEM01.DBF'
Then, tried restoring data from previous backup taken using RMAN.
RESTORE DATABASE;
The RMAN freezes, however after few hours the Alert log file shows that RMAN has restored all the 44 datafiles.
Then tried recovery of data using RMAN
RECOVER DATABASE; which too failed with the following error:
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed datafile 1
ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 289 doesn't match 0
ORA-00312: online log 2 thread 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\LOG02B.DBF'
ORA-00314: log 2 of thread 1, expected sequence# 289 doesn't match 0
ORA-00312: online log 2 thread 1: 'N:\ORACLE\DEV\DB\APPS_ST\DATA\LOG02A.DBF'
Could anyone please help me out with this Issue