Thomas,
There is indeed a media column, that can hold the tape name(s) on which the
backup piece is stored.
But I'm not sure that every rman media layer is capable of passing this
information to rman.
Following query can be used in 10gR2 to get an overview of the backups and the
media used.
It uses the session_ke and session_stamp from v$rman_backup_job_details to
group the different backup sets that belong to the same backup job together
set linesize 200
column bjob format a15
column recid format 99999
column start_time format a20
column handle format a55
column mb format 9G999G999D99
column media format a15
break on bjob skip 1 on recid on backup_type on start_time
compute sum of mb on bjob
with backup_set_details
as
( select set_count, set_stamp, session_recid, session_stamp
from v$backup_set_details
group by set_count, set_stamp, set_count, session_recid, session_stamp
)
select rbjd.session_key ||',' || rbjd.session_stamp bjob, bs.recid recid,
bs.backup_type,
to_char(bs.start_time, 'DD/MM/YYYY HH24:MI:SS') start_time,
bp.piece#, bp.bytes/1024/1024 mb, bp.compressed, bp.handle, bp.media
from v$backup_set bs, v$backup_piece bp, backup_set_details bsd,
v$rman_backup_job_details rbjd
where bs.set_stamp = bp.set_stamp
and bs.set_count = bp.set_count
and bs.set_stamp = bsd.set_stamp
and bs.set_count = bsd.set_count
and bsd.session_recid = rbjd.session_recid
and bsd.session_stamp = rbjd.session_stamp
and bp.status != 'D'
order by bs.start_time, bs.recid, bp.piece#;
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mercadante, Thomas F (LABOR)
Sent: dinsdag 10 februari 2009 21:02
To: oracle-l@xxxxxxxxxxxxx
Subject: Does the Rman Catalog hold tape volume names?
All,
I'm sure I saw this answer on the list before but just can't remember it.
Does the Rman catalog store the tape volume name that it is writing a backup to?
Oracle 10.2 and Tivoli Storage Manager.
I am trying to restore from a prior backup. The Rman catalog has the backup
cataloged. But the Rman run fails and says:
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
I was able to restore from 2 days sooner (1/29 worked; 1/27 does not). I'm
thinking that the tape may be offline or off site.
Does this make sense?
Thanks
Tom
--
http://www.freelists.org/webpage/oracle-l