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 ;
};

沒有留言:

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...