用 rman rename oracle 数据文件
[@more@]$ 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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/66233/viewspace-997111/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oracle 9 aq
请登录后发表评论
登录
全部评论
