rhel4+oracle10g ASM配制及ASM与文件系统之间迁移(二)
itch datafile 4;
recover datafile 4;
sql 'alter database datafile 4 online';
}
2,users表空间的迁移(从asm到文件系统)
rman>backup tablespace users;
rman>run{
sql 'alter tablespace users offline immediate';
set newname for datafile 4 to '/u01/app/oracle/oradata/dndn/users01.dbf';
restore tablespace users;
switch datafile 4;
recover tablespace users;
sql 'alter tablespace users online';
}