Copy controlfiles / datafiles from filesystem to ASM

To copy the control files to ASM:


SQL> select name from v$controlfile;


NAME
--------------------------------------------------------------------------------
/dba/lab/backup/LABDB/control01.ctl


SQL> shutdown immediate;
SQL> startup nomount;

RMAN> restore controlfile to '+LAB_DG' from '/dba/lab/backup/LABDB/control01.ctl';


    Starting restore at 28-JAN-10 12:56:15
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=66 device type=DISK


    channel ORA_DISK_1: copied control file copy
    Finished restore at 28-JAN-10 12:56:17




ASMCMD [+LAB_DG/LABDB/CONTROLFILE] > ls -ltr


    Type         Redund  Striped  Time             Sys  Name
    CONTROLFILE  UNPROT  FINE     JUN 28 12:00:00  Y    current.310.755009777




Modify your init.ora and point the control_file=+LAB_DG/LABDB/CONTROLFILE/current.310.755009777.  You can multiplex with the same steps above.

To copy datafiles to ASM:

col name format a72
set linesize 132


select file#, name, bytes/1024/1024 as MB from v$datafile;


     FILE# NAME                                                                             MB
---------- ------------------------------------------------------------------------ ----------
         1 /tmp/dba/LABDB/lab_D-LABDB_I-4162359530_TS-SYSTEM_FNO-1_01mf4a6a             710
         2 /tmp/dba/LABDB/lab_D-LABDB_I-4162359530_TS-SYSAUX_FNO-2_02mf4a6a             670
         3 /tmp/dba/LABDB/lab_D-LABDB_I-4162359530_TS-UNDOTBS1_FNO-3_03mf4a6a            70
         4 /tmp/dba/LABDB/lab_D-LABDB_I-4162359530_TS-USERS_FNO-4_05mf4a6b                5




rman target /


Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jun 28 13:21:15 2011


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


connected to target database: LABDB (DBID=4162359530, not open)


RMAN> copy datafile 1 to '+LAB_DG';


Starting backup at 28-JAN-10 13:21:46
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=96 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/tmp/dba/LABDB/lab_D-LABDB_I-4162359530_TS-SYSTEM_FNO-1_01mf4a6a
output file name=+LAB_DG/rmandr/datafile/system.311.755011307 tag=TAG20110628T132147 RECID=22 STAMP=755011309
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 28-JAN-10 13:21:50


RMAN> copy datafile 2 to '+LAB_DG';
RMAN>  copy datafile 3 to '+LAB_DG';
RMAN> copy datafile 4 to '+LAB_DG';


RMAN> switch datafile 1 to copy;


datafile 1 switched to datafile copy "+LAB_DG/rmandr/datafile/system.311.755011307"


RMAN> switch datafile 2 to copy;
datafile 2 switched to datafile copy "+LAB_DG/rmandr/datafile/sysaux.312.755011327"

RMAN> switch datafile 3 to copy;
datafile 3 switched to datafile copy "+LAB_DG/rmandr/datafile/undotbs1.313.755011337"


RMAN> switch datafile 4 to copy;
datafile 4 switched to datafile copy "+LAB_DG/rmandr/datafile/users.314.755011345"


SQL> alter database open;
Database altered.