Volume size or disk capacity reached

[Former Member]

Hi Guruz,

I am having 4.6C on Oracle 8i.I schedule offline redo log back up daily as and when required.Everything is working fine.Though there is enough free space in the drive where the backup should be taken following warning is being encountered:

oracle_profile E:\ORACLE\SID\817\DATABASE\initSID.ora

sapdata_home J:\oracle\SID

sap_profile E:\ORACLE\SID\817\DATABASE\initSID.sap

backup_dev_type disk

archive_copy_dir J:\oracle\SID\sapbackup\ARCH

compress yes

compress_cmd C:\Winnt\SapCluster\mkszip -c $ > $

system_info SAPServiceSID ALSTPRC Windows NT 5.0 Build 2195 Service Pack 4 Intel

sap_info 46C SAPR3 SID V1971912821 R3_ORA 0020123090

make_info NTintel OCI_817_SHARE Jan 14 2003

command_line brarchive -u / -c force -p initSID.sap -sd

<b>BR019W Volume size or disk capacity reached - not all offline redo log files will be saved</b>

Backup is succesful with errors.I want to know why this is happening???I s there any formulla to calculate how many logs it can process???

Thanks in advance.

Regards,

Rahman

[former_member204746]

Perhaps compression rates are outdated.

run:

brbackup -k only.

[Former Member]

Hi All,

Thanx a lot for your response.

Backup is running successfully with warnings.But my question is that when there is enough space then why should it encounter such warnings?

Next time I will come up with exact free space in the drive before running the backup.

Regards,

Rahman

[former_member204746]

you are using compression.

brbacvkup needs to know how much data it can comrpess. it then can deduce a compression rate.

this compression rates gets bad after a while, so, it is a good idea to run brbackup command I provided earlier to recalculate compressions rate.

... or, completely disable software compression.

[Former Member]

Thanks

[Former Member]

Hi Mofizur,

It is surely related to some calculation BRARCHIVE is doing. And some thing to do with the J: drive space. Please watch care fully the space available in the drive before you issue BRARCHIVE. In this case what I can see you are backing up 45 archive log file of 20MB hence it is looking for 900MB of space but again you are going for some compression. So very difficult calculate the space required. Try taking lesser files and watch.

The another advice is, Please avoid the J drive for your Archive log backup. As It seems your Oracle home drive as well, in a long run you may face some space issue.

[former_member204746]

brarchive considers that J:\oracle\SID\sapbackup\ARCH does not have enough disk space to accommodate the backup of redologs.

how much disk space is left on J: drive?

as suggested earlier, provide full BRARCHIVE log.

[Former Member]

BR002I BRARCHIVE 6.20 (27)

BR006I Start of offline redo log processing: adwemuri.svd 2007-09-19 13.56.26

BR101I Parameters

oracle_sid ALP

oracle_home E:\ORACLE\ALP\817

oracle_profile E:\ORACLE\ALP\817\DATABASE\initALP.ora

sapdata_home J:\oracle\ALP

sap_profile E:\ORACLE\ALP\817\DATABASE\initALP.sap

backup_dev_type disk

archive_copy_dir J:\oracle\ALP\sapbackup\ARCH

compress yes

compress_cmd C:\Winnt\SapCluster\mkszip -c $ > $

system_info SAPServiceALP ALSTPRC Windows NT 5.0 Build 2195 Service Pack 4 Intel

sap_info 46C SAPR3 ALP V1971912821 R3_ORA 0020123090

make_info NTintel OCI_817_SHARE Jan 14 2003

command_line brarchive -u / -c force -p initALP.sap -sd

BR019W Volume size or disk capacity reached - not all offline redo log files will be saved

BR280I Time stamp 2007-09-19 13.57.12

BR008I Offline redo log processing for database instance: ALP

BR009I BRARCHIVE action ID: adwemuri

BR010I BRARCHIVE function ID: svd

BR048I Archive function: save_delete

BR011I 45 offline redo log files found for processing, total size 899.993 MB

