Re: Archive log-switch after on-line backup

Thanks for the url, but it's no help to me. What's in it isn't even correct!

First, my problem is that after a log-switch there is a veeery small start (512 bytes) of the current log as an .arc-file written to disk. If I move the files, I move this one too! Oracle keeps getting into a stress for it cannot find the .arc-file anymore....

What's wrong in the url-document you stated is;

Stephen Rea tels us to perform a 'archive log next', and then copy the files. This only writes the last FULL achive-log to disk. After doing a backup you want the CURRENT one, so you issue a 'archive log current'

Please correct me if I'm wrong....

Eric Lansu

• Original Message ----- From: "Radu Caulea" <radu.caulea_at_chello.fr> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, 26 October 2000 18:50 Subject: Re: Archive log-switch after on-line backup

> Here you are the nice url ;-)
>
> Radu Caulea
>
> http://www.uaex.edu/srea/bkupreco.htm
>
>
> On Thu, 26 Oct 2000 07:35:24 -0800, you wrote:
>
> >Eric,
> >
> >I also use an archive log switch. To avoid the situation you're
> >experiencing, I added a short "sleep" after the logfile switch to allow
> >(hopefully) my switched logfile to at least begin archiving. I then make
a
> >quick list of the files in the archive directory and use this list to
> >determine which archive logs to copy and delete.
> >
> >The command I use for listing is:
> >
> >ls /oracle/leads/redo/arch/*.ARC >logfile.lst
> >sleep 10
> >cat logfile.lst |
> >sed "s/\(.*\/\)\([^\/].*\)/mv \1\2 \/home1\/orabackup\/`date
> >+%b%dleads`\/\2/" >logfile.shl
> >sh logfile.shl
> >
> >The second "sleep" in this puppy is to allow the archive log to finish
> >archiving (hopefully) before the copy (move) process begins.
> >
> >I got this command from a white paper I found on the web after a
> >conversation about this very problem last year. I think perhaps Rachael
> >Carmichael looked over my previous script and suggested an improvement.
> >
> >Sorry, I don't have the URL.
> >
> >Hope this helps.
> >
> >
> >
> >David A. Barbour
> >Oracle DBA - ConnectSouth
> >512-681-9438
> >dbarbour_at_connectsouth.com
> >
> >-----Original Message-----
> >Sent: Thursday, October 26, 2000 5:25 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Dear listers,
> >
> >I have a problem in one of my 8.1.6 databases;
> >
> >After completing the on-line backup (Begin/End backup) I do a 'archive
log
> >stop', but the .arc-file is NOT written to disk, so my on-line backup is
> >useless...
> >To avoid this, I do an 'alter system switch logfile', and then stop the
> >archiver. I move the .arc-files to the backup-location. That's all? No,
> >sometimes the next archive-file has 512 bytes in it, so I move it too.
Now I
> >start the archiver again, and I get an IO-error for Oracle can't find the
> >archive-file. After some errors in the alert.log Oracle creates a new
> >.arc-file with the same number.
> >
> >I don't like this. Shouldn't Oracle write the .arc-file after a 'archive
log
> >stop'?
> >
> >I know I can solve it by querying the database for the active log number,
Received on Fri Oct 27 2000 - 01:15:59 CDT