Home » Server Options » Data Guard » Unable to duplicate datafile of "SYSTEM" tablespace (Oracle, 11g R2, solaris 5.10)
Unable to duplicate datafile of "SYSTEM" tablespace [message #656648] Thu, 13 October 2016 03:02 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10679
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.
Re: Unable to duplicate datafile of "SYSTEM" tablespace [message #656667 is a reply to message #656651] Thu, 13 October 2016 23:26 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
I found a information from URL below. This is a stupid bug without patch!

https://support.oracle.com/epmos/faces/ui/km/BugDisplay.jspx?_afrLoop=506871247807528&parent=BUG_MATRIX&id=14021795&_afrW indowMode=0&_adf.ctrl-state=anjmn4i56_243
Re: Unable to duplicate datafile of "SYSTEM" tablespace [message #656876 is a reply to message #656667] Fri, 21 October 2016 01:52 Go to previous message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
I followed "Hot backup" option in below URL then solve my issue.

http://www.em-dba.com/emblog03.html
Previous Topic: Multiple Logical standby
Next Topic: Log shipping not happening from Primary DB to Standby DB
Goto Forum:
  


Current Time: Thu Nov 23 10:56:09 CST 2017

Total time taken to generate the page: 0.01804 seconds