| Clarification Regarding File Growth in Physical Standby [message #492876] |
Thu, 03 February 2011 06:12  |
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 #493246 is a reply to message #492876] |
Mon, 07 February 2011 01:21  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
