If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database.
But will the same valid for tempfile?? Answer is NO.

Adding tempfiles to TEMP tablespaces in primary database, will not automatically create on standby database. Because no redo is generated, while adding tempfile. So DBA have to add the temp file manually.


Add a tempfile on primary:

check tempfiles present in standby:

We can see the tempfile didnt created in standby. So we have to create the same manually in standby.


Steps if active dataguard( i.e standby in read only mode):

Steps if standby database in mount stage: