Blog Archives

My book: Oracle Database 12c Backup and Recovery Survival Guide

It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good

Posted in 12c, Backup & Recovery, Books, DBA Career Tips, General, Interview Tips, Others, Questions, Scripts, Tutorials, White Papers

Once again, How to Improve your Oracle Career

The main question about the DBA job I hear all the time is: How can I became a successful DBA? Most of the people that I talk to who have difficulties starting out in their DBA career really have an

Posted in DBA Career Tips, General, Interview Tips, Oracle FAQ

LOGGING or NOLOGGING, that is the question – Part VIII

By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo,

Posted in General, Interview Tips, Monitoring, Questions, Redo Logs, Scripts, Tuning

How to migrate from 32 bit to 64 bit using RMAN?

This procedure can be used for single instance or RAC (9i to 11g): In the 32 bit source server : Start making a full backup of the database including all archivelogs: RMAN> run  {   allocate channel c1 type disk;   allocate channel c2 type

Posted in General, Interview Tips, Migrations, Oracle FAQ, Questions, Tutorials, Upgrade/Migration

Learning and Preparing to a DBA Interview

“The main idea of this article is to help you to prepare to an Oracle DBA Interview and at the same time help you to learn and understand the most important basic points that a good Oracle DBA need to know. “ 

Posted in Interview Tips