Switchover using traditional manner – Without DG Broker approach (Manual database Switchover) Preparation before switchover: (Pre-Work) (1)Check both Primary and standby databases in Sync , there is no archive log gap…. Read more »
Data guard switchover physical standby- Switchover using DataGaurd Broker- Follow given steps to switchover databases through data guard broker dgmgrl. (1)Login to primary & standby hosts and . oraenv to… 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 »