Logical Standby Skip DML Replication of a Table to Logical Standby site and Re-Instantiate it ENVIRONMENT DATABASE - ORACLE 11gR2 11.2.0.3.0 PRIMARY DATABASE - PRODDB (more…)VeeraOctober 26, 2014
General Recreating the Oracle Inventory files in Oracle 10g and Oracle 11g Normally, an oraInventory directory will be created in the system when we run the Oracle…VeeraOctober 26, 2014
RMAN RMAN ACTIVE DUPLICATION ASM TO ASM RMAN Active Duplication an Overview: It is a new feature in Oracle 11g where cloning…VeeraOctober 26, 2014
General Table De-Fragmentation to Reclaim the Space and Different Methods of De-Fragmentation ENVIRONMENT ============= SERVER NAME SERVER1 DATABASE NAME TESTDB (more…)VeeraOctober 26, 2014
Oracle ASM Unable to remove ASM Diskgroup from the ASM Instance SCENARIO I Was not able to remove the newly added ASM diskgroup ASM_DISK1 from ASM…VeeraOctober 26, 2014
General PREVENT USERS (SCHEMAS) FROM GETTING DROPPED The below is the Trigger which is used to prevent the users or schemas from…VeeraOctober 26, 2014
Oracle ASM MIGRATE DATA FROM OLD ASM DISK TO NEW ASM DISK INTRODUCTION / OVERVIEW Data can be migrated from one SAN disk to another in…VeeraOctober 26, 2014
General Purging statistics from the SYSAUX tablespace In Oracle Database, Whenever statistics in the dictionary are modified, old versions of statistics are…VeeraOctober 26, 2014
Oracle ASM Convert a Non ASM database to ASM database in Oracle 11gR2 1. Install the ASM Binaries. 2. Configure the ASM and create 2 Diskgroups namely…VeeraOctober 26, 2014
RMAN How to Recover Standby Database from a Missing Archive Log by applying the Incremental backup from Production Database Resync the standby database using an incremental RMAN backup from the primary database. Advantages: …VeeraOctober 26, 2014
Recent Comments