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.

1)  Find out dependant objects.

Read More »

Advertisements

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.

Read More »