FAQ
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.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 5, '09 at 5:26a
activeMay 5, '09 at 5:26a
posts1
users1
websiteoracle.com

1 user in discussion

Steve Baldwin: 1 post

People

Translate

site design / logo © 2022 Grokbase