Oracle ASM Unable to remove ASM Diskgroup from the ASM InstanceSCENARIO I Was not able to remove the newly added ASM diskgroup ASM_DISK1 from ASM…VeeraOctober 26, 2014
General PREVENT USERS (SCHEMAS) FROM GETTING DROPPEDThe 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 DISKINTRODUCTION / OVERVIEW Data can be migrated from one SAN disk to another in…VeeraOctober 26, 2014
General Purging statistics from the SYSAUX tablespaceIn 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 DatabaseResync the standby database using an incremental RMAN backup from the primary database. Advantages: …VeeraOctober 26, 2014
Oracle ASM How to resolve Could not validate ASMSNMP password due to following error- “ORA-01031: insufficient privileges”Could not validate ASMSNMP password due to following error - "ORA-01031: insufficient privileges" (more…)VeeraOctober 26, 2014
RMAN RMAN backups not storing configure locationRMAN Configured parameters does not get reflected or get changed After configuration of RMAN…VeeraOctober 24, 2014
RMAN RMAN RESTORE VALIDATE – A Proactive Health CheckRMAN RESTORE VALIDATE is the new feature introduced in Oracle 11g to check and verify…VeeraOctober 24, 2014
RMAN Restoring With RMAN and Using The DATABASE RECOVERY ADVISOR (DRA)The Database Recovery Advisor (DRA) is a new feature introduced in Oracle 11g to help…VeeraOctober 24, 2014
Recent Comments