| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive log-switch after on-line backup
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C043FF.8324A634
Content-Type: text/plain;
charset="iso-8859-1"
Deepender,
Without your online redo logs you are looking at incomplete recovery. However, you should rely upon your O/S backups to safeguard your online redo logs.
HTH
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Deepender_Gupta_at_escorts.co.in
[mailto:Deepender_Gupta_at_escorts.co.in]
Sent: Tuesday, October 31, 2000 10:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Archive log-switch after on-line backup
If we are having the full backup till the last archived logs (After log
switch) and we do not have the backup of the online rodologs and In case
we have to recover the database Can we do it without online redologs by
recreating the redologs after mounting the database.
Kindly give your views....
deepender gupta
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
@SMTP_at_Exchange
cc:
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.
> 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....
>
>
>
>
>
> >> > >I also use an archive log switch. To avoid the situation you're
> > 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,
> > >
> >
>> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: good_dba_at_hotmail.com 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Deepender_Gupta_at_escorts.co.in 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 also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C043FF.8324A634 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Archive log-switch after on-line backup</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Deepender, </FONT> </P> <P><FONT SIZE=3D2>Without your online redo logs you are looking at = incomplete recovery. However, you should rely upon your O/S = backups to safeguard your online redo logs. </FONT></P> <P><FONT SIZE=3D2>HTH</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Deepender_Gupta_at_escorts.co.in</FONT> <BR><FONT SIZE=3D2>[<A = HREF=3D"mailto:Deepender_Gupta_at_escorts.co.in">mailto:Deepender_Gupta_at_esc= orts.co.in</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, October 31, 2000 10:21 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Archive log-switch after on-line = backup</FONT> </P> <BR> <BR> <BR> <P><FONT SIZE=3D2>If we are having the full backup till the last = archived logs (After log</FONT> <BR><FONT SIZE=3D2>switch) and we do not have the backup of the online = rodologs and In case</FONT> <BR><FONT SIZE=3D2>we have to recover the database Can we do it without = online redologs by</FONT> <BR><FONT SIZE=3D2>recreating the redologs after mounting the = database.</FONT> <BR><FONT SIZE=3D2>Kindly give your views....</FONT> <BR><FONT SIZE=3D2>deepender gupta</FONT> </P> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2> @SMTP_at_Exchange</FONT> <BR><FONT SIZE=3D2>cc:</FONT> </P> <P><FONT SIZE=3D2>Hi,</FONT> </P> <P><FONT SIZE=3D2>Someone must have already suggested by now.. But the = best you could do is.</FONT> <BR><FONT SIZE=3D2>.</FONT> <BR><FONT SIZE=3D2>after you backup..</FONT> </P> <P><FONT SIZE=3D2>JUST switch the log files.. and backup till the most = recent.. Leave the</FONT> <BR><FONT SIZE=3D2>last</FONT> <BR><FONT SIZE=3D2>archive log file..</FONT> </P> <P><FONT SIZE=3D2>I am telling you to leave the last archive log is = because you have just</FONT> <BR><FONT SIZE=3D2>performed a switch and there is nothing in the one = that will be created</FONT> <BR><FONT SIZE=3D2>after the LOG SWITCH..</FONT> </P> <P><FONT SIZE=3D2>This leaves ORACLE to work with the most recent log = file.. and will not</FONT> <BR><FONT SIZE=3D2>create a duplicate log file.. (As stated in your = version).</FONT> </P> <P><FONT SIZE=3D2>You should be able to recover the database till the = time last switch</FONT> <BR><FONT SIZE=3D2>occured.. .. if LAST BACKUP is the only source of = recovery.</FONT> </P> <P><FONT SIZE=3D2>Dear Listers' please correct me, if i am = wrong.</FONT> </P> <P><FONT SIZE=3D2>Bye.</FONT> </P> <P><FONT SIZE=3D2>----- Original Message -----</FONT> <BR><FONT SIZE=3D2>To: "Multiple recipients of list ORACLE-L" = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>Sent: Friday, October 27, 2000 12:16 AM</FONT> </P> <BR> <P><FONT SIZE=3D2>> Thanks for the url, but it's no help to me. = What's in it isn't even</FONT> <BR><FONT SIZE=3D2>correct!</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> First, my problem is that after a log-switch = there is a veeery small</FONT> <BR><FONT SIZE=3D2>start</FONT> <BR><FONT SIZE=3D2>> (512 bytes) of the current log as an .arc-file = written to disk. If I move</FONT> <BR><FONT SIZE=3D2>> the files, I move this one too! Oracle keeps = getting into a stress for it</FONT> <BR><FONT SIZE=3D2>> cannot find the .arc-file anymore....</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> What's wrong in the url-document you stated = is;</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Stephen Rea tels us to perform a 'archive log = next', and then copy the</FONT> <BR><FONT SIZE=3D2>> files. This only writes the last FULL = achive-log to disk. After doing a</FONT> <BR><FONT SIZE=3D2>> backup you want the CURRENT one, so you issue a = 'archive log current'</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Please correct me if I'm wrong....</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Eric Lansu</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> ----- Original Message -----</FONT> <BR><FONT SIZE=3D2>> To: "Multiple recipients of list = ORACLE-L" <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> Sent: Thursday, 26 October 2000 18:50</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> > Here you are the nice url ;-)</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Radu Caulea</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > <A = HREF=3D"http://www.uaex.edu/srea/bkupreco.htm" = TARGET=3D"_blank">http://www.uaex.edu/srea/bkupreco.htm</A></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > On Thu, 26 Oct 2000 07:35:24 -0800, you = wrote:</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > >Eric,</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >I also use an archive log = switch. To avoid the situation you're</FONT> <BR><FONT SIZE=3D2>> > >experiencing, I added a short = "sleep" after the logfile switch to</FONT> <BR><FONT SIZE=3D2>allow</FONT> <BR><FONT SIZE=3D2>> > >(hopefully) my switched logfile to at = least begin archiving. I then</FONT> <BR><FONT SIZE=3D2>make</FONT> <BR><FONT SIZE=3D2>> a</FONT> <BR><FONT SIZE=3D2>> > >quick list of the files in the archive = directory and use this list to</FONT> <BR><FONT SIZE=3D2>> > >determine which archive logs to copy = and delete.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >The command I use for listing = is:</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >ls /oracle/leads/redo/arch/*.ARC = >logfile.lst</FONT> <BR><FONT SIZE=3D2>> > >sleep 10</FONT> <BR><FONT SIZE=3D2>> > >cat logfile.lst |</FONT> <BR><FONT SIZE=3D2>> > >sed "s/\(.*\/\)\([^\/].*\)/mv = \1\2 \/home1\/orabackup\/`date</FONT> <BR><FONT SIZE=3D2>> > >+%b%dleads`\/\2/" = >logfile.shl</FONT> <BR><FONT SIZE=3D2>> > >sh logfile.shl</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >The second "sleep" in this = puppy is to allow the archive log to finish</FONT> <BR><FONT SIZE=3D2>> > >archiving (hopefully) before the copy = (move) process begins.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >I got this command from a white paper = I found on the web after a</FONT> <BR><FONT SIZE=3D2>> > >conversation about this very problem = last year. I think perhaps</FONT> <BR><FONT SIZE=3D2>Rachael</FONT> <BR><FONT SIZE=3D2>> > >Carmichael looked over my previous = script and suggested an</FONT> <BR><FONT SIZE=3D2>improvement.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >Sorry, I don't have the URL.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >Hope this helps.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >David A. Barbour</FONT> <BR><FONT SIZE=3D2>> > >Oracle DBA - ConnectSouth</FONT> <BR><FONT SIZE=3D2>> > >512-681-9438</FONT> <BR><FONT SIZE=3D2>> > >dbarbour_at_connectsouth.com</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >-----Original Message-----</FONT> <BR><FONT SIZE=3D2>> > >Sent: Thursday, October 26, 2000 5:25 = AM</FONT> <BR><FONT SIZE=3D2>> > >To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >Dear listers,</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >I have a problem in one of my 8.1.6 = databases;</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >After completing the on-line backup = (Begin/End backup) I do a 'archive</FONT> <BR><FONT SIZE=3D2>> log</FONT> <BR><FONT SIZE=3D2>> > >stop', but the .arc-file is NOT = written to disk, so my on-line backup</FONT> <BR><FONT SIZE=3D2>is</FONT> <BR><FONT SIZE=3D2>> > >useless...</FONT> <BR><FONT SIZE=3D2>> > >To avoid this, I do an 'alter system = switch logfile', and then stop</FONT> <BR><FONT SIZE=3D2>the</FONT> <BR><FONT SIZE=3D2>> > >archiver. I move the .arc-files to the = backup-location. That's all?</FONT> <BR><FONT SIZE=3D2>No,</FONT> <BR><FONT SIZE=3D2>> > >sometimes the next archive-file has = 512 bytes in it, so I move it too.</FONT> <BR><FONT SIZE=3D2>> Now I</FONT> <BR><FONT SIZE=3D2>> > >start the archiver again, and I get an = IO-error for Oracle can't find</FONT> <BR><FONT SIZE=3D2>the</FONT> <BR><FONT SIZE=3D2>> > >archive-file. After some errors in the = alert.log Oracle creates a new</FONT> <BR><FONT SIZE=3D2>> > >.arc-file with the same number.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >I don't like this. Shouldn't Oracle = write the .arc-file after a</FONT> <BR><FONT SIZE=3D2>'archive</FONT> <BR><FONT SIZE=3D2>> log</FONT> <BR><FONT SIZE=3D2>> > >stop'?</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > >I know I can solve it by querying the = database for the active log</FONT> <BR><FONT SIZE=3D2>number,</FONT> <BR><FONT SIZE=3D2>> > >but it doesn't make things too = easy.....</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Eric Lansu</FONT> <BR><FONT SIZE=3D2>> INET: eric.lansu_at_quicknet.nl</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: Nikunj Gupta</FONT> <BR><FONT SIZE=3D2> INET: good_dba_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: </FONT> <BR><FONT SIZE=3D2> INET: Deepender_Gupta_at_escorts.co.in</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=Received on Wed Nov 01 2000 - 06:30:19 CST
 |
 |