In that case should we redifine the tablespaces of each user?


----- Original Message -----
From: "tamizh" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Sunday, November 30, 2003 5:24 PM
Subject: RE: Multiple Archive Destinations and Disk Full Scenario


> Archive destination can be specified with 2 options
> 1.Mandatory
> 2.Optional.
>
> Oracle will hang if the mandatory destination is FULL.
>
>
> -----Original Message-----
> From: Junior DBA [mailto:[Email Address Removed] Sent: Sunday, November 30, 2003 5:22 AM
> To: LazyDBA.com Discussion
> Subject: Multiple Archive Destinations and Disk Full Scenario
>
>
>
> Hi list !
>
> Me again. this time. multiple archvie destination.
>
> i have configured two local archive destinations as follows:
>
> DEST_ID STATUS BINDING NAME_SP TARGET REOPEN_SECS DESTINATION
> ---------- --------- --------- ------- ------- ----------- ---------------
--
> ---
> 1 VALID OPTIONAL SYSTEM PRIMARY 0 /home0/archive
> 2 VALID OPTIONAL SYSTEM PRIMARY 0 /backup/archive
>
> Now my understanding is that in case of space problem [full] in any of the
> destinations
>
> oracle/logwr will automatically use the 2nd available destination with
error
> and without
>
> hanging. am i right ?
>
> Regards
> Junior
>
>
> ---------------------------------
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page