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:
Solution:
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:
- This issue is related to the database password file at destination side. Password file is not copied/created.
- TNS entry is not properly mentioned on both (source/Destination) tnsnames.ora
- Servers (source/destination) are not able to communicate with each other.
- Database parameter DB_FILE_RECOVERY_DEST or DB_FILE_RECOVERY_DEST_SIZE is set.
Solution:
- Copy the passwordfile from source side and rename as per the database SID used for destination DBSID name.
- Put both tns entries of source and destination in tnsnames.ora file on both sides.
- Check if nslookup <HOSTNAME< <PORT> should be able to connect. Ping should be enabled on both sides.
- 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.
$ 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