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.
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)- A4% (2)
- B2% (1)
- C11% (5)
- D83% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.