Some time ago I published an article about creating a RMAN backup using Commvault. See: https://technology.amis.nl/2018/03/01/creating-rman-backups-using-commvault/ . In this article I describe how to execute a crash recovery using Commvault. You need to do a crash recovery when you lost all your datafiles, redolog files, control files and spfile. For example […]
Herman Buitenhuis
Oracle Consultant at AMIS
Sometimes the cause of a TNS error is ….
A couple of months ago one of my customers had a failed data ware house report. There was a ORA-12592 (TNS) error message generated. I turned out not to be the only TNS error. During a couple of weeks similar TNS-errors were generated. Not only the ORA-12592 error but also […]
How to make a time consistent export dump using the expdp datapump utility
In those old days when there was the exp utility we made a time consistent export dump by using the consistent=y parameter. But today, in fact a couple of years already, we mostly use the expdp datapump utility. How should we make a time consistent export using datapump? For that […]
Sqlnet tracing during nightly hours…
A TNS error at night… Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had […]
How to stop running RMAN jobs in OEM Grid Control
Life became very easy after Oracle’s invention of OEM Grid Control. That is what Oracle promised us when they invented it. A couple of months ago one of my colleagues asked me to schedule backup jobs. In the past I made very nice OS scripts in order to make a […]