RE: arc destination odd behavior

Hi Rich -

Nope. It's 1.

Can you believe I even forgot to watch the game on Sunday. I can always cheer for the Bucs, lots of ex-Vikes :) "Death before losing a game"

Have a great night, all.
Lisa

> -----Original Message-----
> From: Jesse, Rich [SMTP:Rich.Jesse_at_qtiworld.com]
> Sent: Tuesday, December 10, 2002 5:12 PM
> To: 'ORACLE-L_at_fatcity.com'
> Cc: 'Lisa.Koivu_at_efairfield.com'
> Subject: RE: arc destination odd behavior
>
> Hey Lisa,
>
> Is the value of log_archive_min_succeed_dest > 1?
>
> Rich
>
> p.s. I guess they really are Bloody Vikings. Hey, there's always next
> year... :)
>
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI
> USA
>
> -----Original Message-----
> From: Koivu, Lisa [mailto:Lisa.Koivu_at_efairfield.com]
> Sent: Tuesday, December 10, 2002 3:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: arc destination odd behavior
>
>
> Hi all -
> 8.1.7.2, Windows 2000 sp 2
> I'm working on my backupexec implementation. For some odd reason the
> backup
> job that copies the arclogs to tape and deletes them off the disk (what BE
> calls an 'archive' job) wants to delete the directory too. Sometimes the
> directory is deleted, and sometimes it isn't.
> So I whip together a perl script to fire after the backup to check for the
> arc directory and recreate it if it isn't there.
> Well, I expected Oracle to crash if it couldn't find the arc directory.
> Instead it wrote to the directory where the arc directory used to reside
> with a different name.
> Maybe it's platform specific, but doesn't this seem odd? I would rather
> have my db crash if the directory doesn't exist. My backups would be all
> hosed because the arclogs wouldn't end up being written to tape properly.
> In fact I'm betting that BE will err out when looking for that directory.
>
> Here's what I see in v$archived_log. 693 and 694 are when the directory
> still existed. 695+ are after the directory got deleted. Anyone seen
> this
> before?
> 693 480186148 D:\ORACLE\ORADATA\RMANTST\ARC\RMANTST_00428.ARC
> 694 480186151 D:\ORACLE\ORADATA\RMANTST\ARC\RMANTST_00429.ARC
> 695 480268708 D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00430.ARC
> 696 480268709 D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00431.ARC
> 697 480268711 D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00432.ARC
> 698 480268715 D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00433.ARC
> 699 480268718 D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00434.ARC
>
>
> SQL> select value from v$parameter
> 2 where name = 'log_archive_dest';
> VALUE
> ---------------------------------------------
> D:\oracle\oradata\rmantst\arc
> SQL>
>
>
> Lisa Koivu
> Oracle Database Administrator
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: Lisa.Koivu_at_efairfield.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).