NMSAP Redirected Restore - SAP Oracle

Hi

We are trying to restore the SAP Oracle Database from a Production Server to Quality Server.

Are there any specific steps that need to be followed in the redirected restore..

We are using NMSAP for Oracle we prepared setup same as Source Production Server.

At the end of restoration we are getting some error as below.

BR0280I BRRECOVER time stamp: 2018-01-20 14.07.42

BR0336I Applying offline redolog file E:\ORACLE\ABC\ORIGLOGB\LOG_G12M1.DBF ...

BR0278E Command output of 'E:\app\ABCadm\product\11.2.0\dbhome_1\BIN\sqlplus /nolog < E:\Oracle\ABC\sapbackup\.vexqkmft.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 20 14:07:42 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> Connected.

SQL>

SQL> SQL> SQL> SQL> SQL> SQL> SQL> ORA-00279: change 1302207731 generated at 01/19/2018 16:26:53 needed for thread 1

ORA-00289: suggestion : E:\ORACLE\ABC\ORIGLOGB\ABCARCH1_64856_819368891.DBF

ORA-00280: change 1302207731 for thread 1 is in sequence #64856

Specify log: { =suggested | filename | AUTO | CANCEL}

ORA-00310: archived log contains sequence 64886; sequence 64856 required

ORA-00334: archived log: 'E:\ORACLE\ABC\ORIGLOGB\LOG_G12M1.DBF'

SQL> SP2-0042: unknown command "cancel" - rest of line ignored.

SQL> Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

BR0280I BRRECOVER time stamp: 2018-01-20 14.07.43

BR0279E Return code from 'E:\app\ABCadm\product\11.2.0\dbhome_1\BIN\sqlplus /nolog < E:\Oracle\ABC\sapbackup\.vexqkmft.spi': 0

BR0302E SQLPLUS call for database instance ABC failed

BR0200I BR_TRACE: location BrDbRecover-26, commands for SQLPLUS in: E:\Oracle\ABC\sapbackup\.vexqkmft.spi

@E:\Oracle\ABC\sapbackup\.vexqkmft.spu

host E:\usr\sap\ABC\SYS\exe\uc\NTAMD64\brtools.exe -f delete E:\Oracle\ABC\sapbackup\.vexqkmft.spu;

set sqlprompt "SQL> ";

set time off;

set tab off;

set linesize 1000;

set pagesize 1000;

set autorecovery off;

recover from 'E:\ORACLE\ABC\ORIGLOGB\ABCarch' database until time '2018-01-19 16.31.57' using backup controlfile;

E:\ORACLE\ABC\ORIGLOGB\LOG_G12M1.DBF

cancel

exit;

BR0338E Applying offline redolog file E:\ORACLE\ABC\ORIGLOGB\LOG_G12M1.DBF failed

BR0548I Check Oracle alert log E:\Oracle\ABC\saptrace\diag\rdbms\ABC\ABC\trace\alert_ABC.log for further information about this error

BR0280I BRRECOVER time stamp: 2018-01-20 14.07.43

BR0669E Cannot continue due to previous warnings or errors

BR0280I BRRECOVER time stamp: 2018-01-20 14.07.43

BR0700E Fatal errors occurred - terminating processing...

BR0717E Database point-in-time recovery failed

BR0797I Number of restored/recovered database files: 61/61

BR0798I Number of restored/applied incremental files: 0/0

BR0799I Number of restored/applied archivelog files: 3/3

BR0706I End of database recovery: vexqkmft.dpt 2018-01-20 14.07.43

BR0280I BRRECOVER time stamp: 2018-01-20 14.07.44

BR0704I BRRECOVER terminated with errors

Unable to execute BR*Tools command.

The process 'E:\usr\sap\ABC\SYS\exe\uc\NTAMD64\brrecover' exited with error status 5.

The recovery did not succeed.

The recovery command 'C:\Program Files\EMCNetWorker\nsr\bin\nsrsaprc.exe -a -s SGSCAxyz.corpintra.net -c srtabc.corpintra.net -T SAPOracle -g 2SAP_DB_Restore_19012018' failed.

Please advise us.

Thanks

Harish