Re: When can I delete these arch1_*.dbf files?

If you take daily/weekly/monthly backups you can delete the arch's that are before the last good backup
Here is a run-through:

1. "alter system switch log file;" - to force a change of online log and write of archived logfile
2. move arch's to "arch backup folder"
3. backup database
4. Validate backup (make sure that it is ok! -eg. compare filesize to org. files )
5. Delete old arch's in "arch backup folder"
   • you could save two sets of arch's to enable you to use the prev. backup if the newest is no good.

Hope this answers your Q.

/lehmann
"John Matzen" <krum-nospam_at_uo.com> wrote in message news:skvn2n7ee7f44_at_corp.supernews.com...
> I set up my database for archive mode so that I could do on-line
 filesystem
> backups. Now, my filesystem is filling up with files like arch1_6424.dbf.
> All I can find in my "Oracle8 DBA Handbook" is something to the effect
 that
> if I loose these files I'm screwed. Is this true? Can I never delete
 these
> files? When is it safe to delete them? I'm using Oracle8i on Solaris 2.7
> x86.
>
> Thanks!
>
> John Matzen
> Senior Programmer, Ultima Online
> Origin Systems, Inc.
> http://www.origin.ea.com/
>
>
>
>
Received on Wed Jun 21 2000 - 00:00:00 CDT