Total Pageviews

Segmentation Fault During Duplicate From Active Database

Scope:
This post explains the solution to resolve the SEGMENT FAULT error message while Duplicate database from source using RMAN Duplicate method.

Symptoms:
channel ORA_DISK_1: starting datafile copy
copying current control file
Oracle instance started



Segmentation fault
Cause:
This issue is related to the connectivity issue is not properly configured between source and destination. These can be because of multiple issues:
  1. This issue is related to the database password file at destination side. Password file is not copied/created.
  2. TNS entry is not properly mentioned on both (source/Destination) tnsnames.ora
  3.  Servers (source/destination) are not able to communicate with each other.
  4. Database parameter DB_FILE_RECOVERY_DEST or DB_FILE_RECOVERY_DEST_SIZE is set.

Solution:
  1. Copy the passwordfile from source side and rename as per the database SID used for destination DBSID name.
  2. Put both tns entries of source and destination in tnsnames.ora file on both sides.
  3. Check if nslookup <HOSTNAME< <PORT> should be able to connect. Ping should be enabled on both sides.
  4. Remove the parameters ( DB_FILE_RECOVERY_DEST or DB_FILE_RECOVERY_DEST_SIZE ) from spfile and set arch_dest to some actual path of location.
Still the issue is not resolved, Enable the debug and create trace file for RMAN command. Method can be used as below:

$ rman target sys/<passwd>@<SOurce_DB> auxiliary sys/<Passwd>@<Destination_DB> debug trace=<PATH_and FILENAME>.trc

if this time rman fails, check the trace file mentioned above which lead you to correct cause of the error message.
 

No comments:

Post a Comment