Restore controlfile from RMAN

Jul 30, 2018 4:38AM

Hi,

I'm having an issue to restore controlfile using tape backup into dev db server.

RMAN> run

2> {

3> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';

4> SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=XXXX,NSR_CLIENT=XXXXXXX)';

5> restore until time = "to_date('July 2 2017 13:00:00','Mon DD YYYY HH24:MI:SS')" controlfile to 'N:\RMAN_Backup' from autobackup;

6> }

using target database control file instead of recovery catalog

allocated channel: CH1

channel CH1: SID=963 device type=SBT_TAPE

channel CH1: NMDA Oracle v9.0.1.5

sent command to channel: CH1

Starting restore at 30-JUL-18

channel CH1: looking for AUTOBACKUP on day: 20170702

channel CH1: AUTOBACKUP found: c-3568471309-20170702-01

Database Backup and Recovery (MOSC)