Oracle-L: Standby Database-No space on Disk

From: Hussain Ahmed Qadri <hussain_at_skm.org.pk>
Date: Tue, 23 Apr 2002 23:58:18 -0800
Message-ID: <F001.0044D597.20020423235818@fatcity.com>

Hello All
Oracle 8.1.7, WINNT4.
On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no space on the disk.
How would I add another datafile to the temporary tablespace? Database is a standby databse with the controlfile for the standby database. Is there a simple way to add a datafile to the tablespaces on a standby database. Or should I shutdown the database, move the datafile to another partition, repartition this old-temporary partition by adding more space to it. And then copy that temporary-datafile back to this old partition and startup the database for the Standby mode.

Would appreciate any prompt suggestions. Regards,

Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre hussain_at_skm.org.pk
www.shaukatkhanum.org.pk

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hussain Ahmed Qadri
INET: hussain_at_skm.org.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 02:58:18 CDT