Re: RMAN restore - what am I doing wrong?

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 18 Aug 2009 10:39:43 -0700 (PDT)
Message-ID: <119495.71877.qm_at_web38907.mail.mud.yahoo.com>

You would get a different error message if it could not find the backup set. If you use ASMCMD, can you cd to the filesystem +DATA/rac21d/datafile??

Robert G. Freeman
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf

Original Message ---- From: "Crisler, Jon" <Jon.Crisler_at_usi.com> To: stbaldwin_at_multiservice.com; oracle_l <oracle-l_at_freelists.org> Sent: Tuesday, August 18, 2009 10:27:58 AM Subject: RE: RMAN restore - what am I doing wrong?

Most likely your control file is not aware of the current location of your backups. The file path of the backuppieces needs to be the same as it existed on the source system, OR you can just restore the control file, then do a "catalog backuppiece" via rman.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Baldwin
Sent: Tuesday, August 18, 2009 6:08 AM
To: oracle_l
Subject: RMAN restore - what am I doing wrong?

(11.1)
I have taken a level 0 incremental backup from system A (a 2 node cluster) and I'm trying to restore it to system B.

Here's what I've done ...

Used dd to initialise iscsi targets used by ASM

dd if=/dev/zero of=/dev/iscsi/xxx bs=1G

Created ASM disk groups (identical to those from system A)

Here's my rman session. The pfile I am using to start instance B was generated from the spfile on system A ...

[oracle_at_lwdbc21 backup-scripts]$ rman target=/

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Aug 18 03:18:30 2009

connected to target database (not started)

RMAN> _at_set-dbid.rman

RMAN> set DBID=3325391588
executing command: SET DBID

RMAN> **end-of-file**

RMAN> startup pfile=/var/oracle/autobackup/rac21d1-pfile.ora nomount

Oracle instance started

Total System Global Area 8150720512 bytes

Fixed Size                     2161152 bytes
Variable Size               6241125888 bytes
Database Buffers            1879048192 bytes
Redo Buffers                  28385280 bytes

RMAN> _at_restore-control.rman

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

3> allocate channel c1 device type disk;
4> restore spfile from autobackup maxseq 200 maxdays 100;
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=16354 instance=rac21d1 device type=DISK

Starting restore at 18-AUG-09

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

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20090818
channel c1: looking for AUTOBACKUP on day: 20090817
channel c1: AUTOBACKUP found: /var/oracle/autobackup/

c-3325391588-20090817-00
channel c1: restoring spfile from AUTOBACKUP /var/oracle/autobackup/ c-3325391588-20090817-00
channel c1: SPFILE restore from AUTOBACKUP complete Finished restore at 18-AUG-09

Starting restore at 18-AUG-09

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

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20090818
channel c1: looking for AUTOBACKUP on day: 20090817
channel c1: AUTOBACKUP found: /var/oracle/autobackup/

c-3325391588-20090817-00
channel c1: restoring control file from AUTOBACKUP /var/oracle/ autobackup/c-3325391588-20090817-00
channel c1: control file restore from AUTOBACKUP complete output file name=+DATA/rac21d/controlfile/current.256.695186369 output file name=+FRA/rac21d/controlfile/current.256.695186371 Finished restore at 18-AUG-09
released channel: c1

RMAN> **end-of-file**

RMAN> mount database
2> ;

database mounted

RMAN> restore database;

Starting restore at 18-AUG-09
Starting implicit crosscheck backup at 18-AUG-09 allocated channel: ORA_DISK_1
Crosschecked 78 objects
Finished implicit crosscheck backup at 18-AUG-09

Starting implicit crosscheck copy at 18-AUG-09 using channel ORA_DISK_1
Crosschecked 4 objects
Finished implicit crosscheck copy at 18-AUG-09

searching for all files in the recovery area cataloging files...
no files cataloged

using channel ORA_DISK_1

creating datafile file number=1 name=+DATA/rac21d/datafile/system. 259.682280555

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

RMAN-03002: failure of restore command at 08/18/2009 03:20:17 ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA/rac21d/datafile/system.259.682280555'

There's no errors in the alert log for either the DB or the ASM instance.

There is *plenty* of free space (as you would expect) ...

SQL> select name, total_mb, free_mb, usable_file_mb from v $asm_diskgroup;

NAME                             TOTAL_MB    FREE_MB USABLE_FILE_MB
------------------------------ ---------- ---------- --------------
DATA                               102405     102306         102306
FRA                                204810     204710         204710

Here's the equivalent query from system A ...

SQL> r

1* select name, total_mb, free_mb, usable_file_mb from v $asm_diskgroup

NAME TOTAL_MB FREE_MB USABLE_FILE_MB ---------- ---------- ---------- --------------

DATA           102405      84069          84069
FRA            204810     200262         200262

I'm hoping it's something silly and obvious.

Any suggestions would be most appreciated.

Thanks,

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


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

Received on Tue Aug 18 2009 - 12:39:43 CDT

This message: [ Message body ]
Next message: sundar mahadevan: "Re: upgrade RAC from 9.2.0.8 to 10.1.0.4"
Previous message: Scott Sibert: "Re: upgrade RAC from 9.2.0.8 to 10.1.0.4"
In reply to: Crisler, Jon: "RE: RMAN restore - what am I doing wrong?"
Next in thread: Steve Baldwin: "Re: RMAN restore - what am I doing wrong?"
Reply: Steve Baldwin: "Re: RMAN restore - what am I doing wrong?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message