Dear Readers, In this article, we will see SQL Server Database Architecture. SQL Server MDF Files In the SQL Server Primary Data Files are the basic data files which are related to the database for the storing and supervision of the information. MDF file in… Read More
Dear Readers, In this article, we will see the following Log Miner Configuration for Oracle Database. We can easily track history of activity on a database from archived redolog files using log miner. 1. ENABLE SUPPLEMENTAL LOGGING FOR THE DATABASE
|
1 |
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; |
|
1 2 3 4 |
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE; SUPPLEME -------- YES |
2. CHECK THE… Read More
Dear Readers, In this article, we will see GoldenGate 12c setup for Oracle Container Database. Separate user for Extract and Replication need to be created. User for Extract should be common user connected to Root Container in order to interact with the logmining server. For… Read More
Dear Readers, In this article, we will see Installation and Configuration of GoldenGate 19C on Oracle RAC . Source: 2-Node RAC Oracle 19c Database Source Server has a NFS Drive: /goldengate Target: Oracle 19c Database Plan: Install GoldenGate on both the machine and a soft… Read More
Dear Readers, In this article, we will see the Level of work. L1 Level Jobs Installation Postgres software as per standard document. Space monitoring for Table space, File system on Postgres db system etc. Logs monitoring for Backup, Index rebuilding and other maintenance jobs. Checking… Read More
Dear Readers, In this article, we will see the step by step Oracle 12c RAC Installation, we will create 2 RAC nodes with below configuration. Software’s used in the activity: – 1.Oracle Virtual Box:- https://www.virtualbox.org/wiki/Downloads 2.Oracle Linux 6.4 Image ISO: – http://yum.oracle.com/oracle-linux-isos.html 3.Oracle 12cR2 Grid/Database … Read More
Dear Readers, In this article,we will see Creating a MySQL DB Instance in Amazon RDS (Relational Database Service) . Implementation steps : Create MySQL DB Instance. Download connect.php file. open connect.php file and replace username, password, hostname and DB name. Create S3 Bucket. Upload connect.php file… Read More
Dear Readers, In this article,we will see brief explanation regarding to RDS(Relational Database Service). What is AWS RDS? Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It… Read More
INTRODUCTION TO ORACLE APPS DBA Oracle APPS DBA: What is Application Database? The Database which is storing the data’s from application (say front end ) that is EBS (Enterprise Business suite) is said to be Application Database . What is EBS? Oracle E-Business Suite is… Read More
