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… Read more..

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