A physical standby database is created from an existing other database. This other database will then be the primary database.…
Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature was introduced in Oracle…
ORA-19905: log_archive_format must contain %s, %t and %r During a go-live when a 10.2.0.4 database was being readied for a…
Here are some scripts related to Tables/Indexes . Tabs w/ Questionable Inds TABLES WITH QUESTIONABLE INDEX(ES) NOTES: Owner – Owner…
The following is a basic steps for an automatic start up and shutdown Oracle instances during UNIX system startup or…
PL/SQL Procedure to Automatically Backup ControlFile to trace whenever you are shutting down or starting up the database. ‘ALTER DATABASE…
As read originally on Coskan’s Blog When i got errors from database and complaining about “what happened again” my colleagues…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
A. Delete DB Control Objects: Option 1. Delete DB Control Configuration Files using EMCA scripts Option 2. Delete DB Control…