Today one of our developer accidentally dropped some of application base tables from development instance instead of uat environment. So there was a request re-clone development database from one month old backup which was used for cloning earlier. Simple!! everything was in proper place including datafile backups, archivelog backups, controlfile […]
From version 11g Oracle has come with new enhancement – Flashback Data Archive also known as Oracle Total Recall. With the “Oracle Total Recall” option, Oracle database 11g has been specifically enhanced to track history with minimal performance impact and to store historical data in compressed form to minimize storage […]
Today while creating database on ASM using DBCA I got following error exactly after reaching 4%. After searching on net I found, a workaround of using “custom database” tempalate instead of “general purpos or transaction processing” in dbca. I was not sure about this workaround, and as expected it failed […]
Today I faced very funny issue related to FRA – Flash Recovery Area. Linux guys informed us to clear old files as one of the mount point on database server had reached to its threshold free space. After investigating we found that one of database ORACLE_HOME was 192GB is size. […]
Some days before when I was cloning one of the production database into UAT box, step to open database with resetlogs option failed due to insufficient space in one of the diskgroup. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00344: unable to re-create […]
Writing custom messages in alert log … IS IT POSSIBLE??? Yes it is… We can edit, update or delete alert log entries with any editor, but oracle has a package that does the same work: dbms_system.ksdwrt. We can write our own customized messages in alert.log sitting at SQL*PLUS session using […]
Recently I faced very interesting issue, when user was complaining that he is getting (SCHEMA:TEST1) ORA-01031: insufficient privileges while creating materialized view under different schema (SCHEMA:TEST2) though TEST1 has DBA role assigned. For TEST1: SQL> select * from dba_sys_privs where grantee=’TEST1′; GRANTEE PRIVILEGE ADM —————————— —————————————- — TEST1 UNLIMITED TABLESPACE […]
Many a time we DBA’s face issues as we cannot drop other schema’s database link with schema qulalifier Since dot is allowed in the database link name. Oracle check for a dblink with the given name under the same schema. For performing this task we need to connect to owner schema […]
I always see the following messages in Alertlog , was curious to know the reason behind it… Wed Jun 25 06:35:22 2014 SUCCESS: diskgroup DATA2 was mounted SUCCESS: diskgroup DATA2 was dismounted SUCCESS: diskgroup DATA2 was mounted SUCCESS: diskgroup DATA2 was dismounted SUCCESS: diskgroup DATA2 was mounted SUCCESS: diskgroup DATA2 […]
Recently I was having issue in our test environment, users were complaining that database is not responding for any queries, it appears to be in hanged state. After checking database for possible causes for performance issues, I found following: SQL> select event,count(0) from v$session where username is not null and […]
Adityanath's Oracle Blog 