将表空间、数据文件从文件系统迁移到ASM(二)
/u01/oracle/10g/oradata/gt10g/temp01.dbf
4 100 GTLIONSTEMP 100 /u01/oracle/10g/oradata/gt10g/gtlionstemp01.dbf
--使表空间脱机
RMAN> sql 'alter tablespace gtlions offline';
sql statement: alter tablespace gtlions offline
--开始备份两个数据文件
RMAN> backup as copy datafile 5 format'+data01';
Starting backup at 25-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005name=/u01/oracle/10g/oradata/gt10g/gtlions01.dbf
outputfilename=+DATA01/gt10g/datafile/gtlions.258.808326729 tag=TAG20130225T151205recid=117 stamp=808326729
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:07
Finished backup at 25-FEB-13
RMAN> backup as copy datafile 6 format'+data01';
Starting backup at 25-FEB-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006name=/u01/oracle/10g/oradata/gt10g/gtlions02.dbf
outputfilename=+DATA01/gt10g/datafile/gtlions.265.808326737 tag=TAG20130225T151217recid=118 stamp=808326738
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:03
Finished backup at 25-FEB-13
--切换到cope副本
RMAN> switch datafile 5 to copy;
datafile 5 switched to datafile copy"+DATA01/gt10g/datafile/gtlions.258.808326729"
RMAN> switch datafile 6 to copy;
datafile 6 switched to datafile copy"+DATA01/gt10g/datafile/gtlions.265.808326737"
--重新联机GTLIONS表空间
RMAN> sql 'alter tablespace gtlions online';
sql statement: alter tablespace gtlions online
--在RMAN检查迁移结果
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- -------------------------------
1 440 SYSTEM *** /u01/oracle/10g/oradata/gt10g/system01.dbf
2 25 UNDOTBS1 *** /u01/oracle/10g/oradata/gt10g/undotbs1.dbf
3 250 SYSAUX *** /u01/oracle/10g/oradata/gt10g/sysaux01.dbf
4 5 USERS *** /u01/oracle/10g/oradata/gt10g/users01.dbf
5 10 GTLIONS *** +DATA01/gt10g/datafile/gtlions.258.808326729
6 10 GTLIONS *** +DATA01/gt10g/datafile/gtlions.265.808326737
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- -------------------------------
1 100 TEMP 100 /u01/oracle/10g/oradata/gt10g/temp01.dbf
4 100 GTLIONSTEMP 100 /u01/oracle/10g/oradata/gt10g/gtlionstemp01.dbf
--在SQL*PLUS检查迁移结果
SQL> Select ts#,Name From v$tablespace WhereName='GTLIONS'
2 Union All
3 Select file#,Name From v$datafile Wherets#=7;
TS# NAME
-----------------------------------------------------
7 GTLIONS
5+DATA01/gt10g/datafile/gtlions.258.808326729
6+DATA01/gt10g/datafile/gtlions.265.808326737
-The End-