Datapatch apply on 12c Databases after patch
Datapatch apply steps on 12c Databases after patch- Run the below steps to apply datapatch for all the databases running on 12C RDBMS home. Set environment . oraenv 12c_DBname Sqlplus… Read more »
Author Archives: Pankaj Yadav
Catbundle apply after RDBMS 11g Patching
Catbundle apply steps after RDBMS 11g Patching 1: Catbundle apply and post installation script implementation – Run the below steps to apply post install scripts and catbundle for all the… Read more »
database switchover traditional manner
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 »
Physical standby database switchover through DG Broker
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 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 »
Oracle database Cloning
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 how to purge oracle trace files
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 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
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
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 »