RMAN - handle

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Tue, 6 Mar 2007 03:06:28 UT
Message-Id: <1173150388.10216.1177909189@webmail.messagingengine.com>

Hello

I need some help on this:

All our RMAN scripts produce proper piece handles except one.

The script is

backup filesperset 20

        format 'al_%n_%s_%p_%t'
        (archivelog all delete input)

;
And the output comes as

channel t1: finished piece 1 at 05-MAR-2007-11:33:42 piece handle=al_N/Axxxxx_739_1_616419206 comment=API Version 2.0,MMS Version 4.1.0.0 channel t1: backup set complete, elapsed time: 00:00:16

SQL> select db_key,db_id,substr(handle,01,40),to_char(start_time,'dd-mon-yyyy hh24:mi') start_time 2 from rc_backup_piece where db_id=1494081670 3 and start_time > (select trunc(sysdate-3) from dual);

    DB_KEY      DB_ID SUBSTR(HANDLE,01,40)                     START_TIME
---------- ---------- ---------------------------------------- -----------------
   1651361 1494081670 al_N/Axxxxx_733_1_616180867              02-mar-2007 17:21
   1651361 1494081670 al_N/Axxxxx_734_1_616180867              02-mar-2007 17:21
   1651361 1494081670 al_N/Axxxxx_736_1_616246448              03-mar-2007 11:34
   1651361 1494081670 al_N/Axxxxx_735_1_616246448              03-mar-2007 11:34
   1651361 1494081670 al_N/Axxxxx_737_1_616332812              04-mar-2007 11:33
   1651361 1494081670 al_N/Axxxxx_738_1_616332812              04-mar-2007 11:33
   1651361 1494081670 al_N/Axxxxx_739_1_616419206              05-mar-2007 11:33
   1651361 1494081670 al_N/Axxxxx_740_1_616419206              05-mar-2007 11:33

10 rows selected.

SQL> This happens only in two of our databases. I am not sure what i am missing. Search in Metalink did not help much.

I referred to [1]http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta9.htm#RCMRF107 too (Scroll a bit below)

Thanks

GovindanK

References

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta9.htm#RCMRF107

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

Received on Mon Mar 05 2007 - 21:06:28 CST