Hi,

I have configured standby database 8.1.6 EE.

But when I dump standby controlfile to trace it doesn't show me tempfile for temp tablespace

Code:
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
#
whereas If I dump primary database controlfile.... it shows me tempfile...
Code:
ALTER DATABASE OPEN;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/ora4/temp01.dbf' REUSE;
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/ora4/temp02.dbf' REUSE;
# End of tempfile additions.
#
And I use the samefile to build standby database, then how come tempfile settings are missing in standby database controlfile?

Now do I need to alter temp tablespace at standby site or how do I do this...


Thanks

Sameer