Re: RMAN restore - what am I doing wrong?
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Jon.Crisler@xxxxxxx, stbaldwin@xxxxxxxxxxxxxxxx, oracle_l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Aug 2009 10:39:43 -0700 (PDT)
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@xxxxxxx>
To: stbaldwin@xxxxxxxxxxxxxxxx; oracle_l <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@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> @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> @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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
