阅读导航
迁移数据文件到ASM
数据库一致性情况下迁移:将数据库启动到mount状态,生成rman copy 语句,然后在rman中执行:
SQL> startup mount
SQL> select q'(copy datafile ')'||name||q'(' to '+oradata';)' from v$datafile;
Q'(COPYDATAFILE')'||NAME||Q'('TO'+ORADATA';)'
-------------------------------------------------------------------------------
copy datafile 'D:\NSOADP\SYSTEM01.DBF' to '+oradata';
copy datafile 'D:\NSOADP\SYSAUX01.DBF' to '+oradata';
copy datafile 'F:\NSOADP\UNDOTBS01.DBF' to '+oradata';
copy datafile 'D:\NSOADP\USERS01.DBF' to '+oradata';
SQL> exit
D:\>rman target /
RMAN> run
2> {
3> copy datafile 'D:\NSOADP\SYSTEM01.DBF' to '+oradata';
4> copy datafile 'D:\NSOADP\SYSAUX01.DBF' to '+oradata';
5> copy datafile 'F:\NSOADP\UNDOTBS01.DBF' to '+oradata';
6> copy datafile 'D:\NSOADP\USERS01.DBF' to '+oradata';
7>}
启动 backup 于 2015-04-15 10:02:44
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 启动数据文件副本
输入数据文件: 文件号=00001 名称=D:\NSOADP\SYSTEM01.DBF
输出文件名=+ORADATA/nsoa/datafile/system.260.877082571 标记=TAG20150415T100250 RECID=265 STAMP=877082603
通道 ORA_DISK_1: 数据文件复制完毕, 经过时间: 00:00:35
完成 backup 于 2015-04-15 10:03:25
……
生成更改控制文件数据名的语句,然后执行更改:
SQL> SELECT --T.NAME,T.FILE#,C.FILE#,C.NAME
? 2? q'(ALTER DATABASE RENAME FILE ')'||c.name||q'(' to ')'||t.name||q'(';)'
? 3? FROM V$DATAFILE_COPY T LEFT JOIN V$DATAFILE C
? 4? ON T.FILE#=C.FILE#
? 5? WHERE T.NAME IS NOT NULL? order by COMPLETION_TIME desc;
SQL> alter database rename file 'D:\NSOADP\SYSTEM01.DBF' to '+ORADATA/nsoa/datafile/system.260.877082571';
数据库非一致性情况下迁移(归档模式):
使用 alter database datafile '' offline 命令将数据文件offline,然后同上面的方式一样处理,最后将数据文件online
SQL> alter database datafile '/u01/oradata/sydb/user01.dbf' offline;
RMAN> copy datafile '/u01/oradata/sydb/user01.dbf' to '+oradata';
Starting backup at 23-APR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=180 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/oradata/sydb/user01.dbf
output file name=+ORADATA/sydb/datafile/users.257.877803115 tag=TAG20150423T181155 RECID=1 STAMP=877803123
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 23-APR-15
SQL> alter database rename file '/u01/oradata/sydb/user01.dbf' to '+ORADATA/sydb/datafile/users.257.877803115';
SQL> alter database datafile '+ORADATA/sydb/datafile/users.257.877803115' online;
alter database datafile '+ORADATA/sydb/datafile/users.257.877803115' online
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '+ORADATA/sydb/datafile/users.257.877803115'
SQL> recover datafile '+ORADATA/sydb/datafile/users.257.877803115';
Media recovery complete.
SQL> alter database datafile '+ORADATA/sydb/datafile/users.257.877803115' online;
迁移日志文件到ASM
可以在mount或open状态迁移非current或active日志文件到asm;方法将已有的日志文件(每个日志组必须有一个member)或日志组(数据库必须有两个日志组存在)删除,然后添加新的日志文件或日志组;
alter database drop logfile member 'E:\NSOADP\REDO07.LOG';? #删除日志文件
alter database drop logfile group 2;? #删除日志组
alter database add logfile member '+oradata' to group 7;? #添加日志文件
alter database add logfile ( '+oradata','oradata') size 50m;? #添加有两个成员的日志组
alter database add logfile '+oradata','oradata' size 50m;? #同时添加两个日志组
迁移控制文件到ASM
?首先确定好控制文件位置和名称
SQL> show parameter control_file
NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
----------------------------