Home » Server Options » Data Guard » Temporary tablespace is empty
icon5.gif  Temporary tablespace is empty [message #239591] Tue, 22 May 2007 13:10 Go to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

I tried a 'show parameters' on my physical standby database after opening it in "READ ONLY" mode, and got the following error:

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;

Database altered.

SQL> show parameters
ORA-25153: Temporary Tablespace is Empty

My first reaction is "so what if the temporary tablespace is empty?" but I really want to see the parameters on this database.

Re: Temporary tablespace is empty [message #239592 is a reply to message #239591] Tue, 22 May 2007 13:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ORA-25153: Temporary Tablespace is Empty
Cause: An attempt was made to use space in a temporary tablespace with no files.
Action: Add files to the tablespace using ADD TEMPFILE command.
Re: Temporary tablespace is empty [message #239595 is a reply to message #239592] Tue, 22 May 2007 13:16 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
You have to add temporary file in your database in read only mode, then try.
Re: Temporary tablespace is empty [message #239598 is a reply to message #239591] Tue, 22 May 2007 13:23 Go to previous message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

Okay, I did that before, not on the new Standby. Thanks! Cool
Previous Topic: How do you stop ARCH?
Next Topic: TNS protocol adapter error / buffer space
Goto Forum:
  


Current Time: Sat Aug 30 01:32:54 CDT 2014

Total time taken to generate the page: 0.10923 seconds