Home » Server Options » Data Guard » Clarification Regarding File Growth in Physical Standby (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
Clarification Regarding File Growth in Physical Standby [message #492876] Thu, 03 February 2011 06:12 Go to next message
kartheedba
Messages: 4
Registered: September 2010
Junior Member
Hi All,

I am in need of a clarification regarding the file size growth in Physical Standby Database.Say we have 150 GB size of LIVE DB and we have created the same as in STDBY(150 GB).Will there be a growth in STDBY DB datafiles with respect to the LIVE DBOR only the logs are applied currently to the STDBY and the changes will only be reflecting when there is a switchover or failure scenario????

Thanks and Regards
Karthik M
Re: Clarification Regarding File Growth in Physical Standby [message #492895 is a reply to message #492876] Thu, 03 February 2011 07:35 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
http://www.orafaq.com/parms/parm1942.htm

Quote:
OR only the logs are applied currently to the STDBY and the changes will only be reflecting when there is a switchover or failure scenario????


huh?!
Re: Clarification Regarding File Growth in Physical Standby [message #492930 is a reply to message #492876] Thu, 03 February 2011 12:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A physical standby database is a physical image of the primary database, so files are the same ones block per block (but may not be in the same directories).

Regards
Michel
Re: Clarification Regarding File Growth in Physical Standby [message #493246 is a reply to message #492876] Mon, 07 February 2011 01:21 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
As the Primary Database grows in size, so will the Physical Standby grow equally. A datafile that autoextends on the Primary is also extended on the Standby. A new datafile added on the Primary is also added on the Standby.

The Physical Standby is a "mirror-image" of the Primary (as of upto the last transactions applied to it).


Hemant K Chitale
Re: Clarification Regarding File Growth in Physical Standby [message #493687 is a reply to message #493246] Wed, 09 February 2011 06:37 Go to previous message
kartheedba
Messages: 4
Registered: September 2010
Junior Member
Thank you so much for the clarification Michel and Hemant.
Previous Topic: Parameter db_file_name_convert
Next Topic: Datafile belongs to orphan incarnation
Goto Forum:
  


Current Time: Mon Sep 21 00:52:13 CDT 2020