One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
Tag 10gR2
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor TNS-12541: TNS:no listener TNS-00511: No listener ERROR: ORA-12560:…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…