Restoring SPFILE on RAC with RMAN - Not working

From: David Barbour <david.barbour1_at_gmail.com>
Date: Sun, 9 Nov 2014 13:30:01 -0600
Message-ID: <CAFH+ifezhru7+mtUb6gUBrPqSbKstVCs4mS776d8wUn2iUFmYQ_at_mail.gmail.com>

Undoubtedly something I've mis-typed, which caused the problem in the first place.

Oracle 11.2.0.3, RHEL 6.3

I messed up the spfile on a database. No problem, I have a backup. But ....

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+D23DATA01/D23/spfileD23.ora'
ORA-17503: ksfdopn:2 Failed to open file +D23DATA01/D23/spfileD23.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +D23DATA01/d23/spfiled23.ora
ORA-15173: entry 'spfiled23.ora' does not exist in directory 'd23'
ORA-06512: at line 4

starting Oracle instance without parameter file for retrieval of spfile Oracle instance started

Total System Global Area 367439872 bytes

Fixed Size                     2228464 bytes
Variable Size                205524752 bytes
Database Buffers             155189248 bytes
Redo Buffers                   4497408 bytes

RMAN> RESTORE SPFILE FROM AUTOBACKUP; Starting restore at 09-NOV-14 13:13:52

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/09/2014 13:13:52
RMAN-12001: could not open channel ORA_DISK_1

RMAN-10008: could not create channel context RMAN-10003: unable to connect to target database ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Here's the tnsnames.ora for the instance:

D23 =
(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = rchr1t-scan.lennoxintl.com)(PORT = 1525))

    (CONNECT_DATA = (SERVICE_NAME = D23)(GLOBAL_NAME = D23)(UR=A)

                    (FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC))

    )
  )

D23001 =
(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = rchr1t01-vip.lennoxintl.com)(PORT = 1521))

    (CONNECT_DATA = (SERVICE_NAME = D23001)(GLOBAL_NAME = D23)(SERVER = DEDICATED)(UR=A))
  )

When I nomount the DB, the listerner services show:

Service "D23" has 1 instance(s).
  Instance "D23", status UNKNOWN, has 1 handler(s) for this service...     Handler(s):

      "DEDICATED" established:0 refused:0
         LOCAL SERVER

Service "DUMMY" has 1 instance(s).
  Instance "D23001", status BLOCKED, has 1 handler(s) for this service...     Handler(s):

      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER

What the heck? I've even tried putting a SID_LIST_LISTENER stanza in the ASM listener.ora file(with lots of variations):

SID_LIST_LISTENER=
(SID_LIST=
 (SID_DESC=
(GLOBAL_DBNAME=D23)
(SID_NAME=D23)(UR=A)
(SERVICE_NAME=D23001)(UR=A)
(ORACLE_HOME=/oracle/D23/112)))

Any ideas?

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Nov 09 2014 - 20:30:01 CET