OraFAQ Forum: Data Guard » Unable to duplicate datafile of "SYSTEM" tablespace

Home » Server Options » Data Guard » Unable to duplicate datafile of "SYSTEM" tablespace (Oracle, 11g R2, solaris 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Re: Unable to duplicate datafile of "SYSTEM" tablespace [message #656651 is a reply to message #656648]

Thu, 13 October 2016 07:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It would be of real help, if you can post your complete session with the commands used and logs. Verbatim.
>> I did required setting in sqlnet.ora file but no difference.
What exactly?
To start with, I would look into EXPIRE_TIME in all involved nodes.

Report message to a moderator