Hello my oracle friends :-),
My client has a oracle database 11.2.0.4.0 (os is RedHat 6.9) that deployed on virtual machine server. This issue is very weird. The oracle RMAN full backup always hasn't been finished yet in recent two number of Sunday (but incremental rman backup is good and only need less than 1 hour or even just 10 minutes to finish).
The volume of rman full backup has approximately 1.2 TB and it took 8 hours finishing backup in each Sunday (the crontab has started from 01:00 every day).
But the rman full backup hasn't been finished yet both on Nov 20 and 27, 2022.
Here is some data I've captured.
captured_data.txt (16.69 KB)Afterwards I've found this note - https://blog.csdn.net/xyz846/article/details/81872638.
Yes, I've finished setting "vm.dirty_background_ratio = 5 and vm.dirty_ratio = 10" in /etc/sysctl.conf once (in other words on Aug 09, 2022 occured the same issue but after 3 months it also appeared ...).
[root@tbm-oracle1 ~]# cat /etc/sysctl.conf
......
vm.dirty_background_ratio = 5
vm.dirty_ratio = 10
......
Now it seems like to have no any effect in previous setting. Has anyboby else other good suggestion? Thank you so much.
Best Regards
Quanwen Zhao