Re: RMAN Tape Media Volume Identification

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Thu, 03 May 2007 13:12:13 -0700
Message-Id: <1178223133.460.1187980367@webmail.messagingengine.com>

Jim

I am not sure if i understood your requirement. You would need to look at the piece and handle columns.

set linesize 132;
set pagesize 045;
SELECT * FROM
(
SELECT
REPLACE(

         TRANSLATE(handle,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'
                         ,'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
                  )
         ,'_',NULL
       ) db


      ,handle

      ,media

      ,TO_CHAR(start_time,'DD-MON-YY HH24:MI:SS') started

      ,TO_CHAR(completion_time,'DD-MON-YY HH24:MI:SS') completed

FROM rc_backup_piece
WHERE handle like UPPER('%&&SID_DBNAME%') AND db_id=(SELECT db_id FROM rc_database WHERE name=UPPER('&&SID_DBNAME'))
AND handle like 'df%' --al%, cf% for the other ORDER BY TO_CHAR(start_time,'YYYYMMDD:HH24:MI:SS') DESC )
WHERE rownum < 60
/

HTH
GovindanK

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

Received on Thu May 03 2007 - 15:12:13 CDT