RMAN restore - what am I doing wrong?

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Tue, 18 Aug 2009 20:07:36 +1000
Message-ID: <8D82B33A-107A-4C38-BE1F-466563C6A9EE_at_multiservice.com>



(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

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

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
Received on Tue Aug 18 2009 - 05:07:36 CDT

Original text of this message