RMAN - recovering spfile and controlfile

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Tue, 5 May 2009 15:26:21 +1000
Message-ID: <977508E5-4B30-47C4-BAC8-7E275D6671ED_at_multiservice.com>

I'm sure this is something really stupid, but I can't see it.

I'm trying to recover the spfile and controlfile from an rman backup but having problems ...

Recovery Manager complete.
[oracle_at_opbld05 backup-scripts]$ rman target=/

Recovery Manager: Release 11.1.0.7.0 - Production on Mon May 4 23:07:29 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database (not started)

RMAN> _at_set-dbid.rman

RMAN> set DBID=1460247643
executing command: SET DBID

RMAN> **end-of-file**

RMAN> startup nomount pfile=/tmp/sb.ora

Oracle instance started

Total System Global Area 8150720512 bytes

Fixed Size                     2161152 bytes
Variable Size               4630513152 bytes
Database Buffers            3489660928 bytes
Redo Buffers                  28385280 bytes

RMAN> _at_restore-control.rman

RMAN> run {
2> set controlfile autobackup format for device type disk to '/var/ oracle/rman-backup/%F';

3> allocate channel c1 device type disk;
4> restore spfile to '+DATA/rac01d/spfilerac01d.ora' from autobackup;
5> restore controlfile from autobackup maxseq 200 maxdays 100;
6> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT using target database control file instead of recovery catalog

allocated channel: c1
channel c1: SID=16353 instance=rac01d1 device type=DISK

Starting restore at 04-MAY-09

recovery area destination: +FRA
database name (or database unique name) used for search: RAC01D

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20090504
channel c1: looking for AUTOBACKUP on day: 20090503
channel c1: AUTOBACKUP found: /var/oracle/rman-backup/ 

c-1460247643-20090503-00
channel c1: restoring spfile from AUTOBACKUP /var/oracle/rman-backup/ c-1460247643-20090503-00
channel c1: SPFILE restore from AUTOBACKUP complete Finished restore at 04-MAY-09

Starting restore at 04-MAY-09

recovery area destination: +FRA
database name (or database unique name) used for search: RAC01D

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20090504
channel c1: looking for AUTOBACKUP on day: 20090503
channel c1: AUTOBACKUP found: /var/oracle/rman-backup/ 

c-1460247643-20090503-00
channel c1: restoring control file from AUTOBACKUP /var/oracle/rman- backup/c-1460247643-20090503-00
channel c1: control file restore from AUTOBACKUP complete output file name=+DATA/rac01d/controlfile/current.267.686012913 output file name=+FRA/rac01d/controlfile/current.260.686012913 Finished restore at 04-MAY-09
released channel: c1

RMAN> **end-of-file**

RMAN> shutdown abort

Oracle instance shut down

RMAN> startup mount

connected to target database (not started) Oracle instance started

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of startup command at 05/04/2009 23:09:09 ORA-00205: error in identifying control file, check alert log for more info

Here's the error from the alert log ...

:

Starting up ORACLE RDBMS Version: 11.1.0.7.0. Using parameter settings in server-side pfile /var/oracle/product/11g/ db/dbs/initrac01d1.ora
System parameters with non-default values:

   processes                = 150
   sessions                 = 16384
   resource_limit           = TRUE
   spfile                   = "+DATA/rac01d/spfilerac01d.ora"
   nls_length_semantics     = "CHAR"
   nls_nchar_conv_excp      = "TRUE"
   memory_target            = 7808M
   memory_max_target        = 7808M
   control_files            = "+DATA/rac01d/controlfile/current. 
256.678734303"
   control_files            = "+FRA/rac01d/controlfile/current. 

256.678734303"
:

Mon May 04 23:09:08 2009
alter database mount
This instance was first to mount
NOTE:Loaded library: System
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup FRA was mounted

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+FRA/rac01d/controlfile/current.256.678734303'
ORA-17503: ksfdopn:2 Failed to open file +FRA/rac01d/controlfile/ 

current.256.678734303
ORA-15012: ASM file '+FRA/rac01d/controlfile/current.256.678734303' does not exist
ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATA/rac01d/controlfile/current. 256.678734303'
ORA-17503: ksfdopn:2 Failed to open file +DATA/rac01d/controlfile/ current.256.678734303
ORA-15012: ASM file '+DATA/rac01d/controlfile/current.256.678734303' does not exist
ORA-205 signalled during: alter database mount... SUCCESS: diskgroup DATA was dismounted
SUCCESS: diskgroup FRA was dismounted
:

So, if I get rman to restore the controlfile, why does it use a different name?

Thanks for your help,

Steve

This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.

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

Received on Tue May 05 2009 - 00:26:21 CDT