PREVENT USERS (SCHEMAS) FROM GETTING DROPPED
The below is the Trigger which is used to prevent the users or schemas from…
VeeraOctober 26, 2014
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
Purging statistics from the SYSAUX tablespace
In Oracle Database, Whenever statistics in the dictionary are modified, old versions of statistics are…
VeeraOctober 26, 2014
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
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
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 backups not storing configure location
RMAN Configured parameters does not get reflected or get changed After configuration of RMAN…
VeeraOctober 24, 2014
RMAN RESTORE VALIDATE – A Proactive Health Check
RMAN RESTORE VALIDATE is the new feature introduced in Oracle 11g to check and verify…
VeeraOctober 24, 2014
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
Migrate database from one RMAN catalog to another RMAN catalog
IMPORT CATALOG is a new feature of RMAN in Oracle 11g. We can move or…
VeeraOctober 24, 2014
Loading ...
Total Users : 1816708
Recent Comments