2016年10月10日 星期一
rman restore newname
startup nomount ;
set DBID=1438520397;
run {
restore controlfile from '/rmanbackup/Control.ctl';
startup mount ;
restore database ;
recover database ;
};
startup nomount ;
set DBID=1438520397;
run {
restore controlfile
from '/rmanbackup/Control.ctl';
set newname for datafile 5
to '/oradata/data/userdata2.dbf' ;
set newname for datafile 6
to '/oradata/data/user2datafile2.dbf' ;
set newname for datafile 7
to '/oradata/data/user2datafile1.dbf' ;
startup mount ;
restore database ;
switch datafile all;
recover database ;
};
訂閱:
張貼留言 (Atom)
RHEL install EPEL
https://www.linuxtechi.com/install-epel-repo-on-rhel-system/ EPEL dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest...
-
下載 出處 下載網址: http://tinyurl.com/plodb56 Step 1 下載取得「Windows10TweakTool」並解壓縮,在壓縮出的「Windows10SettingTool.bat」上按一下滑鼠右鍵,點擊選單中的【以系統管理員身分...
-
' 呼叫 日期 eg 2月 14日 ==> 0214 ' 11:56 2005/3/9 ' CC.HSIEH 'dim dim strm,strd,strToday,stry call datt msgbox strToday ...
-
1 關掉DB isqlplusctl stop emctl stop dbconsole lsnrctl stop sqlplus / as sysdba SQL > shutdown immediate 2 備份DB HOME cdOH ...
沒有留言:
張貼留言