Have a sneak peek of my book

Do you want to have a sneak peek of my book “Oracle 12c Backup and Recovery Survival Guide” I wrote with my good friend Aman Sharma? If yes, you can download the chapter 1 of the book as a demo Continue reading

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, Continue reading

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 Continue reading