Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…
Tag oracle
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…
Oracle GoldenGate will now be more closely coupled with Oracle database. And it is by far the best heterogenous replication…
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…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
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…
ADDING TAF SERVICE FOR SCAN _____________________________ ####### As “Oracle” (owner of database) user test – name of database test1- instance…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…
Original Article : http://searchoracle.techtarget.com/tip/Oracle-vs-SQL-Server-Why-Oracle-wins A brief comparison between Oracle and SQL Server. Oracle comes out leaps and bound ahead in this…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…
A brief comparison between Oracle and SQL Server. In my view, Oracle comes out ahead in this comparison. Platform dependancy…
Oracle 11gR2 is a major release upgrade from 10gR2 and 11gR1 both. Many previous parameters like user_dump_dest etc have been…