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.
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
D, E
http://docs.oracle.com/database/121/OSTMG/asmfiles.htm#OSTMG94229
http://docs.oracle.com/database/121/OSTMG/toc.htm
D E
It is A & D:
A because:
One use of CONVERT is to transport a tablespace into a database stored in Oracle Automatic Storage Management (Oracle ASM). Native operating system commands such as Linux cp and Windows COPY cannot read from or write to Oracle ASM disk groups.