nerdexam
Oracle

1Z0-997 · Question #7

You are responsible for migrating your on premises legacy databases on 11.2.0.4 version to Autonomous Transaction Processing Dedicated (ATP-D). In Oracle Cloud Infrastructure (OCI). As a solution…

The correct answer is C. Use Oracle GoldenGate replication to keep on premises database online during migration. D. Convert on-premises databases to PDB, upgrade to 19c, and encrypt Migration. Explanation/Reference: Autonomous Database is an Oracle Managed and Secure environment. A physical database can't simply be migrated to autonomous because: - Database must be converted to PDB, upgraded to 19c, and encrypted - Any changes to Oracle shipped privileges, stored…

Integration

Question

You are responsible for migrating your on premises legacy databases on 11.2.0.4 version to Autonomous Transaction Processing Dedicated (ATP-D). In Oracle Cloud Infrastructure (OCI). As a solution architect, you need to plan your migration approach. Which two options do you need to implement together to migrate your on premises databases to OCI?

Options

  • AUse Oracle Data Guard to keep on premises database always active during migration
  • BRetain changes to Oracle shipped privileges, stored procedures or views In the on-premises databases.
  • CUse Oracle GoldenGate replication to keep on premises database online during migration.
  • DConvert on-premises databases to PDB, upgrade to 19c, and encrypt Migration.
  • ERetain all legacy structures and unsupported features (e.g. taw U>Bs) In the onuses databases for migration.

How the community answered

(17 responses)
  • A
    6% (1)
  • B
    12% (2)
  • C
    76% (13)
  • E
    6% (1)

Explanation

Explanation/Reference: Autonomous Database is an Oracle Managed and Secure environment. A physical database can't simply be migrated to autonomous because: - Database must be converted to PDB, upgraded to 19c, and encrypted - Any changes to Oracle shipped privileges, stored procedures or views must be removed - All legacy structures and unsupported features must be removed (e.g. legacy LOBs) GoldenGate replication can be used to keep database online during

Topics

#database migration#GoldenGate#ATP-D#PDB upgrade

Community Discussion

No community discussion yet for this question.

Full 1Z0-997 Practice