| Unable to duplicate datafile of "SYSTEM" tablespace [message #656648] |
Thu, 13 October 2016 03:02  |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
Hi There,
I try to implement physical standby database.
Primary: Oracle 11.2.0.3, solaris 5.10
Standby: Oracle 11.2.0.3, CentoS 6.5
When I execute active database duplication command on standby server, all datafiles restored on standby server except a datafile of SYSTEM tablespace.
I try to restore only failed datafile but still met same issue.
Quote:
Error message on RMAN log:
...............
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 13-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=750 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=894 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DG_BS/mcm9qbs/datafile/system.264.772928327
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/13/2016 15:28:13
ORA-03135: connection lost contact
When I receive able error message on standby server during the active data duplication process, below trace file generated on primary server.
Quote:
Trace file /export/home/oracle/diag/rdbms/mcm9qbs/MCM9QBS/trace/MCM9QBS_ora_7291.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /export/home/oracle/product/11.2.0
System name: SunOS
Node name: XXXXX
Release: 5.10
Version: Generic_150401-24
Machine: i86pc
Instance name: MCM9QBS
Redo thread mounted by this instance: 1
Oracle process number: 99
Unix process pid: 7291, image: oracle@XXXXX
I did required setting in sqlnet.ora file but no difference.
I can restore many data files (around 1TB data) but unable to restore only a datafile which is SYSTEM tablespace. I met this issue test and production environment too.
Thanks for advice.
[Updated on: Thu, 13 October 2016 03:04] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
