Posted by Mir Sayeed Hassan on March 30th, 2025
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.
Read more..
Posted in DBA Administration | No Comments »
Posted by Mir Sayeed Hassan on March 30th, 2025
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,...
Read more..
Posted in Interview Q & A | No Comments »
Posted by Mir Sayeed Hassan on March 9th, 2025
How to Manage the resource usage with concurrent job limit for each pluggable database using the Oracle Datapump in Oracle 19C
Brief: The parameter “max_datapump_jobs_per_pdb” is controls the maximum number of concurrent session in Data Pump jobs for each pluggable database.
Impact on this parameter: If you set this parameter to high value...
Read more..
Posted in Datapump (Expdp/Impdp) | No Comments »
Posted by Mir Sayeed Hassan on February 16th, 2025
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
Posted in DataGuard (DR) | Comments Off on How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB
Posted by Mir Sayeed Hassan on February 16th, 2025
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..
Posted in RMAN | Comments Off on How to validate the database files for backup purpose in Oracle 19C Database.
Posted by Mir Sayeed Hassan on February 12th, 2025
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)
Posted in Datapump (Expdp/Impdp) | Comments Off on How to perform the export a percentage (%) of data from the schema tables in Oracle 19C Database