File corruption in database backup

JPIS

Cadet
Joined
Sep 26, 2019
Messages
3
OS Version: FreeNAS-11.2-U5 (Build Date: Jun 24, 2019 18:41)
Processor: Intel(R) Xeon(R) CPU E5620 @ 2.40GHz (16 cores)
Memory: 36 GiB

Motherboard:
- Supermicro X8DT3
CPU:
- 2x Intel E5620 2.40GHz 4 core 8 thread
RAM:
- 9x 4GB DDR3 1066MHz (36GB)
Hard drives:
- 2 SSD Sandisk 120GB
- 8 HD 6tb SATA 5900rpm ( WD60EFRX / ST6000AS0002 )
- 1 pool: raidz1-0 with 4 HD / raidz1-1 with 4 HD
HD Controllers:
- Broadcom SAS9210-8i HBA - No RAID
Network cards:
- Intel PRO/1000 1 Gbps
- QLogic BCM57810 10 Gbps


We have a FreeNAS 11.2 installed on a SuperMicro using HBA and SPF + and are having an issue with Oracle backup file corruption.
When we use the validation routine after completing backups, some databases have file corruption (error is not reported during backup generation).
We currently use the following mounting parameters for NFS:
nfs rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768 0 0
What would be the most appropriate parameters for mounting NFS, if any.
 

Attachments

  • debug-freenas4-20191107115027.tgz
    587.6 KB · Views: 292

JPIS

Cadet
Joined
Sep 26, 2019
Messages
3
Although the documentation advised that it would be irrelevant, I enabled sync (Always) for the problem dataset. And I am running some backups to test the integrity of the files.
Thanks for the sugestion.
 

JPIS

Cadet
Joined
Sep 26, 2019
Messages
3
I should not have used the word 'documentation'. It was a decision based on the suggestion posted on the forum and other research I made about this parameter.
I am still doing tests to know how much improved, since I had error incidence still ...
 
Top