Career transition from on-premises DBA to cloud dba
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 »
Category: RMAN
Oracle golden gate step-by-step configuration
To be addressed : 1.How to enable monitoring 2.Regular maintenance tasks 3.DB refresh , How to handle it ? Prerequisites : Source : Establish network connectivity between source and target… Read more »
Oracle Golden Gate Overview & Components
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 »
Script to Check RMAN Backup status
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 the Owners of SQL Server Agent Jobs Using TSQL
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 »
Tablespace usage monitoring script
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
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
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 How To enable compression of backupset
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 »
RMAN incremental backup
RMAN incremental backup RMAN Command rman> report need backup; The report need backup command tells you that you must back up which all database files to comply with your retention… Read more »