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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
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-l
Received on Wed May 24 2023 - 16:25:56 CEST

Original text of this message