Archiver Stuck
Hi gurus,
i get the attached error log when i try to take online full backup. Harddrive has enough space and archive log and datafiles mounted on "/opt". Permissions are ok. Any idea?
OS : Suse Enterprise 10
DB : Oracle 11G
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 104G 69G 30G 70% /
udev 35G 786M 35G 3% /dev
/dev/sdb1 1.1T 145G 899G 14% /opt
ERROR LOG
BR0202I Saving /oracle/V01/112_64/dbs/initV01.sap
BR0203I to /opt/oracle/backup/V01 ...
BR0280I BRBACKUP time stamp: 2012-01-26 19.21.46
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2012-01-26 19.21.46
BR0315I 'Alter tablespace PSAPSR3 begin backup' successful
BR0201I Compressing /opt/oracle/sapdata2/sr3_1/sr3.data1
BR0203I to /opt/oracle/backup/behtetcm/sr3.data1.Z ...
#FILE..... /opt/oracle/sapdata2/sr3_1/sr3.data1
#SAVED.... /opt/oracle/backup/behtetcm/sr3.data1.Z #1/1 9.1064:1 1151471267
BR0280I BRBACKUP time stamp: 2012-01-26 19.25.41
BR0063I 1 of 9 files processed - 10000.008 of 66804.953 MB done
BR0204I Percentage done: 14.97%, estimated end time: 19:47
BR0001I *******___________________________________________
BR0201I Compressing /opt/oracle/sapdata2/sr3_2/sr3.data2
BR0203I to /opt/oracle/backup/behtetcm/sr3.data2.Z ...
#FILE..... /opt/oracle/sapdata2/sr3_2/sr3.data2
#SAVED.... /opt/oracle/backup/behtetcm/sr3.data2.Z #1/2 82.3164:1 254767420
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.02
BR0063I 2 of 9 files processed - 30000.016 of 66804.953 MB done
BR0204I Percentage done: 44.91%, estimated end time: 19:37
BR0001I **********************____________________________
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.02
BR0301E SQL error -257 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-00257: archiver error. Connect internal only, until freed.
BR0310E Connect to database instance V01 failed
BR0311E Connect to database instance V01 during online backup failed
BR0115I Compression rate for all files 22.3698:1
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.04
BR0301E SQL error -257 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-00257: archiver error. Connect internal only, until freed.
BR0310E Connect to database instance V01 failed
BR0056I End of database backup: behtetcm.and 2012-01-26 19.29.02
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.04
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 5
BR0280I BRTOOLS time stamp: 2012-01-26 19.29.04
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2012-01-26 20.04.06
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRTOOLS time stamp: 2012-01-26 20.04.06