Mir Sayeed Hassan – Oracle Blog

How to use the flashback operation in Oracle database 19c

Check the status of database

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

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

Check flashback is enable or not.

SYS> select flashback_on from...

How to export the data of Physical standby database (DataGuard) using the network link.

Note: Consider your production database has primary and standby database, during the business hours it is not recommend to take the export of data from the primary database due to the performance issue might occur., Therefore we can perform the export of data from the Physical...
Read more..

How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C

Note: In Multitenant database., You will have the container database along with one or more PDB database.

Check the database status

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

NAME      DATABASE_ROLE    VERSION
-------------------------------------
ORA19CDB... 
Read more..			

How to generate the IOPS report in Oracle database 19c

Note: The report is created as per the requirement of the client from the databaase., Usually we should do it on regular basis for the analysis of the data.

Check the database

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

NAME OPEN_MODE VERSION
--------- --------------------... 
Read more..			

Find out the method to delete the existing/old log files automatically  by using the ADRCI Utility in Oracle 19C Database.

Brief: To delete the existing/old log files from the database, there are 2 method to perform this operation

1-Manual

Traditional method to delete the old log files (alert, trace,.xml,.aud files) as discuss in below link.

How big organizations maintain their data and Oracle Database Administrator tasks performed in it.

Here i have highlighter some of the major key points as per the requirement of the interview purpose for the candidates.

Large organizations handle vast amounts of data daily, and maintaining this data efficiently is crucial for operations, decision-making,...