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’;
Reference: Migrating Databases To and From ASM with Recovery Manager
DE
A. RMAN CONVERT.
re. http://www.dba-oracle.com/t_rman_convert_file_asm.htm
D. RMAN BACKUP AS COPY DATABASE
re. http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmasm.htm#BRADV12000
Thus, RMAN A,D
Not E: re. http://www.dba-oracle.com/t_dbms_file_transfer.htm
DBMS_FILE_TRANSFER package is available since Oracle 10gR1 and since 10gR2 supports transferring files as follows: ASM->ASM; FS->ASM; FS->FS; FS->ASM
Given “on same platform” in question, TTS would not be necessary.
AD