Flashback the Database Using SCN
Bringing Back The Database to Previous State after Importing a schema Using Flashback Technology…
VeeraOctober 26, 2014
FULL DATABASE RESTORE AND RECOVER USING RMAN
SCENARIO Recovering the Database when database is fully crashed and no files are available using…
VeeraOctober 26, 2014
Switchover and Switchback with Logical Standby
SWITCHOVER IN LOGICAL STANDBY DATABASE - Oracle 11gR2 11.2.0.3.0 Operating System - Oracle Enterprise Linux…
VeeraOctober 26, 2014
PREVENT USERS (SCHEMAS) FROM GETTING DROPPED
The below Trigger is used to prevent users and schemas from Getting Dropped Mistakenly, Create…
VeeraOctober 26, 2014
Effect of Creating Tablespace / Datafile on Primary when Logical Standby in Place (ORA-01119)
Effect of Creating Tablespace / Datafile on Primary when Logical Standby in Place (ORA-01119) SYMPTOMS…
VeeraOctober 26, 2014
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
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 ACTIVE DUPLICATION ASM TO ASM
RMAN Active Duplication an Overview: It is a new feature in Oracle 11g where cloning…
VeeraOctober 26, 2014
Table De-Fragmentation to Reclaim the Space and Different Methods of De-Fragmentation
ENVIRONMENT ============= SERVER NAME SERVER1 DATABASE NAME TESTDB (more…)
VeeraOctober 26, 2014
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
Loading ...
Total Users : 1822663
Recent Comments