Re: RMAN - handle

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Mon, 5 Mar 2007 20:25:51 -0800 (PST)
Message-ID: <540474.7977.qm@web31908.mail.mud.yahoo.com>

Hi,    

  Are you using a 9i client to backup a 10G database as mentioned in bug 5113533    

  Regards
  Fairlie

GovindanK <gkatteri_at_fastmail.fm> wrote:

    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 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta9.htm#RCMRF107 too (Scroll a bit below)   Thanks
  GovindanK

          Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego   

  http://el-caro.blogspot.com/
  M: +61 402 792 405       

---

Looking for earth-friendly autos?
 Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

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

Received on Mon Mar 05 2007 - 22:25:51 CST