RMAN RAC(ASM) restore

[Roshan]

Oracle database 12c
Hi,

I am performing a restore of backup of a production database(RAC - ASM) from Networker - tape backup.
The restore is completing with
restarting auxiliary database without server parameter file
Oracle instance started

Total System Global Area   40667971584 bytes

Fixed Size                     3721320 bytes
Variable Size               5100275608 bytes
Database Buffers           35433480192 bytes
Redo Buffers                 130494464 bytes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/01/2017 21:11:37
RMAN-05501: aborting duplication of target database


Please find attached restore script generated and log file.
cbslog2.log
restorecbs010617.sql


tns file
CBS_PROD=
(DESCRIPTION=(LOAD_BALANCE=ON)
        (FAILOVER=ON)
        (ADDRESS=(PROTOCOL=TCP)(HOST=cbs-scan.telecom.mu)(PORT=1521))
         (CONNECT_DATA= (SERVICE_NAME=cbs)
        (FAILOVER_MODE=(TYPE=SELECT) (METHOD=BASIC))))



Do you think the issue is with the restore script?

Thanks,
Roshan

[ErmanArslansOracleBlog]

I think there is something wrong with your pfile.

Check the contents of the pfile and ensure that the parameters are correct.
Startup nomount the auxiliary use SHOW PARAMETER command to check as well.
Ensure that all parameters are correct.
especially, quotes.. all open quotes should have closing quotes.

[Roshan]

Hi ,

from alert log file
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/data2/ora12c/fast_recovery_area/CBS/controlfile/o1_mf_dlzv0l0c_.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/data2/ora12c/oradata/CBS/controlfile/o1_mf_dlzv0kxp_.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Why does Networker not restore the controlfile?

Regards,
Roshan

[ErmanArslansOracleBlog]

Check the networker logs?
Does it have restore controlfile instruction?

[Roshan]

restorecbs010617.sql

[ErmanArslansOracleBlog]

1)What about the log of the duplicate session?
2)You have controlfile backup right? ( I mean you had the setting controlfile autobackup on right)

[Roshan]

Control file autobackup was disabled.

I managed to restore the controlfile using

connect target sys/m@cbs_prod;
connect auxiliary /;

run {

ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';

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

restore clone primary controlfile to '/archicom/ora12c/oradata/control1.ctl';
}

I mounted the database.

I removed the duplicate command and replaced with:

restore database;
switch datafile all;
switch tempfile all;
recover database;

Please find attahched logfile:
restorecbs2.log

Please advise.
Regards,
ROshan

[Roshan]

It's working now. I added

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';