Author: Andrey Goryunov

Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.

Sometime in the near future… Finally, that day came. He was the last human being to stay on Twitter with the “others”, and he did a good job trying to keep up with “them”. But today is going to be…

Oracle Database 12c brought more than 500 new features, and many of them are related to Data Guard enhancements. Along with overall improvement of Data Guard Broker, support for cascaded standby databases finally came with the release. Moreover, cascaded destinations…

Why do we love data? Because it brings us INFORMATION, a central element in today’s computer-driven world. One of the countless sources of data is an OEM repository. Gathered metrics placed together for monitored targets can become priceless in a…

The predefined metric “Dump Area Used (%)” can monitor space consumption for dump destination of oracle database. However, it just triggers on percentage occupied, and if there are several databases on the host using the same file system for trace…

The new release of #EM12c came with advanced EM CLI, providing interactive and script modes to enhance the standard command line functionality. EM CLI includes Jython interpreter and all verbs presented as functions, which allows the use of verb arguments…

Silent installation always attracts by its simplicity and power, the new release 2 of EM 12c proves it, making installation
smooth and straightforward. Before we start the installation, it is very important to make sure all prerequisites are satisfied
to avoid any unpredictable errors during the process. Let’s have a look.

I took debug of duplication and figured out that RMAN internally executes procedure dbms_tts.transport_set_check preventing any further copy operations if tablespaces do not satisfy TTS requirements. Now the plot thickens and considering RMAN shows everything that it does in log file I decided to repeat the same steps but one by one and manually. Let’s get into it.

The following story about DBA_JOBS_RUNNING and DBA_SCHEDULER_RUNNING_JOBS is based on real events.

If you support Oracle RDBMS 11.2.0.2 and want to zero downtime applying patches to databases then it is time to have a look at new possibility of Online Patching delivered with 11.2.0.2 version and described here.