用 rman rename oracle 数据文件

$ more rmanhf_rename.sh
#!/bin/sh
. /export/home/oracle/.profile
rq=`date +%Y%m%d`
date
$ORACLE_HOME/bin/rman target / log=/export/home/oracle/rman/hf$rq.log<<!
run
{
set newname for datafile '/trunkbow/oracle/oradata/mpaper/system01.dbf' to '/u01/oracle/oradata/mpaper/system01.dbf' ;
set newname for datafile '/trunkbow/oracle/oradata/mpaper/undotbs01.dbf' to '/u01/oracle/oradata/mpaper/undotbs01.dbf';
set newname for datafile '/trunkbow/oracle/oradata/mpaper/drsys01.dbf' to '/u01/oracle/oradata/mpaper/drsys01.dbf';
set newname for datafile '/trunkbow/oracle/oradata/mpaper/indx01.dbf' to '/u01/oracle/oradata/mpaper/indx01.dbf';
set newname for datafile '/trunkbow/oracle/oradata/mpaper/tools01.dbf' to '/u01/oracle/oradata/mpaper/tools01.dbf';
set newname for datafile '/trunkbow/oracle/oradata/mpaper/users01.dbf' to '/u01/oracle/oradata/mpaper/users01.dbf';
set newname for datafile '/trunkbow/oracle/oradata/mpaper/xdb01.dbf' to '/u01/oracle/oradata/mpaper/xdb01.dbf' ;
restore database;
switch datafile all;
}
exit
!
date

标题

在此添加评论
表情符号:

称呼

邮箱地址（可选）

个人主页（可选）

记住我？