Databases Reference
In-Depth Information
RMAN Approach
The RMAN approach is the easiest when converting files to and from the ASM disk groups. Follow these steps:
1.
Connect to RMAN.
2.
Issue the convert command to convert the data file users.283.790482893 on ASM to a file
system:
RMAN> convert datafile '+DATA/idb1/datafile/users.283.790482893' format '/u01/oradata/%u';
Starting conversion at target at 18-AUG-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input file name=+DATA/idb1/datafile/users.283.790482893
converted datafile=/u01/oradata/0rniv31f
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
Finished conversion at target at 18-AUG-12
3.
Catalog the new file just created. Since you used %u as the file name, RMAN will generate a
unique name not so easily recognizable. Instead of trying to type the exact name, you can
ask RMAN to read all the files:
RMAN> catalog start with '/u01/oradata';
searching for all files that match the pattern /u01/oradata
List of Files Unknown to the Database
=====================================
File Name: /u01/oradata/0rniv31f
4.
RMAN will ask you to confirm. Enter YES:
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oradata/0rniv31f
5.
At this time the database does not know about the file you just moved. You can let the
database know about it by using the
switch
command. But first you have to offline the file:
RMAN> alter database datafile 6 offline;
Statement processed
6.
Switch the file to copy:
RMAN> switch datafile 6 to copy;
datafile 6 switched to datafile copy "/u01/oradata/0rniv31f"
