Home » Server Options » RAC & Failsafe » RAC ERROR (Errors are related to ASM and DB)
RAC ERROR [message #458002] Wed, 26 May 2010 11:47 Go to next message
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 #458009 is a reply to message #458002] Wed, 26 May 2010 12:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check the status of the disks in ASM. Are they mounted?
The output of lsdg should help.
Also please check if FRA is been purged.
Re: RAC ERROR [message #458346 is a reply to message #458002] Fri, 28 May 2010 13:35 Go to previous message
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!
Previous Topic: RAC
Next Topic: Diff b/w RAC & ASM
Goto Forum:
  


Current Time: Thu Mar 28 11:05:40 CDT 2024