Forum Discussion
I have ready done a normal backup (file systems backup) and it works fine, skipping some file but work fine.
While the oracle backup doesn't work.
When automatic scheduler start execute the script and this is the output i see:
verifica schedulazioni
schedulazione utilizzata : sch-aut.day
utilizzo application backup = sch-app.day
==== started on ven 19/11/2010 13.24 ====
Script name: "C:\batch\hot_database_backup_ORCL.cmd"
#
RMAN : d:\oracle\ora92\bin\rman.exe
NLS_LANG : american
ORACLE_HOME : d:\oracle\ora92
ORACLE_SID : ORCL
NLS_DATE_FORMAT : YYYY-MM-DD:hh24:mi:ss
RMAN_LOG_FILE : "c:\batch\logs\rman_ORCL_19112010_13.24.00.log"
NB_ORA_SERV : michelangelo.unix.xxxxxxxxxxx.it
NB_ORA_FULL : 1
NB_ORA_INCR : 0
NB_ORA_CINC : 0
NB_ORA_CLASS : pol-vi1.igl.ora.xxxxxxx.orcl
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ORCL (DBID=1023686199)
using target database controlfile instead of recovery catalog
RMAN>
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
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>
allocated channel: ch00
channel ch00: sid=16 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723)
sent command to channel: ch00
Starting backup at 2010-11-19:13:24:02
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=E:\ORADATA\ORCL\SYSTEM01.DBF
input datafile fno=00006 name=E:\ORADATA\ORCL\SYSTEM02.DBF
input datafile fno=00007 name=E:\ORADATA\ORCL\USERDATA01.DBF
input datafile fno=00008 name=E:\ORADATA\ORCL\INDEX01.DBF
input datafile fno=00009 name=E:\ORADATA\ORCL\UNDOTBS02.DBF
input datafile fno=00002 name=E:\ORADATA\ORCL\UNDOTBS01.DBF
input datafile fno=00003 name=E:\ORADATA\ORCL\INDX01.DBF
input datafile fno=00005 name=E:\ORADATA\ORCL\USERS01.DBF
input datafile fno=00004 name=E:\ORADATA\ORCL\TOOLS01.DBF
channel ch00: starting piece 1 at 2010-11-19:13:24:03
channel ch00 at 13:24 call application backup and it stop abbnormaly whit status code 12 and write this error:
19-nov-2010 13.24.16 - Error bprd (pid=11677) Unable to write progress log </C/ProgramÀ Files/Veritas/NetBackup/Logs/user_ops/dbext/logs/5132.0.1290169444> on client amilora4. Policy=pol-vi1.igl.ora.amilora4.orcl Sched=sch-app.day
19-nov-2010 13.24.16 - Error bprd (pid=11677) CLIENT amilora4 POLICY pol-vi1.igl.ora.amilora4.orcl SCHED sch-app.day EXIT STATUS 12 (file open failed)
Then the automatic scheduler end with status 29 and write this error:
1: (29) failed trying to exec a command
If you wont I can send the script file even if the error is not in the script.
I use this model of the script for many other client in my architeture systems.
Thanks a lot ...