| RAC ERROR [message #458002] |
Wed, 26 May 2010 11:47  |
dychandran
Messages: 1
Registered: January 2009
|
Junior Member |
|
|
Hi All,
we have been facing the small issue in our ASM environment like
The adaptor lost both paths to some of the disks where our ASM disk are resides.That brought down ASM instance.once that issue has been resolved.we are able to bring them up.From here on we have been continiously getting the belleow error :-
ORA-00308: cannot open archived log ''
ORA-00308: cannot open archived log '+ATDEV_DG_FLASH/ucitst/archivelog/2009_04_09/thread_1_seq_349.1328.683726417'
ORA-00600: internal error code, arguments: [2032], [12585276], [12585276], [8192], [2], [255], [0], [767], [], [], [], []
ORA-15012: ASM file '' does not exist
ORA-15012: ASM file '+ATDEV_DG_FLASH/ucitst/archivelog/2009_04_09/thread_1_seq_348.1325.683687617' does not exist
ORA-15012: ASM file '+ATDEV_DG_FLASH/ucitst/archivelog/2009_04_09/thread_1_seq_349.1328.683
ORA-17503: ksfdopn: Failed to open file
ORA-17503: ksfdopn:2 Failed to open file +ATDEV_DG_FLASH/ucitst/archivelog/2009_04_09/thread_1_seq_348.1325.683
ORA-17503: ksfdopn:2 Failed to open file +ATDEV_DG_FLASH/ucitst/archivelog/2009_04_09/thread_1_seq_349.1328.683726417
Check log file /u01/oracle/product/diag/rdbms/ucitst/ucitst1/trace/alert_ucitst1.log
could not locate the out right issue.can we have someone advise on this.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Real Application Clusters option
SQL>
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
SQL>
Thank you!.
|
|
|
|
|
|
| Re: RAC ERROR [message #458346 is a reply to message #458002] |
Fri, 28 May 2010 13:35  |
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
|
Senior Member |
|
|
Log into your ASM or Database instance.
Execute "select name,state,total_mb,free_mb from v$asm_diskgroup;"
If you have your ORACLE_HOME set to your ASM home, and have ORACLE_SID set to your ASM side (ex +ASM1 or +ASM) you can also try asmcmd. (I am pretty sure that is still included in 11g . . . . . ). You can check the FLASH area for the file to see if it actually exists - which I am betting it doesn't. If the files are missing and, you probably need to do a restore from your last backup. There are ways to force-open the database without completing the recovery - but I would doubt the state of your database would be anything useful. Good luck!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
