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 »
Category: RMAN
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 »
How to change RMAN backup location
How to Change RMAN backup location If you want to change your database RMAN Backup configuration please follow below steps: NOTE: Database must be in archivelog mode. If database not in archive log… Read more »
Database RMAN backup report
OEM Management view: Whenever OEM Grid control is being practiced to monitor a majority of your databases and whenever RMAN is being used to take backup of the databases ‘either… Read more »
Cross-Platform Database Migration
Cross Platform Database Migration Window’s To Linux: 1-To convert the database from one platform to another, the endian format of both databases should be the same. So as a first… Read more »