Many a times to save cost in building a DR solution for a certain application; you have to create a…
Tag 10g
We had a new Oracle installation on an AIX 6.1 Power7 server. Our organization doesn’t have an AIX admin. So…
Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
The various security mandates these days required a lot of auditing on the database. Though there are a host of…
Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…
SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> drop database; drop…
While trying to troubleshoot an application connectivity issue today along with a developer I faced an interesting situation. We had…
Working on creating a muti-master replication for a production system. Each database needs to be active and replicate changes back…
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Just found an amazing monitoring tool for Oracle Databases. All it needs is an Oracle client installed on your workstation.…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…