ASM data File Migration (ASM–>ASM)

Rman Migration Operations

[Oracle@localhost oradata]$ Rman Target/

Recovery manager:release 10.2.0.3.0-production on Mon June 27 05:50:03 2011

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to target Database:tasm (dbid=3032096031)

Rman> SQL ' alter tablespace xff offline ';

Using target database control file instead of recovery catalog

SQL Statement:alter tablespace xff offline

rman> backup device type disk as copy datafile 6 format ' +DG2 ';

Starting backup at 27-jun-11

Using target database control file instead of recovery catalog

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=159 Devtype=disk

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00006 name=+data/tasm/xff01.dbf

More Wonderful content: http://www.bianceng.cn/database/Oracle/

Output filename=+dg2/tasm/datafile/xff.256.754899605 tag=tag20110627t062003 recid=4 stamp=754899608

Channel ora_disk_1:datafile copy complete, elapsed time:00:00:07

Finished backup at 27-jun-11

rman> switch tablepspace xff to copy;

DataFile 6 switched to datafile copy "+dg2/tasm/datafile/xff.256.754899605"

Rman> SQL ' alter tablespace XFF online ';

SQL Statement:alter tablespace xff Online

SQL validation Operations

Sql> select name from V$datafile;

NAME

--------------------------------------------------------------------------------

+data/tasm/system01.dbf

+data/tasm/undotbs01.dbf

+data/tasm/sysaux01.dbf

+data/tasm/users01.dbf

+data/tasm/example01.dbf

+dg2/tasm/datafile/xff.256.754899605

6 rows selected.

Sql> Select COUNT (*) from HR.A;

COUNT (*)

----------

1580

Author: 51cto Oracle small-mixed son