ORA-15077 and ORA-15001

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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: