1Z0-060 Question #63: Real Exam Question with Answer & Explanation

The correct answer is D: The BACKUP AS COPY DATABASE . . . command of RMAN. On the same platform, migrating from a filesystem to ASM is best achieved using RMAN image copies targeted at an ASM disk group, or by using DBMS_FILE_TRANSFER with the transportable tablespace mechanism.

Question

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task?

Options

ARMAN CONVERT command
BData Pump Export and import
CConventional Export and Import
DThe BACKUP AS COPY DATABASE . . . command of RMAN
EDBMS_FILE_TRANSFER with transportable tablespace

Explanation

On the same platform, migrating from a filesystem to ASM is best achieved using RMAN image copies targeted at an ASM disk group, or by using DBMS_FILE_TRANSFER with the transportable tablespace mechanism.

Common mistakes.

A. The RMAN CONVERT command handles cross-platform migrations by converting datafile formats for endian differences - it is not intended for same-platform filesystem-to-ASM moves where no format conversion is needed.
B. Data Pump Export and Import performs a logical migration by unloading and reloading data objects, which is an unnecessary and slower approach when a physical file copy to ASM on the same platform is sufficient.
C. Conventional exp/imp utilities perform logical data extraction and are a legacy alternative to Data Pump - they are equally inappropriate for a physical storage migration from filesystem to ASM.

Concept tested. Migrating Oracle database files from filesystem to ASM

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/migrate-db-to-asm.html

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice