Steps to add/rename tempfiles on a physical standby database 11gr2
edited Dec 21, 2013 5:49PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 16 commentsAnswered
Hi Friends,
The tempfile name on my primary is
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
+ABC_DATA/XYZDB/TEMPFILE/psaptemp.266.759684003
When I check the same on physical standby it shows
NAME
--------------------------------------------------------------------------------
+ABC_DATA
Could you please tell me the exact steps to rename my tempfile on the physical standby database to match it to the primary.
Thanks and Regards,
Su.
The tempfile name on my primary is
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
+ABC_DATA/XYZDB/TEMPFILE/psaptemp.266.759684003
When I check the same on physical standby it shows
NAME
--------------------------------------------------------------------------------
+ABC_DATA
Could you please tell me the exact steps to rename my tempfile on the physical standby database to match it to the primary.
Thanks and Regards,
Su.
0