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 »
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 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 »
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 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 »