用 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博客 ” ,链接:http://blog.itpub.net/66233/viewspace-997111/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66233/viewspace-997111/