Всем привет.
Была ситуация во время архивирования с нехваткой места для редологов, перемещал их из ..../oraarch и в итоге
они были удалены ((((

Оффлайновые бэкапы теперь не находят редологов... можно как-нибудь исправить ситуацию...чтобы оффлайн бэкапы нормально проходили??



Job started
Step 001 started (program RSDBAJOB, variant &0000000000212, user ID ADM
Выполнение логической команды ZDBOFFREDVERBACKUP на компьютере ###
Параметры:
BR0051I BRBACKUP 6.40 (52)
BR0055I Start of database backup: befmaymk.aff 2011-03-20 00.30.42
BR0484I BRBACKUP log file: /oracle/TRP/sapbackup/befmaymk.aff
BR0280I BRBACKUP time stamp: 2011-03-20 00.30.44
BR0057I Backup of database: TRP
BR0058I BRBACKUP action ID: befmaymk
BR0059I BRBACKUP function ID: aff
BR0110I Backup mode: ALL
BR0077I Database files for backup:
/oracle/TRP/origlogA/log_g11m1.dbf
/oracle/TRP/origlogB/log_g12m1.dbf
/oracle/TRP/origlogA/log_g13m1.dbf
/oracle/TRP/origlogB/log_g14m1.dbf
/oracle/TRP/origlogA/cntrl/cntrlTRP.dbf
BR0061I 66 files found for backup, total size 573640.158 MB
BR0143I Backup type: offline_force
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0280I BRBACKUP time stamp: 2011-03-20 00.30.44
BR0307I Shutting down database instance TRP ...
BR0280I BRBACKUP time stamp: 2011-03-20 00.36.28
BR0308I Shutdown of database instance TRP successful
BR0280I BRBACKUP time stamp: 2011-03-20 00.36.28
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/TRP/SYS/exe/run/backint -u TRP -f backup -i /oracle/TRP/sapbackup/.befmaymk.lst -t file -p /
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program: /usr/sap/TRP/SYS/exe/run/backint 6.0
Input File: /oracle/TRP/sapbackup/.befmaymk.lst
Profile: /oracle/TRP/920_64/dbs/initTRP.utl
Function: BACKUP
Backup Type: BACKUP_FILE
********************************************************************************
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/temp_1/temp.data1
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/temp_2/temp.data2
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp_1/trp.data1
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp_2/trp.data2
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp_3/trp.data3
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp_4/trp.data4
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp_5/trp.data5
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_10/trp.data10
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_11/trp.data11
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_12/trp.data12
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_13/trp.data13
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_14/trp.data14
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_15/trp.data15
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_16/trp.data16
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_17/trp.data17
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_18/trp.data18
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_19/trp.data19
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_20/trp.data20
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_21/trp.data21
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_22/trp.data22
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_23/trp.data23
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_24/trp.data24
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_25/trp.data25
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_26/trp.data26
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_27/trp.data27
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_28/trp.data28
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_29/trp.data29
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_30/trp.data30
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_31/trp.data31
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_32/trp.data32
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_33/trp.data33
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_34/trp.data34
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_35/trp.data35
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_36/trp.data36
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_37/trp.data37
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_38/trp.data38
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_39/trp.data39
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_40/trp.data40
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_6/trp.data6
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_7/trp.data7
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_8/trp.data8
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp_9/trp.data9
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/trp640_1/trp640.data1
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/trp640_2/trp640.data2
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/trp640_3/trp640.data3
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/trp640_4/trp640.data4
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/trp640_5/trp640.data5
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata2/trp640_10/trp640.data10
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata2/trp640_6/trp640.data6
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata2/trp640_7/trp640.data7
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata2/trp640_8/trp640.data8
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata2/trp640_9/trp640.data9
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata3/trp640_11/trp640.data11
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp640_12/trp640.data12
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp640_13/trp640.data13
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp640_14/trp640.data14
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trp640_15/trp640.data15
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata4/trpusr_1/trpusr.data1
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/undo_1/undo.data1
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/undo_2/undo.data2
#SAVED.... VXF1300570559
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/sapdata1/system_1/system.data1
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/origlogA/log_g11m1.dbf
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/origlogB/log_g12m1.dbf
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/origlogA/log_g13m1.dbf
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/origlogB/log_g14m1.dbf
#SAVED.... VXF1300570560
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
#FILE..... /oracle/TRP/origlogA/cntrl/cntrlTRP.dbf
#SAVED.... VXF1300570560
********************************************************************************
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.27
BR0232I 66 of 66 files saved by backup utility
BR0230I Backup utility called successfully
BR0280I BRBACKUP time stamp: 2011-03-20 06.37.29
BR0304I Starting and opening database instance TRP ...
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.00
BR0305I Start and open of database instance TRP successful
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.00
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/TRP/SYS/exe/run/backint -u TRP -f backup -i /oracle/TRP/sapbackup/.befmaymk.lst -t file -p /
WARNING: sort_backup_type not specified in .utl file
WARNING: default sort_backup_type to <size> for backup
********************************************************************************
Program: /usr/sap/TRP/SYS/exe/run/backint 6.0
Input File: /oracle/TRP/sapbackup/.befmaymk.lst
Profile: /oracle/TRP/920_64/dbs/initTRP.utl
Function: BACKUP
Backup Type: BACKUP_FILE
********************************************************************************
BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRP.ora
BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRPoffver.sap
BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRP.utl
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapreorg/spaceTRP.log
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapreorg/strucTRP.log
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapbackup/befmaymk.aff
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapbackup/backTRP.log
********************************************************************************
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.14
BR0279E Return code from '/usr/sap/TRP/SYS/exe/run/backint -u TRP -f backup -i /oracle/TRP/sapbackup/.befmaymk.lst -t file -p /o
BR0232E 0 of 7 files saved by backup utility
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.14
BR0231E Backup utility call failed
BR0056I End of database backup: befmaymk.aff 2011-03-20 06.38.14
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.14
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.14
BR0291I BRARCHIVE will be started with options '-U -d util_file -c force -p initTRPoffver.sap -sd'
BR0002I BRARCHIVE 6.40 (52)
BR0006I Start of offline redo log processing: aefmcfco.svd 2011-03-20 06.38.14
BR0484I BRARCHIVE log file: /oracle/TRP/saparch/aefmcfco.svd
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182317.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182318.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182319.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182320.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182321.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182322.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182323.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182324.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182325.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182326.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182327.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182328.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182329.dbf' not found
BR0017W Offline redo log file '/oracle/TRP/oraarch/TRParch1_182330.dbf' not found

..................


BR0280I BRARCHIVE time stamp: 2011-03-20 06.38.29
BR0279E Return code from '/usr/sap/TRP/SYS/exe/run/backint -u TRP -f backup -i /oracle/TRP/saparch/.aefmcfco.lst -t file -p /ora
BR0232E 0 of 87 files saved by backup utility
BR0280I BRARCHIVE time stamp: 2011-03-20 06.38.29
BR0231E Backup utility call failed
BR0016I 0 offline redo log files processed, totalsize 0.000 MB
BR0007I End of offline redo log processing: aefmcfco.svd 2011-03-20 06.38.30
BR0280I BRARCHIVE time stamp: 2011-03-20 06.38.30
BR0005I BRARCHIVE terminated with errors
BR0280I BRBACKUP time stamp: 2011-03-20 06.38.30
BR0292I Execution of BRARCHIVE finished with return code 5
Job finished

у вас проблема не в отсутствии редо-логов (сообщения типа warning процесс не прерывают), а проблема с util_file. разделите бекап не две части - сам бекап и архивирование редо-логов, и разберитесь поэтапное. возможно там элементарно не хватает полномочий

Да вы правы в не пройденных бэкапах, ошибка:
Бэкап делается с использованием веритаса
Права на файлы в которые не удалась запись не менялись

-rw-r-xr-x orasid dba


BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRP.ora
BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRPoffver.sap
BR0233E Backup utility has reported an error while saving file /oracle/TRP/920_64/dbs/initTRP.utl
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapreorg/spaceTRP.log
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapreorg/strucTRP.log
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapbackup/befibsky.aff
BR0233E Backup utility has reported an error while saving file /oracle/TRP/sapbackup/backTRP.log
********************************************************************************
BR0280I BRBACKUP time stamp: 2011-02-27 06.42.11
BR0279E Return code from '/usr/sap/TRP/SYS/exe/run/backint -u TRP -f backup -i /oracle/TRP/sapbackup/.befibsky.lst -t file -p /oracle/TRP/920_64/dbs/initTRP.utl -c': 2
BR0232E 0 of 7 files saved by backup utility
BR0280I BRBACKUP time stamp: 2011-02-27 06.42.11
BR0231E Backup utility call failed

Подскажите пожалуйста как можно исправить данную ситуацию

А исполняемые программы BRBACKUP и BRARCHIVE какие полномочия имеют?

-rwsrwxr-x 1 oratrp dba 4869056 brarchive
-rwsrwxr-x 1 oratrp dba 4997432 brbackup
-rwsrwxr-x 1 oratrp dba 6563384 brconnect
-rwsrwxr-x 1 oratrp dba 5342368 brrecover
-rwsrwxr-x 1 oratrp dba 2144608 brrestore
-rwsrwxr-x 1 oratrp dba 6744992 brspace
-rwsrwxr-x 1 oratrp dba 2968704 brtools


Бэкап делается через веритас нетбэкап 6.0 может быть ошибки как то связаны с этой связкой?

А какие атрибуты у папочек:
/oracle/TRP/920_64/dbs
/oracle/TRP/sapreorg
?

Проблема конечно в полномочиях, агенты веритаса, которые фактически делают бэкап, не имеют полномочий на эти файлы.

drwxr-xr-x 2 oratrp dba dbs

-rw-r-xr-x 1 oratrp dba initTRP.sap
-rw-r-xr-x 1 oratrp dba initTRPoffver.sap
-rw-r-xr-x 1 oratrp dba initTRP.utl

drwxr-xr-x 6 oratrp dba sapreorg


-rw-r--r-- 1 oratrp sapsys spaceTRP.log тут наверное и ошибка ?? у пользователя oratrp группа dba
-rw-r--r-- 1 oratrp dba strucTRP.log


drwxr-xr-x 2 oratrp dba sapbackup

-rw-r--r-- 1 oratrp sapsys backTRP.log

и вообще все файлы в директории /oracle/TRP/sapbackup/ oratrp:sapsys кроме

-rw-r--r-- 1 oratrp dba recovTRP.log
-rw-r--r-- 1 oratrp dba restTRP.log

вот что написано по вашей ошибке в ноте 17163:
.....
Explanation: The external backup program reported an error while saving the file.
Program reaction: Processing terminates.
User action: Check the other messages from the external backup program. If required, contact the supplier of the external backup program (the supplier of interface program BACKINT).
......

Веритас ведет свои логи наверняка, гляньте там, м.б. что полезное найдется.
Вообще с "backin"t частенько бывают различные косяки, пока все отловишь, и поддержка от вендоров по этому поводу слабая, сам с таким сталкивался с хьюлетовым датапротектором.

Спасибо всем за помощь проблема была в Netbackup