nerdexam
Oracle

1Z0-062 · Question #218

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?

The correct answer is D. by using RMAN. RMAN is the correct tool to migrate an Oracle database from file system storage to ASM because it can copy physical database files directly to ASM disk groups.

Managing Database Storage Structures

Question

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?

Options

  • Aby using a transportable database
  • Bby using the Database Upgrade Assistant (DBUA)
  • Cby using Data Pump
  • Dby using RMAN

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    13% (4)
  • C
    6% (2)
  • D
    77% (24)

Why each option

RMAN is the correct tool to migrate an Oracle database from file system storage to ASM because it can copy physical database files directly to ASM disk groups.

Aby using a transportable database

Transportable database is used to move a database across different platforms or endianness configurations, not to migrate the physical storage layer from file system to ASM on the same server.

Bby using the Database Upgrade Assistant (DBUA)

DBUA (Database Upgrade Assistant) is designed specifically for upgrading the Oracle Database software version and has no capability to migrate physical storage from file system to ASM.

Cby using Data Pump

Data Pump works at the logical level, exporting and importing schema objects and row data, and cannot handle physical file migration of datafiles, control files, or redo logs to ASM.

Dby using RMANCorrect

RMAN can migrate a database from file system to ASM by using BACKUP AS COPY to copy all physical files (datafiles, control files, online redo logs) to an ASM disk group destination, then using SWITCH DATABASE TO COPY to make ASM the active storage location - this is the Oracle-supported physical storage migration method.

Concept tested: Migrating Oracle database physical storage from file system to ASM

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

Topics

#ASM migration#file system storage#RMAN#storage migration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice