Problem ORA-15077 and ORA-15001
================================
RMAN> restore controlfile from ‘/app/oracle/oradata/rac10g/control01.ctl’;
Starting restore at 02-SEP-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/02/2011 18:05:34
ORA-19504: failed to create file “+DATA”
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is control file (/app/oracle/oradata/rac10g/control01.ctl)
ORA-19601: output file is control file (+DATA)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Analysis
=========
1) check if CRS is running on the node
[oracle@guang ]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
2) check if ASM instance is running
sys@+asm> select status from v$instance;
STATUS
————
STARTED
ASM instance is always in “STARED” mode, that is different from normal instance in “OPEN” “MOUNT” and “STARTED” modes.
3) check diskgroup status
sys@+asm> select name, state from v$asm_diskgroup;
NAME STATE
—————————— ———–
DATA DISMOUNTED
FRA DISMOUNTED
Problem is here !!!
sys@+asm> show parameter asm_diskgroups;
NAME TYPE VALUE
———————————— ———– ——————————
asm_diskgroups string
Cause
======
The diskgroups are dismounted when trying to restore control file to them. Since the asm_diskgroups string is empty
so that diskgroups are not mounted automatically at instance startup.
Solution
=========
1) manually mount the diskgroups
alter diskgroup data mount;
alter diskgroup fra mount;
2) set asm_diskgroups string to “DATA, FRA” so that ASM instance will mount them automatically at next startp
alter system set asm_diskgroups=”DATA, FRA” sid=”*”;
shutdown immediate; — need to shutdown connected instance if any
startup
select name, state from v$asm_diskgroup;
Leave a comment