Re: Archive log-switch after on-line backup

Hi,

Someone must have already suggested by now.. But the best you could do is. . after you backup..

JUST switch the log files.. and backup till the most recent.. Leave the last archive log file..

I am telling you to leave the last archive log is because you have just performed a switch and there is nothing in the one that will be created after the LOG SWITCH..

This leaves ORACLE to work with the most recent log file.. and will not create a duplicate log file.. (As stated in your version).

You should be able to recover the database till the time last switch occured.. .. if LAST BACKUP is the only source of recovery.

Dear Listers' please correct me, if i am wrong.

Bye.

• Original Message ----- From: "Eric Lansu" <eric.lansu_at_quicknet.nl> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 27, 2000 12:16 AM Subject: 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, 26 October 2000 18:50
>
>
> > 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,
> > >but it doesn't make things too easy.....
> > >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric Lansu
> INET: eric.lansu_at_quicknet.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Sat Oct 28 2000 - 03:04:02 CDT