Veritas-bu

[Veritas-bu] Oracle backup script problem

2008-06-25 03:36:54
Subject: [Veritas-bu] Oracle backup script problem
From: "Yusuf Gedikoglu" <Yusuf.Gedikoglu AT avea.com DOT tr>
To: <VERITAS-BU AT mailman.eng.auburn DOT edu>
Date: Wed, 25 Jun 2008 10:03:20 +0300
 Hi All

I have a problem about Oracle backup.

Thwe backup job starts and failed in few minutes. The rman script file
gives following error messages. There is no log created under the
netbackup/logs directory for search any error.


We tested rman to backup a tablespace to disk. It is succesfull so we
are sre that we do not have any problem  sabout oracle and RMAN.

I am waiting your ideas about the problem and solution.  Because
symantec support can not determine the problem and they said it is rman
problem :)

Best regards.


connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>
20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37>
38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 
allocated channel: ch00
channel ch00: sid=127 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

allocated channel: ch01
channel ch01: sid=154 devtype=SBT_TAPE
channel ch01: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

allocated channel: ch02
channel ch02: sid=134 devtype=SBT_TAPE
channel ch02: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

allocated channel: ch03
channel ch03: sid=128 devtype=SBT_TAPE
channel ch03: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

Starting backup at 20-JUN-08
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00035
name=/oracle/oradata/SDPREP/sdprep_cdr_archive01.dbf
input datafile fno=00051
name=/oracle/oradata/SDPREP/sdprep_cdr_archive17.dbf
input datafile fno=00032 name=/oracle/oradata/SDPREP/sdp_prod_23.dbf
input datafile fno=00010 name=/oracle/oradata/SDPREP/sdp_prod_3.dbf
input datafile fno=00019 name=/oracle/oradata/SDPREP/sdp_prod_12.dbf
channel ch00: starting piece 1 at 20-JUN-08
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00048
name=/oracle/oradata/SDPREP/sdprep_cdr_archive14.dbf
input datafile fno=00026 name=/oracle/oradata/SDPREP/sdp_prod_17.dbf
input datafile fno=00029 name=/oracle/oradata/SDPREP/sdp_prod_20.dbf
input datafile fno=00007 name=/oracle/oradata/SDPREP/undotbs3_1g.dbf
input datafile fno=00016 name=/oracle/oradata/SDPREP/sdp_prod_9.dbf
channel ch01: starting piece 1 at 20-JUN-08
channel ch02: starting incremental level 0 datafile backupset
channel ch02: specifying datafile(s) in backupset
input datafile fno=00049
name=/oracle/oradata/SDPREP/sdprep_cdr_archive15.dbf
input datafile fno=00027 name=/oracle/oradata/SDPREP/sdp_prod_18.dbf
input datafile fno=00030 name=/oracle/oradata/SDPREP/sdp_prod_21.dbf
input datafile fno=00008 name=/oracle/oradata/SDPREP/system_1g_2.dbf
input datafile fno=00017 name=/oracle/oradata/SDPREP/sdp_prod_10.dbf
channel ch02: starting piece 1 at 20-JUN-08
channel ch03: starting incremental level 0 datafile backupset
channel ch03: specifying datafile(s) in backupset
input datafile fno=00050
name=/oracle/oradata/SDPREP/sdprep_cdr_archive16.dbf
input datafile fno=00028 name=/oracle/oradata/SDPREP/sdp_prod_19.dbf
input datafile fno=00031 name=/oracle/oradata/SDPREP/sdp_prod_22.dbf
input datafile fno=00009 name=/oracle/oradata/SDPREP/sdp_prod_2.dbf
input datafile fno=00018 name=/oracle/oradata/SDPREP/sdp_prod_11.dbf
channel ch03: starting piece 1 at 20-JUN-08
RMAN-03009: failure of backup command on ch00 channel at 06/20/2008
13:02:28
ORA-19506: failed to create sequential file,
name="bk_15350_1_657896547", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  Communication with the server has not been iniatated
or the server status has not been retrieved from the server.
channel ch00 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch01 channel at 06/20/2008
13:02:29
ORA-19506: failed to create sequential file,
name="bk_15351_1_657896548", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  Communication with the server has not been iniatated
or the server status has not been retrieved from the server.
channel ch01 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch02 channel at 06/20/2008
13:02:29
ORA-19506: failed to create sequential file,
name="bk_15352_1_657896548", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  Communication with the server has not been iniatated
or the server status has not been retrieved from the server.
channel ch02 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch03 channel at 06/20/2008
13:02:29
ORA-19506: failed to create sequential file,
name="bk_15353_1_657896548", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  Communication with the server has not been iniatated
or the server status has not been retrieved from the server.
channel ch03 disabled, job failed on it will be run on another channel
DBGANY: CMD type=backup id=1 status=NOT STARTED
DBGANY:     1 STEP id=1 status=NOT STARTED
DBGANY:           1 TEXTNOD = -- budf_start
DBGANY:           2 TEXTNOD = /* This must be retriable, which means a
backup conversation may already
DBGANY:           3 TEXTNOD =  * be in progress when this step
(re)executes.
DBGANY:           4 TEXTNOD =  */
DBGANY:           5 TEXTNOD = declare
DBGANY:           6 TEXTNOD =   /* backup conversation status variables
*/
DBGANY:           7 TEXTNOD =   state       binary_integer;
DBGANY:           8 TEXTNOD =   setid       number;
DBGANY:           9 TEXTNOD =   stamp       number;
DBGANY:          10 TEXTNOD =   pieceno     binary_integer;
DBGANY:          11 TEXTNOD =   files       binary_integer;
DBGANY:          12 TEXTNOD =   datafiles   boolean;
DBGANY:          13 TEXTNOD =   incremental boolean;
DBGANY:          14 TEXTNOD =   nochecksum  boolean;
DBGANY:          15 TEXTNOD =   device      boolean;
DBGANY:          16 TEXTNOD =   /* piece creation variables */
DBGANY:          17 TEXTNOD =   done        boolean;
DBGANY:          18 TEXTNOD =   concur      boolean;
DBGANY:          19 TEXTNOD =   /* Miscellaneous */
DBGANY:          20 TEXTNOD =   memnum      number;
DBGANY:          21 TEXTNOD =   dfnumber    number;
DBGANY:          22 TEXTNOD =   cfname      varchar2(512);
DBGANY:          23 TEXTNOD =   copy_recid  number;
DBGANY:          24 TEXTNOD =   copy_stamp  number;
DBGANY:          25 TEXTNOD =   busy_retries number := 0;
DBGANY:          26 TEXTNOD =   resetlogs_change  number;
DBGANY:          27 TEXTNOD =   creation_change   number;
DBGANY:          28 TEXTNOD =   checkpoint_change number;
DBGANY:          29 TEXTNOD =   blksize           number;
DBGANY:          30 TEXTNOD =   blocks            number;
DBGANY:          31 TEXTNOD =   fname             varchar2(1024);
DBGANY:          32 TEXTNOD =   no_delete         binary_integer;
DBGANY:          33 TEXTNOD =   copy         number;
DBGANY:          34 TEXTNOD =   nformat      number := 1;
DBGANY:          35 TEXTNOD =   handle       varchar2(512);
DBGANY:          36 TEXTNOD =   comment      varchar2(80);
DBGANY:          37 TEXTNOD =   media        varchar2(64);
DBGANY:          38 TEXTNOD =   wrong_format      exception;
DBGANY:          39 TEXTNOD =   pragma exception_init(wrong_format,
-20039);
DBGANY:          40 TEXTNOD =   first_time        boolean := TRUE;
DBGANY:          41 TEXTNOD =   backup_level      number;
DBGANY:          42 TEXTNOD =   elapsed           number;
DBGANY:          43 TEXTNOD =   stampd            date;
DBGANY:          44 TEXTNOD =   hours             number;
DBGANY:          45 TEXTNOD =   mins              number;
DBGANY:          46 TEXTNOD =   secs              number;
DBGANY:          47 TEXTNOD =   ncopies           number := 0;
DBGANY:          48 TEXTNOD =   docompress        boolean := FALSE;
DBGANY:          49 TEXTNOD = -- backup_type is used to indicate what
type of backup is done. This is used
DBGANY:          50 TEXTNOD = -- to get configured copies, look at
krmkgbac for more comments.
DBGANY:          51 TEXTNOD =   backup_type       number := 2;
DBGANY:          52 TEXTNOD =   isstby            boolean;
DBGANY:          53 TEXTNOD =   larchlog_failover boolean;
DBGANY:          54 TEXTNOD =   failoverdone      boolean := FALSE;
DBGANY:          55 TEXTNOD =   docopies          boolean := FALSE;
DBGANY:          56 TEXTNOD =   cnvrtto           boolean := FALSE;
DBGANY:          57 TEXTNOD =   cnvrtfr           boolean := FALSE;
DBGANY:          58 TEXTNOD =   sameen            boolean := FALSE;
DBGANY:          59 TEXTNOD =   reusefile         boolean := FALSE;
DBGANY:          60 TEXTNOD =   tsname            varchar2(30) := NULL;
DBGANY:          61 TEXTNOD =   thread            number := NULL;
DBGANY:          62 TEXTNOD =   sequence          number := NULL;
DBGANY:          63 TEXTNOD =   m                 number := 8581;
DBGANY:          64 TEXTNOD =   cprecid           number;
DBGANY:          65 TEXTNOD =   cpstamp           number;
DBGANY:          66 TEXTNOD =   rsid              number;
DBGANY:          67 TEXTNOD =   rsts              number;
DBGANY:          68 TEXTNOD =   cptag             varchar2(31) := NULL;
DBGANY:          69 TEXTNOD =   noct              boolean := FALSE;
DBGANY:          70 TEXTNOD =   noct_ret          varchar2(1);
DBGANY:          71 TEXTNOD =   pltfrmto          number := NULL;
DBGANY:          72 TEXTNOD =   pltfrmfr          number := NULL;
DBGANY:          73 TEXTNOD =   foreign_dbname    varchar2(8) := NULL;
DBGANY:          74 TEXTNOD =   foreign_dbid      number := NULL;
DBGANY:          75 TEXTNOD =   doconvert         boolean := FALSE;
DBGANY:          76 TEXTNOD = begin
DBGANY:          77 TEXTNOD =   
DBGANY:          78 PRMVAL =  backup_level := 0;
DBGANY:          79 TEXTNOD =   -- set docopies and convert (if any)
DBGANY:          80 TEXTNOD =   
DBGANY:          81 PRMVAL =  docopies := false;
DBGANY:          82 TEXTNOD =   -- set rsid
DBGANY:          83 TEXTNOD =   
DBGANY:          84 PRMVAL =  rsid := 3378;
DBGANY:          85 TEXTNOD =   -- set rsts
DBGANY:          86 TEXTNOD =   
DBGANY:          87 PRMVAL =  rsts := 657896544;
DBGANY:          88 TEXTNOD =   -- set reusefile
DBGANY:          89 TEXTNOD =   
DBGANY:          90 PRMVAL =  reusefile := false;
DBGANY:          91 TEXTNOD =   -- set docompress := FALSE/TRUE
DBGANY:          92 TEXTNOD =   
DBGANY:          93 PRMVAL =  docompress := false;
DBGANY:          94 TEXTNOD =   if pltfrmto is not null or pltfrmfr is
not null then
DBGANY:          95 TEXTNOD =      doconvert := true;
DBGANY:          96 TEXTNOD =   end if;
DBGANY:          97 TEXTNOD =   -- If returned FALSE, abort the backup
job
DBGANY:          98 TEXTNOD =   if (NOT beginBackupJobStep()) then
DBGANY:          99 TEXTNOD =     return;
DBGANY:         100 TEXTNOD =   end if;
DBGANY:         101 TEXTNOD =   
DBGANY:         102 TEXTNOD =
sys.dbms_backup_restore.backupStatus(state, setid, stamp, pieceno,
files,
DBGANY:         103 TEXTNOD =
datafiles, incremental, nochecksum,
DBGANY:         104 TEXTNOD =
device);
DBGANY:         105 TEXTNOD =   if state =
sys.dbms_backup_restore.BACKUP_NO_CONVERSATION then
DBGANY:         106 TEXTNOD =     goto start_convo;
DBGANY:         107 TEXTNOD =   elsif state =
sys.dbms_backup_restore.BACKUP_NAMING_FILES then
DBGANY:         108 TEXTNOD =     goto name_files;
DBGANY:         109 TEXTNOD =   else
DBGANY:         110 TEXTNOD =     goto create_piece;
DBGANY:         111 TEXTNOD =   end if;
DBGANY:         112 TEXTNOD = <<start_convo>>
DBGANY:         113 TEXTNOD =
sys.dbms_backup_restore.setRmanStatusRowId(rsid=>rsid, rsts=>rsts);
DBGANY:         114 TEXTNOD =
sys.dbms_backup_restore.backupSetDatafile(stamp, setid,
DBGANY:         115 TEXTNOD =

DBGANY:         116 PRMVAL =
incremental=>true,backup_level=>0,nochecksum=>false
DBGANY:         117 TEXTNOD = ,
DBGANY:         118 TEXTNOD =

DBGANY:         119 PRMVAL = tag=>'HOT_DB_BK_LEVEL0'
DBGANY:         120 TEXTNOD = ,
DBGANY:         121 TEXTNOD =
imagcp    => docopies,
DBGANY:         122 TEXTNOD =
convertto => cnvrtto,
DBGANY:         123 TEXTNOD =
convertfr => cnvrtfr,
DBGANY:         124 TEXTNOD =
pltfrmto  => pltfrmto,
DBGANY:         125 TEXTNOD =
pltfrmfr  => pltfrmfr,
DBGANY:         126 TEXTNOD =
sameen    => sameen);
DBGANY:         127 TEXTNOD =   if (noct) then
DBGANY:         128 TEXTNOD =     noct_ret :=
DBGANY:         129 TEXTNOD =
sys.dbms_backup_restore.getParm(sys.dbms_backup_restore.incr_noct);
DBGANY:         130 TEXTNOD =     end if;
DBGANY:         131 TEXTNOD =   -- Display appropriate message
DBGANY:         132 TEXTNOD =   if docopies then
DBGANY:         133 TEXTNOD =      if doconvert then
DBGANY:         134 TEXTNOD =         krmicd.writeMsg(8589,
krmicd.getChid);
DBGANY:         135 TEXTNOD =      else
DBGANY:         136 TEXTNOD =         krmicd.writeMsg(8580,
krmicd.getChid);
DBGANY:         137 TEXTNOD =      end if;
DBGANY:         138 TEXTNOD =   else
DBGANY:         139 TEXTNOD =      if backup_level is not null then
DBGANY:         140 TEXTNOD =         if (docompress) then
DBGANY:         141 TEXTNOD =            krmicd.writeMsg(8047,
krmicd.getChid, to_char(backup_level));
DBGANY:         142 TEXTNOD =         else
DBGANY:         143 TEXTNOD =            krmicd.writeMsg(8048,
krmicd.getChid, to_char(backup_level));
DBGANY:         144 TEXTNOD =         end if;  
DBGANY:         145 TEXTNOD =      else
DBGANY:         146 TEXTNOD =         if (docompress) then
DBGANY:         147 TEXTNOD =            krmicd.writeMsg(8046,
krmicd.getChid); 
DBGANY:         148 TEXTNOD =         else
DBGANY:         149 TEXTNOD =            krmicd.writeMsg(8008,
krmicd.getChid);
DBGANY:         150 TEXTNOD =         end if;
DBGANY:         151 TEXTNOD =      end if;
DBGANY:         152 TEXTNOD =   end if;
DBGANY:         153 TEXTNOD = <<name_files>>
DBGANY:         154 TEXTNOD =   deb('budf_start', 'set_stamp=' || stamp
|| ' set_count=' || setid,
DBGANY:         155 TEXTNOD =       rman_constant.DEBUG_IO, 1);
DBGANY:         156 TEXTNOD = -- budf_name
DBGANY:         157 TEXTNOD =   
DBGANY:         158 PRMVAL =  memnum := 1;
DBGANY:         159 TEXTNOD =   
DBGANY:         160 PRMVAL =  dfnumber := 46; tsname :=
'SDPREP_CDR_ARCHIVE'; fname :=
'/oracle/oradata/SDPREP/sdprep_cdr_archive12.dbf'; blocks := 1280000;
blksize := 8192;
DBGANY:         161 TEXTNOD =   if (first_time) then
DBGANY:         162 TEXTNOD =      if not docopies then
DBGANY:         163 TEXTNOD =         krmicd.writeMsg(8010,
krmicd.getChid);
DBGANY:         164 TEXTNOD =      end if;
DBGANY:         165 TEXTNOD =      first_time := FALSE;
DBGANY:         166 TEXTNOD =   end if;
DBGANY:         167 TEXTNOD =   if files < memnum then
DBGANY:         168 TEXTNOD =     begin
DBGANY:         169 TEXTNOD =
sys.dbms_backup_restore.backupDataFile(dfnumber => dfnumber, 
DBGANY:         170 PRMVAL = max_corrupt=>0,since_change=>0
DBGANY:         171 TEXTNOD = );
DBGANY:         172 TEXTNOD =        krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         173 TEXTNOD =        deb('budf_name', 'blocks=' ||
blocks || ' block_size=' || blksize,
DBGANY:         174 TEXTNOD =            rman_constant.DEBUG_IO, 1);
DBGANY:         175 TEXTNOD =     exception
DBGANY:         176 TEXTNOD =        when
sys.dbms_backup_restore.inc_scn_matches_df_scn then
DBGANY:         177 TEXTNOD =           krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         178 TEXTNOD =           krmicd.writeMsg(8056,
to_char(dfnumber, 'FM09999'));
DBGANY:         179 TEXTNOD =           krmicd.clearErrors;
DBGANY:         180 TEXTNOD =     end;
DBGANY:         181 TEXTNOD =     files := files + 1;
DBGANY:         182 TEXTNOD =   end if;
DBGANY:         183 TEXTNOD = -- budf_name
DBGANY:         184 TEXTNOD =   
DBGANY:         185 PRMVAL =  memnum := 2;
DBGANY:         186 TEXTNOD =   
DBGANY:         187 PRMVAL =  dfnumber := 62; tsname :=
'SDPREP_CDR_ARCHIVE'; fname :=
'/oracle/oradata/SDPREP/sdprep_cdr_archive28.dbf'; blocks := 1280000;
blksize := 8192;
DBGANY:         188 TEXTNOD =   if (first_time) then
DBGANY:         189 TEXTNOD =      if not docopies then
DBGANY:         190 TEXTNOD =         krmicd.writeMsg(8010,
krmicd.getChid);
DBGANY:         191 TEXTNOD =      end if;
DBGANY:         192 TEXTNOD =      first_time := FALSE;
DBGANY:         193 TEXTNOD =   end if;
DBGANY:         194 TEXTNOD =   if files < memnum then
DBGANY:         195 TEXTNOD =     begin
DBGANY:         196 TEXTNOD =
sys.dbms_backup_restore.backupDataFile(dfnumber => dfnumber, 
DBGANY:         197 PRMVAL = max_corrupt=>0,since_change=>0
DBGANY:         198 TEXTNOD = );
DBGANY:         199 TEXTNOD =        krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         200 TEXTNOD =        deb('budf_name', 'blocks=' ||
blocks || ' block_size=' || blksize,
DBGANY:         201 TEXTNOD =            rman_constant.DEBUG_IO, 1);
DBGANY:         202 TEXTNOD =     exception
DBGANY:         203 TEXTNOD =        when
sys.dbms_backup_restore.inc_scn_matches_df_scn then
DBGANY:         204 TEXTNOD =           krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         205 TEXTNOD =           krmicd.writeMsg(8056,
to_char(dfnumber, 'FM09999'));
DBGANY:         206 TEXTNOD =           krmicd.clearErrors;
DBGANY:         207 TEXTNOD =     end;
DBGANY:         208 TEXTNOD =     files := files + 1;
DBGANY:         209 TEXTNOD =   end if;
DBGANY:         210 TEXTNOD = -- budf_name
DBGANY:         211 TEXTNOD =   
DBGANY:         212 PRMVAL =  memnum := 3;
DBGANY:         213 TEXTNOD =   
DBGANY:         214 PRMVAL =  dfnumber := 71; tsname := 'SDP_PROD_CDR';
fname := '/oracle/oradata/SDPREP/sdp_prod_30.dbf'; blocks := 640000;
blksize := 8192;
DBGANY:         215 TEXTNOD =   if (first_time) then
DBGANY:         216 TEXTNOD =      if not docopies then
DBGANY:         217 TEXTNOD =         krmicd.writeMsg(8010,
krmicd.getChid);
DBGANY:         218 TEXTNOD =      end if;
DBGANY:         219 TEXTNOD =      first_time := FALSE;
DBGANY:         220 TEXTNOD =   end if;
DBGANY:         221 TEXTNOD =   if files < memnum then
DBGANY:         222 TEXTNOD =     begin
DBGANY:         223 TEXTNOD =
sys.dbms_backup_restore.backupDataFile(dfnumber => dfnumber, 
DBGANY:         224 PRMVAL = max_corrupt=>0,since_change=>0
DBGANY:         225 TEXTNOD = );
DBGANY:         226 TEXTNOD =        krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         227 TEXTNOD =        deb('budf_name', 'blocks=' ||
blocks || ' block_size=' || blksize,
DBGANY:         228 TEXTNOD =            rman_constant.DEBUG_IO, 1);
DBGANY:         229 TEXTNOD =     exception
DBGANY:         230 TEXTNOD =        when
sys.dbms_backup_restore.inc_scn_matches_df_scn then
DBGANY:         231 TEXTNOD =           krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         232 TEXTNOD =           krmicd.writeMsg(8056,
to_char(dfnumber, 'FM09999'));
DBGANY:         233 TEXTNOD =           krmicd.clearErrors;
DBGANY:         234 TEXTNOD =     end;
DBGANY:         235 TEXTNOD =     files := files + 1;
DBGANY:         236 TEXTNOD =   end if;
DBGANY:         237 TEXTNOD = -- budf_name
DBGANY:         238 TEXTNOD =   
DBGANY:         239 PRMVAL =  memnum := 4;
DBGANY:         240 TEXTNOD =   
DBGANY:         241 PRMVAL =  dfnumber := 11; tsname := 'SDP_PROD_CDR';
fname := '/oracle/oradata/SDPREP/sdp_prod_4.dbf'; blocks := 638720;
blksize := 8192;
DBGANY:         242 TEXTNOD =   if (first_time) then
DBGANY:         243 TEXTNOD =      if not docopies then
DBGANY:         244 TEXTNOD =         krmicd.writeMsg(8010,
krmicd.getChid);
DBGANY:         245 TEXTNOD =      end if;
DBGANY:         246 TEXTNOD =      first_time := FALSE;
DBGANY:         247 TEXTNOD =   end if;
DBGANY:         248 TEXTNOD =   if files < memnum then
DBGANY:         249 TEXTNOD =     begin
DBGANY:         250 TEXTNOD =
sys.dbms_backup_restore.backupDataFile(dfnumber => dfnumber, 
DBGANY:         251 PRMVAL = max_corrupt=>0,since_change=>0
DBGANY:         252 TEXTNOD = );
DBGANY:         253 TEXTNOD =        krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         254 TEXTNOD =        deb('budf_name', 'blocks=' ||
blocks || ' block_size=' || blksize,
DBGANY:         255 TEXTNOD =            rman_constant.DEBUG_IO, 1);
DBGANY:         256 TEXTNOD =     exception
DBGANY:         257 TEXTNOD =        when
sys.dbms_backup_restore.inc_scn_matches_df_scn then
DBGANY:         258 TEXTNOD =           krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         259 TEXTNOD =           krmicd.writeMsg(8056,
to_char(dfnumber, 'FM09999'));
DBGANY:         260 TEXTNOD =           krmicd.clearErrors;
DBGANY:         261 TEXTNOD =     end;
DBGANY:         262 TEXTNOD =     files := files + 1;
DBGANY:         263 TEXTNOD =   end if;
DBGANY:         264 TEXTNOD = -- budf_name
DBGANY:         265 TEXTNOD =   
DBGANY:         266 PRMVAL =  memnum := 5;
DBGANY:         267 TEXTNOD =   
DBGANY:         268 PRMVAL =  dfnumber := 2; tsname := 'UNDOTBS1'; fname
:= '/oracle/oradata/SDPREP/undotbs1_512m.dbf'; blocks := 65280; blksize
:= 8192;
DBGANY:         269 TEXTNOD =   if (first_time) then
DBGANY:         270 TEXTNOD =      if not docopies then
DBGANY:         271 TEXTNOD =         krmicd.writeMsg(8010,
krmicd.getChid);
DBGANY:         272 TEXTNOD =      end if;
DBGANY:         273 TEXTNOD =      first_time := FALSE;
DBGANY:         274 TEXTNOD =   end if;
DBGANY:         275 TEXTNOD =   if files < memnum then
DBGANY:         276 TEXTNOD =     begin
DBGANY:         277 TEXTNOD =
sys.dbms_backup_restore.backupDataFile(dfnumber => dfnumber, 
DBGANY:         278 PRMVAL = max_corrupt=>0,since_change=>0
DBGANY:         279 TEXTNOD = );
DBGANY:         280 TEXTNOD =        krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         281 TEXTNOD =        deb('budf_name', 'blocks=' ||
blocks || ' block_size=' || blksize,
DBGANY:         282 TEXTNOD =            rman_constant.DEBUG_IO, 1);
DBGANY:         283 TEXTNOD =     exception
DBGANY:         284 TEXTNOD =        when
sys.dbms_backup_restore.inc_scn_matches_df_scn then
DBGANY:         285 TEXTNOD =           krmicd.writeMsg(8522,
to_char(dfnumber, 'FM09999'), fname);
DBGANY:         286 TEXTNOD =           krmicd.writeMsg(8056,
to_char(dfnumber, 'FM09999'));
DBGANY:         287 TEXTNOD =           krmicd.clearErrors;
DBGANY:         288 TEXTNOD =     end;
DBGANY:         289 TEXTNOD =     files := files + 1;
DBGANY:         290 TEXTNOD =   end if;
DBGANY:         291 TEXTNOD = -- bu_create
DBGANY:         292 TEXTNOD = <<create_piece>>
DBGANY:         293 TEXTNOD =
sys.dbms_backup_restore.backupStatus(state, setid, stamp, pieceno,
files,
DBGANY:         294 TEXTNOD =
datafiles, incremental, nochecksum,
DBGANY:         295 TEXTNOD =
device);
DBGANY:         296 TEXTNOD =   -- If we get here and the files count is
zero, then all files in this
DBGANY:         297 TEXTNOD =   -- backup set were skipped.
DBGANY:         298 TEXTNOD =   if (files = 0) then
DBGANY:         299 TEXTNOD =
sys.dbms_backup_restore.backupCancel;
DBGANY:         300 TEXTNOD =       krmicd.writeMsg(8057,
krmicd.getChid);
DBGANY:         301 TEXTNOD =   else
DBGANY:         302 TEXTNOD =       -- ncopies will be substituted for
ncopies := <number>
DBGANY:         303 TEXTNOD =       
DBGANY:         304 PRMVAL =  ncopies := 1;
DBGANY:         305 TEXTNOD =       if (ncopies = 0) then
DBGANY:         306 TEXTNOD =          ncopies :=
krmicd.getBackupCopies(backup_type, krmicd.getDevType);
DBGANY:         307 TEXTNOD =       end if;
DBGANY:         308 TEXTNOD =
sys.dbms_backup_restore.setLimit(sys.dbms_backup_restore.dupcnt,
DBGANY:         309 TEXTNOD =
ncopies);
DBGANY:         310 TEXTNOD =       loop
DBGANY:         311 TEXTNOD =           if not docopies then
DBGANY:         312 TEXTNOD =              krmicd.writeMsg(8038,
krmicd.getChid, to_char(pieceno+1),
DBGANY:         313 TEXTNOD =
to_char(sysdate));
DBGANY:         314 TEXTNOD =           end if;
DBGANY:         315 TEXTNOD =           declare
DBGANY:         316 TEXTNOD =               type names is table of
varchar2(512) index by binary_integer;
DBGANY:         317 TEXTNOD =               fnames             names;
DBGANY:         318 TEXTNOD =               lformat            names;
DBGANY:         319 TEXTNOD =               lyear
varchar2(4);
DBGANY:         320 TEXTNOD =               lday
varchar2(2);
DBGANY:         321 TEXTNOD =               lmonth
varchar2(2);
DBGANY:         322 TEXTNOD =               copyaux            number;
DBGANY:         323 TEXTNOD =               chtype
varchar2(16);
DBGANY:         324 TEXTNOD =               busy_retries       number :=
0;
DBGANY:         325 TEXTNOD =               piecefmt
varchar2(512);
DBGANY:         326 TEXTNOD =               set_stamp          number;
DBGANY:         327 TEXTNOD =               set_count          number;
DBGANY:         328 TEXTNOD =               deffmt
binary_integer;
DBGANY:         329 TEXTNOD =           begin
DBGANY:         330 TEXTNOD =           <<snapshot>>
DBGANY:         331 TEXTNOD =               begin
DBGANY:         332 TEXTNOD =               select to_char(sysdate,
'YYYY',
DBGANY:         333 TEXTNOD =
'NLS_CALENDAR=Gregorian'),
DBGANY:         334 TEXTNOD =                      to_char(sysdate,
'MM',
DBGANY:         335 TEXTNOD =
'NLS_CALENDAR=Gregorian'),
DBGANY:         336 TEXTNOD =                      to_char(sysdate,
'DD',
DBGANY:         337 TEXTNOD =
'NLS_CALENDAR=Gregorian')
DBGANY:         338 TEXTNOD =                 into lyear, lmonth, lday
DBGANY:         339 TEXTNOD =                 from x$dual;
DBGANY:         340 TEXTNOD =               -- initialize  the format
DBGANY:         341 TEXTNOD =               lformat(0) := NULL;
DBGANY:         342 TEXTNOD =               -- The following are
substituted for variable := value
DBGANY:         343 TEXTNOD =               -- format will substituted
by array of
DBGANY:         344 TEXTNOD =               -- lformat(<number>) :=
'<format>' and  nformat := <number>
DBGANY:         345 TEXTNOD =               
DBGANY:         346 PRMVAL =  lformat(0) := 'bk_%s_%p_%t'; nformat := 1;
DBGANY:         347 TEXTNOD =               -- Call genPieceName as many
times as ncopies, stored
DBGANY:         348 TEXTNOD =               -- generated names into
array of fnames.  Check in the
DBGANY:         349 TEXTNOD =               -- array for duplicated
names
DBGANY:         350 TEXTNOD =               copy := 0;
DBGANY:         351 TEXTNOD =               while copy < ncopies loop
DBGANY:         352 TEXTNOD =                   begin
DBGANY:         353 TEXTNOD =                   -- find out the format
to use (backup or channel format)
DBGANY:         354 TEXTNOD =                   piecefmt :=
lformat(mod(copy, nformat));
DBGANY:         355 TEXTNOD =                   krmicd.getFormat(format
=> piecefmt,
DBGANY:         356 TEXTNOD =                                    copy
=> copy+1,
DBGANY:         357 TEXTNOD =                                    deffmt
=> deffmt);
DBGANY:         358 TEXTNOD =                   -- If doing image copies
and the channel is not a DISK,
DBGANY:         359 TEXTNOD =                   -- then generate a piece
name for DISK type because server
DBGANY:         360 TEXTNOD =                   -- implicitly creates a
disk channel.
DBGANY:         361 TEXTNOD =                   chtype :=
krmicd.getDevType;
DBGANY:         362 TEXTNOD =                   if chtype is null then
DBGANY:         363 TEXTNOD =                      chtype := 'N/A';
DBGANY:         364 TEXTNOD =                   elsif (docopies and
chtype != 'DISK') then
DBGANY:         365 TEXTNOD =                      chtype := 'DISK';
DBGANY:         366 TEXTNOD =                   end if;
DBGANY:         367 TEXTNOD =                   fnames(copy) :=
DBGANY:         368 TEXTNOD =
sys.dbms_backup_restore.genPieceName(
DBGANY:         369 TEXTNOD =                          pno => pieceno+1,
DBGANY:         370 TEXTNOD =                          set_count =>
setid,
DBGANY:         371 TEXTNOD =                          set_stamp =>
stamp,
DBGANY:         372 TEXTNOD =                          format =>
piecefmt,
DBGANY:         373 TEXTNOD =                          copyno => copy+1,
DBGANY:         374 TEXTNOD =                          devtype =>
chtype,
DBGANY:         375 TEXTNOD =                          year => lyear,
DBGANY:         376 TEXTNOD =                          month => lmonth,
DBGANY:         377 TEXTNOD =                          day => lday,
DBGANY:         378 TEXTNOD =                          dbid =>
foreign_dbid,
DBGANY:         379 TEXTNOD =                          ndbname =>
foreign_dbname,
DBGANY:         380 TEXTNOD =                          cfseq => NULL,
-- not used
DBGANY:         381 TEXTNOD =                          fileno =>
dfnumber,
DBGANY:         382 TEXTNOD =                          tsname => tsname,
DBGANY:         383 TEXTNOD =                          logseq =>
to_char(sequence),
DBGANY:         384 TEXTNOD =                          logthr => thread,
DBGANY:         385 TEXTNOD =                          imagcp =>
docopies);
DBGANY:         386 TEXTNOD =                   -- check previous names
for collision
DBGANY:         387 TEXTNOD =                   copyaux := 0;
DBGANY:         388 TEXTNOD =                   while copyaux < copy
loop
DBGANY:         389 TEXTNOD =                       if fnames(copy) =
fnames(copyaux) then
DBGANY:         390 TEXTNOD =                           raise
wrong_format;
DBGANY:         391 TEXTNOD =                       end if;
DBGANY:         392 TEXTNOD =                       copyaux := copyaux +
1;
DBGANY:         393 TEXTNOD =                   end loop;
DBGANY:         394 TEXTNOD =                   -- Store the names of
the second copy onwards
DBGANY:         395 TEXTNOD =                   if (copy > 0) then
DBGANY:         396 TEXTNOD =
sys.dbms_backup_restore.backupPieceCrtDupSet(copy,
DBGANY:         397 TEXTNOD =
fnames(copy));
DBGANY:         398 TEXTNOD =                   end if;
DBGANY:         399 TEXTNOD =                   end;
DBGANY:         400 TEXTNOD =                   copy := copy + 1;
DBGANY:         401 TEXTNOD =               end loop;
DBGANY:         402 TEXTNOD =               -- Ok, now do the actual
piece creation, we use the 'old'
DBGANY:         403 TEXTNOD =               -- interface
DBGANY:         404 TEXTNOD =               copy := 0;
DBGANY:         405 TEXTNOD =
sys.dbms_backup_restore.backupPieceCreate(
DBGANY:         406 TEXTNOD =                    fname            =>
fnames(copy),
DBGANY:         407 TEXTNOD =                    pieceno          =>
pieceno,
DBGANY:         408 TEXTNOD =                    done             =>
done,
DBGANY:         409 TEXTNOD =                    handle           =>
handle,
DBGANY:         410 TEXTNOD =                    comment          =>
comment,
DBGANY:         411 TEXTNOD =                    media            =>
media,
DBGANY:         412 TEXTNOD =                    concur           =>
concur,
DBGANY:         413 TEXTNOD =                    
DBGANY:         414 PRMVAL = params=>null
DBGANY:         415 TEXTNOD = ,
DBGANY:         416 TEXTNOD =                    reuse            =>
reusefile,
DBGANY:         417 TEXTNOD =                    archlog_failover =>
larchlog_failover,
DBGANY:         418 TEXTNOD =                    deffmt           =>
deffmt,
DBGANY:         419 TEXTNOD =                    recid            =>
cprecid,
DBGANY:         420 TEXTNOD =                    stamp            =>
cpstamp,
DBGANY:         421 TEXTNOD =                    tag              =>
cptag,
DBGANY:         422 TEXTNOD =                    docompress       =>
docompress);
DBGANY:         423 TEXTNOD =               if larchlog_failover then
DBGANY:         424 TEXTNOD =                  failoverdone := TRUE;
DBGANY:         425 TEXTNOD =               end if;
DBGANY:         426 TEXTNOD =               if concur then
DBGANY:         427 TEXTNOD =                  krmicd.writeMsg(8135,
fname);
DBGANY:         428 TEXTNOD =               end if;
DBGANY:         429 TEXTNOD =               exception
DBGANY:         430 TEXTNOD =                   when
sys.dbms_backup_restore.snapshot_enqueue_busy then
DBGANY:         431 TEXTNOD =                   -- retry up to 5 times,
waiting 10 seconds between retries
DBGANY:         432 TEXTNOD =                       if busy_retries = 5
then
DBGANY:         433 TEXTNOD =
krmicd.writeMsg(20029,
DBGANY:         434 TEXTNOD =
'cannot make a snapshot controlfile');
DBGANY:         435 TEXTNOD =                           raise;
DBGANY:         436 TEXTNOD =                       end if;
DBGANY:         437 TEXTNOD =                       busy_retries :=
busy_retries + 1;
DBGANY:         438 TEXTNOD =
krmicd.writeMsg(8512);
DBGANY:         439 TEXTNOD =
krmicd.sleep(10*busy_retries);
DBGANY:         440 TEXTNOD =                       krmicd.clearErrors;
DBGANY:         441 TEXTNOD =                       goto snapshot;
DBGANY:         442 TEXTNOD =               end;
DBGANY:         443 TEXTNOD =               krmicd.writeIOs(stamp,
setid);
DBGANY:         444 TEXTNOD =           end; -- snapshot controlfile
stuff
DBGANY:         445 TEXTNOD =           if not docopies then
DBGANY:         446 TEXTNOD =               if ncopies = 1 then
DBGANY:         447 TEXTNOD =                   krmicd.writeMsg(8044,
krmicd.getChid, to_char(pieceno),
DBGANY:         448 TEXTNOD =
to_char(sysdate));
DBGANY:         449 TEXTNOD =               else
DBGANY:         450 TEXTNOD =                   krmicd.writeMsg(8045,
krmicd.getChid, to_char(pieceno),
DBGANY:         451 TEXTNOD =
to_char(sysdate), to_char(ncopies));
DBGANY:         452 TEXTNOD =               end if;
DBGANY:         453 TEXTNOD =           end if;
DBGANY:         454 TEXTNOD =           copy := 0;
DBGANY:         455 TEXTNOD =           while copy < ncopies loop
DBGANY:         456 TEXTNOD =               if (copy > 0) then
DBGANY:         457 TEXTNOD =                   -- Retrieve output
parameters from server structures
DBGANY:         458 TEXTNOD =
sys.dbms_backup_restore.backupPieceCrtDupGet(copy,
DBGANY:         459 TEXTNOD =
handle,
DBGANY:         460 TEXTNOD =
comment,
DBGANY:         461 TEXTNOD =
media);
DBGANY:         462 TEXTNOD =               end if;
DBGANY:         463 TEXTNOD =               if not docopies then
DBGANY:         464 TEXTNOD =                   if comment is null then
comment := 'NONE'; end if;
DBGANY:         465 TEXTNOD =                   krmicd.writeMsg(8503,
handle, comment);
DBGANY:         466 TEXTNOD =               else
DBGANY:         467 TEXTNOD =                   if doconvert then
DBGANY:         468 TEXTNOD =                      krmicd.writeMsg(8588,
handle);
DBGANY:         469 TEXTNOD =                   else
DBGANY:         470 TEXTNOD =                      if cptag is NOT NULL
then
DBGANY:         471 TEXTNOD =
krmicd.writeMsg(8586, handle, cptag, to_char(cprecid),
DBGANY:         472 TEXTNOD =
to_char(cpstamp));
DBGANY:         473 TEXTNOD =                      else
DBGANY:         474 TEXTNOD =
krmicd.writeMsg(8501, handle, to_char(cprecid),
DBGANY:         475 TEXTNOD =
to_char(cpstamp));
DBGANY:         476 TEXTNOD =                      end if;
DBGANY:         477 TEXTNOD =                   end if;
DBGANY:         478 TEXTNOD =               end if;
DBGANY:         479 TEXTNOD =               copy := copy + 1;
DBGANY:         480 TEXTNOD =           end loop;
DBGANY:         481 TEXTNOD =           if done then
DBGANY:         482 TEXTNOD =              stampd := stamp2date(stamp);
DBGANY:         483 TEXTNOD =              select sysdate-stampd into
elapsed from x$dual;
DBGANY:         484 TEXTNOD =              dur2time(elapsed, hours,
mins, secs);
DBGANY:         485 TEXTNOD =              if failoverdone then
DBGANY:         486 TEXTNOD =                 krmicd.writemsg(8112,
krmicd.getChid);
DBGANY:         487 TEXTNOD =              end if;
DBGANY:         488 TEXTNOD =              if not docopies then
DBGANY:         489 TEXTNOD =                 m := 8540;
DBGANY:         490 TEXTNOD =              else
DBGANY:         491 TEXTNOD =                 if doconvert then
DBGANY:         492 TEXTNOD =                    m := 8590;
DBGANY:         493 TEXTNOD =                 end if;
DBGANY:         494 TEXTNOD =              end if;
DBGANY:         495 TEXTNOD =              krmicd.writemsg(m,
krmicd.getChid,
DBGANY:         496 TEXTNOD =
to_char(hours, 'FM09') || ':' ||
DBGANY:         497 TEXTNOD =                              to_char(mins,
'FM09') || ':' ||
DBGANY:         498 TEXTNOD =                              to_char(secs,
'FM09'));
DBGANY:         499 TEXTNOD =              exit;
DBGANY:         500 TEXTNOD =           end if;
DBGANY:         501 TEXTNOD =       end loop;
DBGANY:         502 TEXTNOD =   end if;
DBGANY:         503 TEXTNOD =   first_time := TRUE;  -- in case we will
be deleting what we backed up
DBGANY:         504 TEXTNOD =   if (endBackupJobStep(FALSE, 0)) then
null; end if;
DBGANY:         505 TEXTNOD = exception
DBGANY:         506 TEXTNOD =   when others then
DBGANY:         507 TEXTNOD =      if (not endBackupJobStep(TRUE,
sqlcode)) then
DBGANY:         508 TEXTNOD =         raise;
DBGANY:         509 TEXTNOD =      end if;
DBGANY:         510 TEXTNOD = end;
DBGANY:     2 STEP id=2 status=NOT STARTED
.
.
.
.
.
.
.
.
.
.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-00600: internal error, arguments [6000] [] [] [] []
logout

