Oracle-L: Re: Standby Database-No space on Disk

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 24 Apr 2002 01:33:28 -0800
Message-ID: <F001.0044D6D3.20020424013328@fatcity.com>

If you are using a tempfile for tempoary tablespace on the primary, then you don't need this at all on the standby (whilst its recovering)

hth
connor

Hussain Ahmed Qadri <hussain_at_skm.org.pk> wrote: >

> 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
>
>
>

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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 - 04:33:28 CDT