BR111I Files will be compressed

BR130I Backup device type: disk

BR106I Files will be saved on disk in directory: J:\oracle\ALP\sapbackup\ARCH

BR134I Unattended mode with 'force' active - no operator confirmation allowed

BR202I Saving init_ora

BR203I to J:\oracle\ALP\sapbackup\ARCH\ALP ...

BR202I Saving E:\ORACLE\ALP\817\DATABASE\initALP.sap

BR203I to J:\oracle\ALP\sapbackup\ARCH\ALP ...

BR280I Time stamp 2007-09-19 13.57.12

BR198I Profiles saved successfully

BR201I Compressing J:\oracle\ALP\saparch\ALParch1_157533

BR203I to J:\oracle\ALP\sapbackup\ARCH\ALParch1_157533.Z ...

#ARCHIVE.. J:\oracle\ALP\saparch\ALParch1_157533

#SAVED.... J:\oracle\ALP\sapbackup\ARCH\ALParch1_157533.Z #1/1 2.2671:1 9250515

BR015I Offline redo log file J:\oracle\ALP\saparch\ALParch1_157533 deleted

BR280I Time stamp 2007-09-19 13.57.21

BR014I 1 of 45 offline redo log files processed - 20.000 MB of 899.993 MB done

BR204I Percentage done: 2.22%, estimated end time: 14:03

BR001I *_________________________________________________

BR201I Compressing J:\oracle\ALP\saparch\ALParch1_157534

BR203I to J:\oracle\ALP\sapbackup\ARCH\ALParch1_157534.Z ...

#ARCHIVE.. J:\oracle\ALP\saparch\ALParch1_157534

#SAVED.... J:\oracle\ALP\sapbackup\ARCH\ALParch1_157534.Z #1/2 3.6980:1 5671152

BR015I Offline redo log file J:\oracle\ALP\saparch\ALParch1_157534 deleted

BR280I Time stamp 2007-09-19 13.57.30

BR014I 2 of 45 offline redo log files processed - 40.001 MB of 899.993 MB done

BR204I Percentage done: 4.44%, estimated end time: 14:03

BR001I **________________________________________________

BR201I Compressing J:\oracle\ALP\saparch\ALParch1_157535

BR203I to J:\oracle\ALP\sapbackup\ARCH\ALParch1_157535.Z ...

#ARCHIVE.. J:\oracle\ALP\saparch\ALParch1_157535

#SAVED.... J:\oracle\ALP\sapbackup\ARCH\ALParch1_157535.Z #1/3 3.3100:1 6335898

BR015I Offline redo log file J:\oracle\ALP\saparch\ALParch1_157535 deleted

BR280I Time stamp 2007-09-19 13.57.39

We are taking the backup on Disk.We have found at that point of time enough free space was available in that Drive.Is there any parameter?

Regards,

Rahman

[former_member204746]

so, J: drive has at least 900MB of free disk space? how much disk space is really left^ please tell us.

have you considered updating BRTOOLS. your version is a bit old.

and this is just a mere warning, does your brarchive run finish successfully with warnings, or with errors?

[Former Member]

Mofizur:

The warning is not for your backup directory its for the redolog or the archive log directory, which is J:\oracle\ALP\sapbackup\ARCH in your case.

From the log its evident that its backing up a total of 899.993 MB of files. And I suppose its looks for double the size in you J:\oracle\ALP\sapbackup\ARCH directory. Check this filesystem for space requirements.

By the way from your logs...I feel that the archive backup is running succesfully with this warning alone.

-Madhu

[Former Member]

Per your log, only two file were archived (2 of 45 offline redo log files processed - 40.001 MB of 899.993 MB done). The archive directory can't be full at the time of this copy / delete procedure. Make sure you have some free space (at least double the size of two log files).

Thanks.

BMG

[Former Member]

Rahman:

Could you put the whol BRARCHIVE log, so that its easy to understadn the situation.

-Madhu