Re: Why never finished deploying oracle data guard physical standy by
Date: Wed, 24 May 2023 10:25:56 -0400
Message-ID: <c3b7222f-e4f9-ddf2-184b-8eb593de5501_at_gmail.com>
On 5/24/23 03:53, Quanwen Zhao wrote:
> And I have to adjust the value of *vm.dirty_ratio* from the original
> *10* to *60* on /etc/sysctl.conf. Re-running rman duplicate task on
> yesterday morning, yes, it's very great. Taking about 9 hours the
> physical standby database has been fiished deploying during the period
> of that time primary database is ok.
>
> Afterwards, finished recoving archived logs and started applying
> archived logs.
>
> Best Regards
> Quanwen Zhao
Hi Quanwen,
Great job with tuning the VM parameters. However, you seem to be a little short on memory. It may be the time to suggest a memory upgrade to your boss. Here are some other parameters that you might want to set:
vm.swappiness = 10 /* This iparameter determines how
aggressive the swapper will be */
vm.vfs_cache_pressure=50 /* This parameter decides how
quickly will the system recycle the inode cache */
vm.page-cluster = 5 /* This parameter defines the
length of the swap IO. The value of 5 means that the
swapper will write in 32 (=2**5) page batches, if possible.
vm.min_free_kbytes = 4194304 /* Minimum size of the free memory on the system */
The values are from my Fedora desktop with 64GB of RAM. I don't use Fedora as a DB server, I use it for containerization:
mgogala_at_umajor ~]$ podman ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 11a9d6826ed0 localhost/pgsql15:3 12 days ago Exited (0) 12 days ago 0.0.0.0:5432->5432/tcp pg15-3 3d75e90a4c46 localhost/ora23c:2 5 days ago Exited (137) 20 hours ago ora23c f5ff0422ca81 localhost/ora19:19 3 days ago Exited (137) 20 hours ago ora19-19
I also use VirtualBox because for Data Guard configurations I would need k8s because one container is not aware of another. I also have a Windows 11 VM for Visio and Word. Sorry to say, but no open source project can compete with Visio.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 24 2023 - 16:25:56 CEST