Re: arch full, move files, but wont archive these files

quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprtdp7faszkogxn_at_haydn>...
> On 4 Aug 2003 04:37:05 -0700, yls177 <yls177_at_hotmail.com> wrote:
>
> > "Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message
> > news:<3f2cf8d4$0$49114$e4fe514c_at_news.xs4all.nl>...
> >> yls177 <yls177_at_hotmail.com> schreef in berichtnieuws
> >> c06e4d68.0308030327.18ab7d14_at_posting.google.com...
> >> | when arch is full, and we moved some files out of arch.. and then back
> >> | to arch again. the moved files to arch will not be archievd this time
> >> | since their log sequence number is lower than the archSID.log?
> >>
> >> Don't understand you completely, but let's explain a bit.
> >> When the database runs in archive log mode a redolog gets archived when
> >> it
> >> is full and switched. Check V$LOG en v$LOGFILE to see what redolog files
> >> exits and what there status is.
> >> When it can't be archived (like disk full) the archiver process keeps
> >> trying
> >> it. Eventually your database freezes because an unarchived redolog can't
> >> be
> >> rused.
> >> What you do with the archives is beyond control of the Oracle database.
> >> The
> >> database is not aware if it in any way.
> >> The only thing that matters is tha it's your task not to loose them and
> >> to
> >> have them available when the database needs them in case of recovery.
> >> What is the archSID.log? Info about redologswitches and archiving can be
> >> found in the alertSID.log.
> >
> > first and foremost, thanks for replying
> >
> > here is what happens
> > 1) arch is full
> > 2) moved some files from arch to mytemp
> > 3) this frees up the arch, and database no longer freezes
> > 4) backup script archiver runs.
> > 5) moved back files from mytemp to arch
> > 6) but now these files from mytemp cant be archived since their number
> > is lower than the current log in archsid.lgo
> >
> > do i make sense?
> >
>
>
> Do you by any chance mean you run RMAN to do backups?
>
> If so, instead of moving the files back and forth (not good for the old
> network bandwidth, I would have thought), why not jsut get RMAN to 'backup
> archivelog all delete input' in the first place?
>
> Otherwise, your scenario still doesn't make sense. What is archsid.lgo??
> It's no file of Oracle's I've ever heard of.
>
> What's this 'backup script archiver' that's being run? What does it look
> like? Who wrote it? Is it a shell script, an RMAN script, a batch file, or
> what?
>
> ~QM

sori folks, its archSID.log. this file contains the list of archived files that have been backedup up and then deleted. so back to my scenario, if the files in mytemp are moved back to arch directory, my script file wont backup these files as the archSid.log has contain the log sequence which is higher than those moved back arch files.

okay, folks, i am on sap, uisng brarchive on oracle. Received on Mon Aug 04 2003 - 23:58:47 CDT