Showing posts with label ORA-1157 1110 17503 150001 in asm. Show all posts
Showing posts with label ORA-1157 1110 17503 150001 in asm. Show all posts

Tuesday, July 12, 2011

How to resolve below errors in ASM???

Tue Jul 12 14:52:57 2011
Errors in file /oracle/admin/ADMOSD/bdump/ADMOSD1_dbw0_786540.trc:
ORA-01157: cannot identify/lock data file 150 - see DBWR trace file
ORA-01110: data file 150: '+ADM_OSD_DATA_03_NEW/ADMOSD/datafile/t_large_data_2.256.741582251'
ORA-17503: ksfdopn:2 Failed to open file +ADM_OSD_DATA_03_NEW/ADMOSD/datafile/t_large_data_2.256.741582251
ORA-15001: diskgroup "ADM_OSD_DATA_03_NEW" does not exist or is not mounted
ORA-15001: diskgroup "ADM_OSD_DATA_03_NEW" does not exist or is not mounted

Check status of disk and disk group:-

select name, state, type, offline_disks from v$asm_diskgroup;

select name, mount_status, mode_status, header_status, read_errs, write_errs from v$asm_disk;

Manually Mount diskgroup in ASM :-

alter diskgroup ADM_OSD_DATA_03_NEW mount

If you are getting errors :-

alter diskgroup AMD_OSD_DATA_03_NEW check all repair