nerdexam
Oracle

1Z0-027 · Question #56

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine. Following are details for the source database: Database version…

The correct answer is B. Physical migration using Transportable Database C. Logical migration using Oracle Streams. There are several techniques for migrating data to a Database Machine. Migration can be done using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by…

Managing Exadata Database Machine

Question

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine. Following are details for the source database:

Database version: 10.2.0 Byte order: Big Endian HP-UX (64-bit) Database size: 24 TB Storage: ASM with 1 MB allocation unit size Which two are supported migration methods?

Options

  • APhysical migration using ASM online Migration
  • BPhysical migration using Transportable Database
  • CLogical migration using Oracle Streams
  • DLocal migration using Oracle Streams
  • ELogical migration using logical standby

How the community answered

(70 responses)
  • A
    3% (2)
  • B
    79% (55)
  • D
    6% (4)
  • E
    13% (9)

Explanation

There are several techniques for migrating data to a Database Machine. Migration can be done using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by first creating a standby database based on Exadata storage. The standby can be using Exadata storage and the production database can be on traditional storage. By executing a fast switchover, taking just seconds, you can transform the standby database into the production This provides a built-in safety net as you can undo the migration very gracefully if unforeseen issues arise. Transportable Tablespaces (B) and Data Pump may also be used to migrate to Exadata. Any technique used to move data between Oracle Databases can be used with

Topics

#database migration#Transportable Database#Oracle Streams#cross-platform migration

Community Discussion

No community discussion yet for this question.

Full 1Z0-027 Practice