How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB Brief about this concept – I would like to configure the data guard with the cascading standby database on Oracle Database 19C. – To perform this we should have configure 1 Primary database, 2 Standby database Flow should be like this Read More

How to validate the database files for backup purpose in Oracle 19C Database. This is to validate the database files, in case if the backup is failing due to the any corruption of datafiles or control files etc. Issue the below command RMAN> validate database; Starting validate at 16-FEB-25 using target database control file instead… Read More

How to perform the export a percentage (%) of data from the schema tables in Oracle 19C Database Brief: Consider i have a requirement of the export of data in the form of percentage, Such as i need to export only 50% or 25% of data from my tables The parameter: SAMPLE can be used Read More

Apply Patching Oracle Database 19C release Update on OCT 2024 19.25 (p36916690) On Grid Infrastructure Standalone Server. Check the status of Database [oracle@Paymentdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Feb 12 14:27:08 2025 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected… Read more..

APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) ON Grid Infrastructure 19C DATABASE Check the status of database SQL> select instance_name, version, open_mode from v$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————————————— ora19ctdb1 19.0.0.0.0 READ WRITE Check existing OPatch applied. [oracle@payment-dbs… Read more..

Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ———————————— ora19cdb 19.0.0.0.0 READ WRITE SQL> show pdbs CON_ID… Read more..