Re: Why never finished deploying oracle data guard physical standy by

Hello Mladen :-),

A big thanks for your advice. The total physical memory of primary database is enough (512 gb) and the swap size is 16g.

Best Regards
Quanwen Zhao

Mladen Gogala <gogala.mladen_at_gmail.com> 于2023年5月24日周三 22:25写道：

> 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-1217https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l