RMAN restore point in time

Posted by Roshan on May 22, 2018; 8:39am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-point-in-time-tp6060.html

Oracle Database 11.2.0.4

Hi Erman,

I am planning to restore backup from tape on 10th May 2018to a server. I have done a list backup of database and archivelog on production.

listbackupdatabase.txt
listbackupofcontrolfile.txt

Can you please advise how I can modify my script for point in time recovery?

export NLS_DATE_FORMAT='dd-mon-rr hh24:mi:ss'

rman
connect target / ;
connect auxiliary /;
set DBID=3908658873

run {

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';

SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,NSR_CLIENT=comptel-scan.mauritiustelecom.com)';
restore until time 'sysdate-11' controlfile from autobackup;
}

Please advise.

Regards,

Roshan