Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: When can I delete these arch1_*.dbf files?

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

From: Lehmann <LehmNOannSPAM_at_netuse.dk>
Date: 2000/06/21
Message-ID: <961574080.696694@ns.cci.dk>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US