Script ./hot_database_backup.sh
==== ended in error on Fri Jun 20 13:02:33 EETDST 2008 ====



http://www.avea.com.tr/avea/banner/index.htm
-------------------------------------------------------------------------------------
"Bu elektronik posta ve onunla iletilen butun dosyalar gizlidir ve sadece 
gondericisi tarafindan almasi amaclanan yetkili gercek ya da tuzel kisinin 
kullanimi icindir. Eger soz konusu yetkili alici degilseniz bu elektronik 
postanin icerigini aciklamaniz, kopyalamaniz, yonlendirmeniz ve kullanmaniz 
kesinlikle yasaktir ve bu elektronik postayi derhal silmeniz gerekmektedir. 
AVEA bu mesajin icerdigi bilgilerin dogrulugu veya eksiksiz oldugu konusunda 
herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin ne sekilde olursa 
olsun iceriginden, iletilmesinden, alinmasindan ve saklanmasindan sorumlu 
degildir. Bu mesajdaki gorusler yalnizca gonderen kisiye ait olup, her zaman 
AVEA 'nin goruslerini yansitmayabilir. Bu e-posta bilinen butun bilgisayar 
viruslerine karsi taranmistir."
-------------------------------------------------------------------------------------
"This e-mail and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you are not the intended recipient you are hereby notified that any 
dissemination, forwarding, copying or use of any of the information is strictly 
prohibited, and the e-mail should immediately be deleted. AVEA makes no 
warranty as to the accuracy or completeness of any information contained in 
this message and hereby excludes any liability of any kind for the information 
contained therein or for the information transmission, reception, storage or 
use of such in any way whatsoever.The opinions expressed in this message may 
belong to sender alone and may not necessarily reflect the opinions of AVEA. 
This e-mail has been scanned for all known computer viruses."

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu