You want to convert your existing non-ASM files to ASM filesfor the database PROD. Which method or command would you use to accomplish this task?
A.
the CONVERT command of RMAN
B.
Data Pump Export and Import
C.
Conventional export and import
D.
The BACKUP .. RESTORE command of RMAN
E.
The BACKUP AS COPY DATABASE .. command of RMAN
Explanation:
If you have enough disk space that you can have both your entire non-ASM database and your ASM disk group on disk at the same time, you can do the migration directly without using tapes.
1. 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’;
REF.: Oracle(r) 10g Backup and Recovery Advance User’s Guide, 16-2