| Cannot open ORacle database [message #451032] |
Mon, 12 April 2010 03:40  |
tutawala
Messages: 5
Registered: April 2010
Location: Kuwait
|
Junior Member |
|
|
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
|
|
|
|
| Re: Cannot open ORacle database [message #451081 is a reply to message #451032] |
Mon, 12 April 2010 06:09  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
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'
01113, 00000, "file %s needs media recovery"
// *Cause: An attempt was made to online or open a database with a file that
// is in need of media recovery.
// *Action: First apply media recovery to the file.
Try to recover database using UTIL TIME
-Babu
[Updated on: Mon, 12 April 2010 06:10] Report message to a moderator |
|
|
|
| Re: Cannot open ORacle database [message #451222 is a reply to message #451081] |
Tue, 13 April 2010 04:33 |
tutawala
Messages: 5
Registered: April 2010
Location: Kuwait
|
Junior Member |
|
|
Hi Babu,
Thanks for replying.
I have tried recover database until cancel. It gave me an error saying, try with recover database using backup controlfile until cancel.
So, I tried with the following command
SQL> CONN / AS SYSDBA
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL ;
I was first asked about the following archive log file. So, i gave its location as:
N:\oracle\DEV\db\apps_st\data\Archives\DEVDFA6E9F5_00289_0673919223.001
Then, in a few minutes i was asked about the following archive log file:
N:\oracle\DEV\db\apps_st\data\Archives\DEVDFA6E9F5_00105_0673919223.002
After entering this file location, SQLPLUS got hanged. I waited for an hour but no response.
This happened with RMAN also earlier. The RMAN gets hanged while restore and recovery.
Why does the SQLPLUS or RMAN hang.
I am thinking of restoring the database with image copy (cold backup) that i had taken before this problem raised.
What could be the steps that i can follow to restore the cold backup keeping in mind that i have Oracle RAC 10 g with 2 instances on Windows 2003 server and running with Oracle Apps R12?
Detailed steps would be appreciated.
As it is test system, I dont care if i loose data, i just need to open the database so that i can carry on with testing.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
