Listing Page

A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...

In this article I will show you how undo retention time is set when we have an Undo tablespace with autoextend enabled and also disabled. I will give you rules in order to remember this easily: Rule-...

This article is focused on Monitoring and Troubleshooting of Data Guard configuration using the GUI method i.e. Enterprise manager 12c(cloud control), Here we will go through with Data Guard Administr...

This article is focused on how to monitor and troubleshoot the Data Guard when managing with Broker. There are many ways to monitor Data Guard such as using Generic/Traditional views, Using Grid contr...

How to know if I will be able to use successfully my RMAN Backup? that's is a question performed for many DBA's, RMAN also provide functions to validate corrupted blocks in the database, but also it p...

Role transitions are no more complicated starting from Oracle Database 12c. Role transition, basically, comprises switchover and failover. Using the previous release role transitions, in order to perf...

Introduction You’ve probably been reminded very often that force logging is important in a Data Guard configuration and have also been warned about the dramatic consequences that might happen in a dat...

Some days ago Michael Abbey invited me to a dinner (René Antunez Oracle ACE, also was there) in his apartment in Ottawa. He is such an admirable person, he is also an Oracle ACE and he likes to share ...