RMAN restore problem

From: Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
Date: Thu, 20 Nov 2008 19:42:03 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F815216958@sunmsx01.Corp.Acxiom.net>

Guys,  

Any pointers you could give would be really useful. Getting critical this one and as usual Oracle support are dragging their heels.  

There is plenty of space on restore area. Its not any filesize limit as some of them are 500Mb and no errors in the O/S logs.  

SETUP

---

Linux cluster using OCFS2 and Red Hat 5

Networkser Server 7.4.3
Networker Client 7.4.2-1
Networker Module for Oracle Client 4.5-1

OCFS2
Oracle Clusterware 10.2.0.4
Oracle RAC 10.2.0.4

### Release info of target DB, catalog DB, catalog schema & RMAN executable: ###
target 10.2.0.4
catalog 10.2.0.4
catalog schema 10.2.0.4
rman executable 10.2.0.4

### Specific details about the problem you encountered during RMAN session: ###
We have got a good backup using:

run
{
allocate channel c1 device type SBT_TAPE; allocate channel c2 device type SBT_TAPE; send
'ENV=(NSR_DATA_VOLUME_POOL=vmoracle,SBT_LIBRARY=/usr/lib/libobk.so)';
BACKUP INCREMENTAL LEVEL 0 DATABASE TAG=WEEKLY format
'b_%d_%u_%s_%p_%t.bs';

startup;
release channel c1;
release channel c2;
}

We can see the backup on the Networker server and all the indexes are updated.
However on recover we get the following errors:

Error message:

restoring datafile 00013 to /vm/data01/oradata/VMP1/VMP1_ind01_04.dbf
restoring datafile 00021 to /vm/data02/oradata/VMP1/VMP1_dat01_11.dbf
restoring datafile 00022 to /vm/data02/oradata/VMP1/VMP1_dat01_12.dbf

channel c1: reading from backup piece b_VMP1_33k03df3_99_1_671200739.bs ORA-19870: error reading backup piece b_VMP1_33k03df3_99_1_671200739.bs ORA-19502: write error on file
"/vm/data02/oradata/VMP1/VMP1_dat01_11.dbf", blockno 12977 (blocksize=16384)
ORA-27072: File I/O error
Linux Error: 5: Input/output error

Additional information: 4
Additional information: 12977
Additional information: -1

channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00009 to /vm/data01/oradata/VMP1/VMP1_ind01_02.dbf

restoring datafile 00018 to /vm/data02/oradata/VMP1/VMP1_dat01_08.dbf
restoring datafile 00020 to /vm/data02/oradata/VMP1/VMP1_dat01_10.dbf
channel c1: reading from backup piece b_VMP1_32k03df3_98_1_671200739.bs
ORA-19870: error reading backup piece b_VMP1_32k03df3_98_1_671200739.bs

ORA-19502: write error on file
"/vm/data02/oradata/VMP1/VMP1_dat01_08.dbf", blockno 4393 (blocksize=16384)
ORA-27072: File I/O error
Linux Error: 5: Input/output error

Additional information: 4
Additional information: 4393
Additional information: -1

channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00002 to /vm/data02/oradata/VMP1/VMP1_undotbs01.dbf channel c1: reading from backup piece b_VMP1_34k03dro_100_1_671201144.bs ORA-19870: error reading backup piece b_VMP1_34k03dro_100_1_671201144.bs ORA-19502: write error on file
"/vm/data02/oradata/VMP1/VMP1_undotbs01.dbf", blockno 2505 (blocksize=16384)
ORA-27072: File I/O error
Linux Error: 5: Input/output error

Additional information: 4
Additional information: 2505
Additional information: -1

channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00004 to /vm/data02/oradata/VMP1/VMP1_undotbs02.dbf channel c1: reading from backup piece b_VMP1_35k03e3d_101_1_671201389.bs

RMAN script:

run
{
shutdown;

startup mount;

allocate channel c1 device type SBT_TAPE; allocate channel c2 device type SBT_TAPE; send
'ENV=(NSR_DATA_VOLUME_POOL=vmoracle,SBT_LIBRARY=/usr/lib/libobk.so)';

restore database;

release channel c1;
release channel c2;
}

Thanks in advance guys. This would be a huge help if we could sort this out.  

Lee

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

---

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

Received on Thu Nov 20 2008 - 13:42:03 CST