foalabs

Understanding the ARCHIVE_LAG_TARGET Parameter in Oracle Database The ARCHIVE_LAG_TARGET parameter is an important configuration setting in Oracle databases, particularly in environments where data consistency and recovery point objectives (RPO) are critical, such as Data Guard setups. This parameter helps manage and minimize the lag between the primary and standby databases by controlling the frequency of log switches. What is ARCHIVE_LAG_TARGET? ARCHIVE_LAG_TARGET is an Oracle initialization parameter that specifies the target time (in seconds) for which the redo data can lag behind on a standby database relative to the primary database. By setting this parameter, you can ensure that the primary database frequently archives its redo logs, thereby reducing the potential data loss in case of a failover to the standby database. How ARCHIVE_LAG_TARGET Works When the ARCHIVE_LAG_TARGET parameter is set, Oracle ensures that the primary database archives its current redo log at least once e...

Steps to Upgrade 11g DB System to 19c DB System for Oracle E-Business Suite 12.1.3 on OCI Cloud In this post I am going to share how to upgrade the 11g DB to 19c DB system on OCI for EBS 12.1.3 Application. Source Oracle Database 11.2.0.4, OS Linux 7.9 VM Target Oracle Database 19.23.0.0.0 DBCS EBS Version 12.1.3 Steps: Fetch the Current Details of Source Database: Check TDE Encryption details on source 11g database. select * from   v$encryption_wallet; WRL_TYPE -------------------- WRL_PARAMETER -------------- STATUS ------------------ file /u01/app/oracle/product/11.2.0.4/dbhome_1/admin/PROD/wallet CLOSED Below steps required only if TDE is present. Connect to 11g Database Server Create Directory  mkdir -p   /u01/app/oracle/product/11.2.0.4/dbhome_1/admin/PROD/wallet Open the encryption wallet on 11g server sqlplus '/as sysdba' SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "anything"; System altered. SQL>   select * from   v$encryption_wallet; WRL_T...