Mir Sayeed Hassan – Oracle Blog

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

How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C

Brief: – In case if you use existing dumpfile name, you will get an error as its already exists, To overcome this use this REUSE_DUMPFILES=YES parameter to overwrite the existing dumpfile name without error.

– By default is REUSE_DUMPFILES=NO

Check the database...
Read more..

How to export the dumpfile default directory location in Oracle database 19C

Check the database version

SYS> select name, status, open_mode, version from V$database, v$instance;

NAME       STATUS    OPEN_MODE       VERSION
----------------------------------------------
ORA19CDB   OPEN     READ WRITE     19.0.0.0.0

The name of the...
Read more..

How to use the METRICS Parameter by using expdp in Oracle database 19C

Brief: – This will give the information about the number of objects associated along with the elapsed time.
– Default METRICS=N, To apply this Parameter use METRICS=Y

Check the database version

SYS> select name, status, open_mode, version from V$database,... 
Read more..			

How to exclude the statistics, table_statistics, index_statistics when export of dumpfile in Oracle database 19C

Check the database version

SYS> select name, status, open_mode, version from V$database, v$instance;

NAME         STATUS     OPEN_MODE        VERSION
---------------------------------------------------
ORA19CDB     OPEN       READ WRITE... 
Read more..