RMAN - recovering spfile and controlfile

From: Steve Baldwin <stbaldwin@xxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 5 May 2009 15:26:21 +1000

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 backupbut having problems ...


Recovery Manager complete.
[oracle@opbld05 backup-scripts]$ rman target=/

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


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

connected to target database (not started)

RMAN> @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> @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-00channel 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-00channel 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 moreinfo


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.678734303ORA-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.678734303ORA-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 adifferent 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.

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

RMAN - recovering spfile and controlfile

Other related posts: