we are using the dataguard 18.104.22.168 in window server 2008. My questions is here
Whenever we are making any changes in any tablespaces on primary database, same will reflect on standby database except temp tablespace. Why is not reflecting for temp tablespace on standby database when are we making any changes on temp tablespace on primary database?
2.)I am not able to unlock the account on standby database and shall we do this in primary database.
3.) Query(for Report generation) is running very slow on standby and we need to rebuild the Index to resolve this performance issue. Shall we rebuild the index on primary database?
Please help me here.