RMAN duplicate for Standby, getting ORA-03135: connection lost contact error ONLY on backup of SYSTEM datafile
Hi,
Any help is appreciated. I'm running Oracle 11.2.0.4 on RHEL6 and trying to create a standby database using duplicate from active database option.
I have done all the setup work from here http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/ha/dataguard/physstby/physstdby.htm#t2t1
and get to the part where I run the duplicate command. It appears that I get a timeout error when it gets to the part of the backup which deals with the system datafile. Other, much larger datafiles get backed up and sent to the standby without error. It's just the system datafile where I see the issue every time. The network appears fine, I can tnsping, remote sqlplus etc in both directions
If it helps, my command is this.......
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'flpus','flpussby'
set db_unique_name='flpussby'
set db_file_name_convert='/flpus/','/flpussby/'
set log_file_name_convert='/flpus/','/flpussby/'
set control_files='/data/u10/oradata/flpussby/ctrl/control01.ctl'
set log_archive_max_processes='5'
set fal_client='flpussby'
set fal_server='flpus'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(flpus,flpussby)'
set log_archive_dest_2='service=flpus ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=flpus'
;
}
You can see on the output segment below that other datafiles backup ok but not system
Starting backup at 10/10/2017 01:29:33
channel prmy1: starting datafile copy
input datafile file number=00008 name=/data/u10/oradata/flpus/data/fl_tablespace01.dbf
channel prmy2: starting datafile copy
input datafile file number=00011 name=/data/u10/oradata/flpus/data/request_data01.dbf
output file name=/data/u10/oradata/flpussby/data/request_data01.dbf tag=TAG20171010T012933
channel prmy2: datafile copy complete, elapsed time: 00:10:26
channel prmy2: starting datafile copy
input datafile file number=00006 name=/data/u10/oradata/flpus/data/fl_audit01.dbf
output file name=/data/u10/oradata/flpussby/data/fl_audit01.dbf tag=TAG20171010T012933
channel prmy2: datafile copy complete, elapsed time: 00:04:15
channel prmy2: starting datafile copy
input datafile file number=00002 name=/data/u10/oradata/flpus/data/sysaux01.dbf
output file name=/data/u10/oradata/flpussby/data/fl_tablespace01.dbf tag=TAG20171010T012933
channel prmy1: datafile copy complete, elapsed time: 00:16:56
channel prmy1: starting datafile copy
input datafile file number=00001 name=/data/u10/oradata/flpus/data/system01.dbf
RMAN-03009: failure of backup command on prmy1 channel at 10/10/2017 01:46:36
ORA-03135: connection lost contact
continuing other job steps, job failed will not be re-run
Like I said, any help is appreciated
Sandy