“ORA-25153 : Temporary Tablespace is Empty” after switchover to physical standby
edited Sep 1, 2009 5:28AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
we performed a switch over to physical standby database (9.2.0.7)
everything went fine except that we are getting the following error on the new primary (old standby)
“ORA-25153 : Temporary Tablespace is Empty”
we queried v$tablespace and there is TEMP1 tablespace out there but v$tempfile is not showing any records
it looks like that when we initially created the physical standby database, we did not added TEMP files to the temp tablespace
Anyways, how can we fix this now? do we need to set the standby_file_management to FALSE before adding the temp file?
thanks
0