Mir Sayeed Hassan – Oracle Blog

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 in Export (expdp) only & cannot use it for Import (impdp)

Let...
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..			

Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C 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@ora19ctdb ~]$ $ORACLE_HOME/OPatch/opatch... 
Read more..