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

Oracle LazyDBA home page