Duplicate Database Fails With ORA-03135

刘泽宇

现象：
Duplicate Database to clone or to build standby fails with below error

input datafile file number=0000n name=<filename>

RMAN-03009: failure of backup command on prmy3 channel at 09/26/2024 16:20:35

ORA-03135: connection lost contact

continuing other job steps, job failed will not be re-run


改动：
Executing Duplicate database using RMAN

原因
Connection terminates in Network layer either due to time out setting or due to Out Of Band Breaks.


处理方法：
Enable Dead Connection Detection by setting the below parameter in sqlnet.ora on both target and auxiliary database servers.


sqlnet.expire_time=10
Disable Out Of Band Breaks by setting below parameter in sqlnet.ora on both target and auxiliary database servers.

disable_oob=ON
Both the parameters do not require listener restart.

For database with big file tablespace, use the section size in the duplicate script.

Query the largest datafile size on target database to determine the section size to be used in duplicate script.

SQL> select max(bytes)/1073741824 GB from v$datafile;

If the largest file is:
<15TB use section size of 64G
>15TB and <30TB used section size of 128G
>30TB and <60TB used section size of 256G
>60TB use section size of 512G