利用RMAN将非ASM文件移动到ASM里 - [ASM]

版权声明：转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://oracler.blogbus.com/logs/39754517.html

ASM是将来的趋势，这段时间一直在研究ASM。进入正题。

1、要移动的数据文件

SQL> select file_name from dba_data_files where tablespace_name='USERS';

 FILE_NAME

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

+GQISJ/gqsj/datafile/users.264.686852255

+GQISJ/gqsj/datafile/users.268.687200231

+GQ/tmp/user01

/opt/app/oracle/user01.dbf

2、连接到RMAN

[oracle@lee dbs]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 22 17:46:40 2009

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

connected to target database: GQSJ (DBID=2809640057)

RMAN>

3、把表空间置为只读状态

RMAN> sql'alter database datafile 7 offline';

using target database control file instead of recovery catalog

sql statement: alter database datafile 7 offline

RMAN>

4、复制数据文件到ASM磁盘组

RMAN> backup as copy datafile 7 format'+gqisj';

Starting backup at 22-MAY-09

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=143 devtype=DISK

channel ORA_DISK_1: starting datafile copy

input datafile fno=00007 name=/opt/app/oracle/user01.dbf

output filename=+GQISJ/gqsj/datafile/users.269.687549245 tag=TAG20090522T175403 recid=1 stamp=687549244

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 22-MAY-09

5、switch数据文件

RMAN> switch datafile 7 to copy;

datafile 7 switched to datafile copy "+GQISJ/gqsj/datafile/users.269.687549245"

6、把数据文件置为ONLINE

RMAN> sql'alter database datafile 7 online';

sql statement: alter database datafile 7 online

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of sql command on default channel at 05/22/2009 17:56:37

RMAN-11003: failure during parse/execution of SQL statement: alter database data                                                                             file 7 online

ORA-01113: file 7 needs media recovery

ORA-01110: data file 7: '+GQISJ/gqsj/datafile/users.269.687549245'

这里是由于把数据文件置为OFFLINE没有做检查点，所以需要恢复。

RMAN> recover datafile 7;

Starting recover at 22-MAY-09

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished recover at 22-MAY-09

RMAN> sql'alter database datafile 7 online';

sql statement: alter database datafile 7 online

7、删除原始的文件

[oracle@lee oracle]$ rm user01.dbf

8、同理我们可以把一个表空间移动到ASM，也可以从一个磁盘组移动到另一个磁盘组。