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.
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)- A3% (1)
- B13% (4)
- C6% (2)
- D77% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.