nerdexam
Oracle

1Z0-485 · Question #31

Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

The correct answer is A. using GoldenGate C. using Data Guard Physical Standby. Data integration technologies such as Oracle GoldenGate or Oracle Data Integrator can be used to migrate, and if necessary transform data. Typically, such environments provide a high degree of flexibility, along with a productive way of defining and implementing the required…

Database Software on Exadata

Question

Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

Options

  • Ausing GoldenGate
  • Busing SQL Developer migration tools
  • Cusing Data Guard Physical Standby
  • Dusing cross-platform transportable tablespaces
  • Eusing incremental cross-platform RMAN restore

How the community answered

(23 responses)
  • A
    74% (17)
  • B
    9% (2)
  • D
    13% (3)
  • E
    4% (1)

Explanation

Data integration technologies such as Oracle GoldenGate or Oracle Data Integrator can be used to migrate, and if necessary transform data. Typically, such environments provide a high degree of flexibility, along with a productive way of defining and implementing the required data integrations and transformations. Also, these technologies are often used to facilitate data migration while the source system continues to run. If your application service-level agreements permit little or no down time, you can use an Oracle Data Guard logical standby database to replicate the database on Database Machine, and track and merge the changes while the source database continues to run.

Topics

#database migration#GoldenGate#Data Guard Physical Standby#minimal downtime

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice