Rman Duplicate is Failing With Segmentation Fault


Error:

RMAN duplicate was done successfully but in last step i.e. opening duplicate database with resetlogs failed with "Segmentation Fault" and when trying to open the database manually the database was getting crashed with and the below error in alert.log

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


Cause:

Undo tablespace name in Target and Duplicate database was different due to which RMAN duplicate was failing with "Segmentation Fault".


Solution:

Make sure that the undo_tablespace name in the Duplicate database should be same as Target Database.

The undo tablespace name can be set using the below parameter in the parameter file

UNDO_TABLESPACE=<tablespace name>

 and start backup the database in nomount and verify the new undo tablespace name is being used.

show parameter undo

Then start the duplicate process again.