Oracle Golden Gate interview questions and answers Q: What is Oracle GoldenGate? A: Oracle GoldenGate is a real-time data integration and replication tool that allows you to capture and deliver… Read more »
Introduction to Databases: What is a database? What are the different types of databases? Why are databases important in today’s world? Relational Databases: What are relational databases? How do they… Read more »
Transitioning from an on-premises DBA role to a cloud DBA role can be a rewarding career move as more and more companies are adopting cloud technology. Here are some steps… Read more »
Introduction to Oracle GoldenGate Oracle Goldengate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms. Oracle GoldenGate Architecture allows to replicate selected data, transactional… Read more »
This script will provide you to check the current running RMAN backup status and backup history whether its completed/running or failed with any issue. set line 190 col STATUS format… Read more »
Find out who are the owners of the SQL Server agent jobs with the help of below script. SELECT J.name AS [Job Name] ,L.name AS [Job Owner] FROM msdb.dbo.sysjobs_view J… Read more »
set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »
What is datapump in oracle Data Pump: Data pump is a utility provided by Oracle to export data and/or structure from a database into a binary file called as dump… Read more »
How to change RAC database NoarchiveLog Mod to Archivelog mode Login to one of the nodes (i.e. linux Node1) and disable the cluster instance parameter by setting cluster_database to FALSE… Read more »
RMAN To enable compression of backupset RMAN – How to enable compression of backupset Backup in RMAN can be compressed when they are being created. Using the following command one can… Read more »