nerdexam
Oracle

1Z0-060 · Question #63

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?

The correct answer is D. The BACKUP AS COPY DATABASE . . . command of RMAN E. DBMS_FILE_TRANSFER with transportable tablespace. 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.

New Features for Storage

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

How the community answered

(47 responses)
  • A
    4% (2)
  • B
    2% (1)
  • C
    11% (5)
  • D
    83% (39)

Why each option

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.

ARMAN CONVERT command

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.

BData Pump Export and import

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.

CConventional Export and Import

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.

DThe BACKUP AS COPY DATABASE . . . command of RMANCorrect

The RMAN 'BACKUP AS COPY DATABASE' command creates physical image copies of all datafiles and can write them directly to an ASM disk group destination, performing a physical migration without the overhead of logical export and import.

EDBMS_FILE_TRANSFER with transportable tablespaceCorrect

DBMS_FILE_TRANSFER can copy datafiles from the filesystem into an ASM disk group, and when used alongside the transportable tablespace feature, provides a supported method for moving tablespace-level storage to ASM on the same platform.

Concept tested: Migrating Oracle database files from filesystem to ASM

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

Topics

#ASM migration#RMAN BACKUP AS COPY#transportable tablespace#DBMS_FILE_TRANSFER

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice