Scenario : Assume there is a physical standby configuration...

Question

Now the question is if i add a tempfile in primary database will this get reflected in standby....? Yes/No

another question is if i add a undo datafile in primary will this replicated in standby...? Yes/No

Answer 1

Here is the answer...

when you add tempfile it'll not get reflected in standby.

where as undo datafile it'll get reflected.

 

*when standby_file_management=auto then all the datafiles that are created in primary will get reflectd in standby

where as tempfile need to recreate them when standby comes up as primary in case of failovers/maintainence