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 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 »
Oracle database cloning step by step What is Cloning? Database Cloning is a procedure that can be used to create an identical copy of the existing Oracle database. DBA’s occasionally… Read more »
ADRCI – Auto Purge Old Trace and Incident files How to purge Oracle trace files through adrci What is ADRCI? ADRCI is a new feature introduced from 11G onwards…. 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 »
ORA-28003, ORA-20002 while changing password Error: While changing user password ORA-28003 and ORA-20002 raised. sys@prod1>alter user DEVTEST identified by oracleworlds; alter user DEVTEST identified by oracleworlds * ERROR at line 1: ORA-28003:… Read more »
How to get table and index DDL in Oracle? To get all table and indexes for the EDS table, we execute dbms_metadata. get_ddl, select from DUAL, and providing all required… 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 »
Database and server details Report from OEM: 1- How do get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties WHERE target_type = ‘oracle_database’ AND property_name… 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 »