asm数据文件迁移(asm–>asm)

最新推荐文章于 2024-12-06 10:59:37 发布

weixin_33860553

最新推荐文章于 2024-12-06 10:59:37 发布

阅读量155

点赞数

文章标签：数据库

本文介绍了使用RMAN进行Oracle数据库表空间XFF从一个磁盘组到另一个磁盘组的迁移过程，包括离线表空间、备份数据文件、切换数据文件以及在线表空间等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

rman迁移操作

[oracle@localhost oradata]$ rman target /
 
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 27 05:50:03 2011
 
Copyright (c) 1982, 2005, 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
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验证操作

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