VLDB – Migration

migrating to new server – datapump export

DB Migration for Oracle 

File Copy + Upgrade Script
DB link + Direct Load Insert (Entire)
DB link + Direct Load Insert (Delta)
DataGuard + Upgrade Script
DataGuard + Transportable Tablespace

Reduced Business Downtime

[Oracle-l] Database upgrade for big database

1. Create standby server for 10g on new server
2. Install Oracle 11g with all required Paches
3. stop the primary and activate the Standby server
4. Upgrade the Standby server with 11g Software already installed

This process will save in installing Oracle 11g and performing any datapump export/import and save big downtime to few hours
only while upgrading the environment.

datapump import (impdp) using NETWORK_LINK option

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.