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...
-
記事本開啟 HKEY_CLASSES_ROOT\*\shell] [HKEY_CLASSES_ROOT\*\shell\NotePad] @="用記事本開啟" [HKEY_CLASSES_ROOT\*\shell\NotePad\command] @=...
-
下載 http://dba-tips.blogspot.tw/2015/05/oracle-database-health-check-script.html Oracle Database Health Check Script Do you wan...
-
旋轉泡泡: Oracle DataGuard 相關 Oracle DataGuard 檢查開啟狀態 -- 請全貼 -- ===check=== select dbid,name from v$database; select log_mode , OPE...
沒有留言:
張貼留言