standby undo retention
Mayur Chandankar, June 23, 2022 - 6:05 am UTC
So we can conclude that we can set different undo retention on primary and standby database by increasing the size undo tablespace on primary and standby database with different size. like for primary 100GB and for standby 200gb ? please make me correct if I am wrong?
we have requirement for same so i am asking for that ?
please suggest
July 05, 2022 - 12:21 am UTC
Given that a standby is a physical replica of a primary, then the undo tablespaces will be the same size.
As I said intially: "you'll need a larger (or autoextensible) undo tablespace on the primary."
standby undo retention
Mayur Chandankar, June 23, 2022 - 6:07 am UTC
So we can conclude that we cannot set different undo retention on primary and standby database by increasing the size undo tablespace on primary and standby database with different size. like for primary 100GB and for standby 200gb ? please make me correct if I am wrong?
we have requirement for same so i am asking for that ?
please suggest