OnlineTable Migration

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Online Table Migration using GoldenGate

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I would like to demonstrate a case study of table partitioning and “online migration” in a OLTP system with “near Zero Downtime”.

In such cases, GoldenGate is the best tool to achieve this goal of an on-line migration.

RMAN backup jobs through DBMS_SCHEDULER

It is very easy to create the RMAN backup jobs through DBMS_SCHEDULER.

Benefits of using DBMS_SCHEDLER for RMAN jobs:

For multinode RAC configuration, executing the RMAN jobs through OS cronjobs will fail when the node is not available. While using DBMS_SCHEDULER , the job can be run from serviving instance.
It is easy to maintain the logs at OS level as well as in the database dictionary.
By default execution of the job can be fixed for specific instance using service and can be changed at any time.