Friday, August 4, 2017

ORA-27191: sbtinfo2 returned error

While creating the standby database from active database with

duplicate target database for standby from active database
spfile
set audit_file_dest='/u01/app/oracle/admin/dev1tstd/adump'
set db_unique_name='dev1tstd'
set fal_server='dev1tstp1','dev1tstp2'
set instance_number='1'
NOFILENAMECHECK;

I was getting the error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/03/2017 10:48:17
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-27191: sbtinfo2 returned error
Additional information: 3475


Please note that I am running the duplicate database from primary database. 

The reason for this issue was simple, I had a wrong configuration setup in RMAN for primary and that was 

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

I had to clear it so that it starts using disk a device 

CONFIGURE DEFAULT DEVICE TYPE clear;

This fixed the issue.

No comments: