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?
A.
RMAN CONVERT command
B.
Data Pump Export and import
C.
Conventional Export and Import
D.
The BACKUP AS COPY DATABASE . . . command of RMAN
E.
DBMS_FILE_TRANSFER with transportable tablespace
Explanation:
A:
1. Get the list of all datafiles.
Use the convert datafile command to convert the datafile from the file system 2.
to ASM.
Note: RMAN Backup of ASM Storage
There is often a need to move the files from the file system to the ASM storage and vice versa. This may come
in handy when one of the file systems is corrupted by some means and then the file may need to be moved to
the other file system.
D: Migrating a Database into ASM
* To take advantage of Automatic Storage Management with an existing database you must migrate that
database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using
RMAN for your primary backup and recovery strategy.
* Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT ‘+DISK’ TAG ‘ORA_ASM_MIGRATION’;
Migrating Databases To and From ASM with Recovery Manager