oracle数据库文件系统迁移到ASM

最新推荐文章于 2024-01-01 20:29:29 发布

DB_咸鱼

最新推荐文章于 2024-01-01 20:29:29 发布

阅读量1.9k

点赞数 1

分类专栏： oracle学习笔记文章标签： oracle ASM oracle迁移

本文链接：https://blog.csdn.net/dbafish/article/details/50445483

版权

查看ASM磁盘组

SQL> select name,state from  v$asm_diskgroup;

登陆RMAN执行镜像全备到ASM磁盘组

$rman target /

RMAN> backup as copy database format '+data';

Starting backup at 01-JAN-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf
output file name=+DATA/prod1/datafile/system.260.900002069 tag=TAG20160101T163428 RECID=22 STAMP=900002071
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf
output file name=+DATA/prod1/datafile/sysaux.259.900002071 tag=TAG20160101T163428 RECID=23 STAMP=900002074
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf
output file name=+DATA/prod1/datafile/undotbs1.261.900002079 tag=TAG20160101T163428 RECID=24 STAMP=900002080
channel ORA_DISK_1: