Which two methods or commands would you use to accomplish this task?

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?

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *