RMAN error

[Roshan]

Hello,

I am trying to restore a backup from Networker. I managed to connect to production.

When I issue my RMAN command
RUN {

     ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH2 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH3 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH5 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH6 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH7 TYPE 'SBT_TAPE';

     SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,
          NSR_CLIENT=10.210.29.156)';



     DUPLICATE TARGET DATABASE TO WINSDB
          PFILE = /opt/app/oracle/product/11.2.0/db_1/dbs/initWINSDB2.ora
          LOGFILE
                 GROUP 5 ('/ORAREDO1/WINSDB/redo05.log', '/ORADATA5/WINSREDO/redo05_1.log') SIZE 4294967296,
                 GROUP 6 ('/ORAREDO2/WINSDB/redo06.log', '/ORADATA5/WINSREDO/redo06_1.log') SIZE 4294967296,
                 GROUP 9 ('/ORAREDO1/WINSDB/redo09_01.log', '/ORAREDO2/WINSDB/redo09_02.log') SIZE 4294967296,
                 GROUP 10 ('/ORAREDO1/WINSDB/redo10_01.log', '/ORAREDO2/WINSDB/redo10_02.log') SIZE 4294967296;
                 GROUP 11 ('/ORAREDO1/WINSDB/redo11_01.log', '/ORAREDO2/WINSDB/redo11_02.log') SIZE 4294967296;

}

I am getting the error below:

error2.txt


Grateful if you can help.

Thanks,
Roshan

[ErmanArslansOracleBlog]

Rman can not find your backup controlfile to restore..

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/product/11.2.0.4/dbs/c-2593876745-20161107-00
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /opt/app/oracle/product/11.2.0.4/dbs/c-2593876745-20161107-00
ORA-19505: failed to identify file "/opt/app/oracle/product/11.2.0.4/dbs/c-2593876745-20161107-00"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

[Roshan]

The file is present /opt/app/oracle/product/11.2.0.4/dbs/c-2593876745-20161107-00

Why does it not find controlfile backup?

How can I bypass the controlfile error? I have already restored it manually.

[ErmanArslansOracleBlog]

I don't know your OS (target and aux) , your versions etc, your command for duplicating this DB...
But will try to give you some info;

If the file is there in the filesystem of the auxiliary instance and if its permissions are right, then this should be investigated.

Can this file even be copied/moved using normal Unix commands?

Check and see if it s locked or something strange happened to that file..

Also, for bypassing the controlfile error, if you restored the controlfile , you can continue with your restore work.
You can restore the database by manually allocating channels and issuing restore commands.