| 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: will log be generated during hot 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_01C0853E.2F3DC8FE
Content-Type: text/plain
Rahul,
This is a lesson I learned the hard way by being blasted by the list. Let's see if I can paraphrase this correctly.
First I'm assuming you are talking about hot backups. Putting a tablespace in backup mode means that any writes to that tablespace will incur writes to the online redo log of the changed data BLOCK. However consistency is maintained by keeping the SCN static for the datafiles. THerefore if you have to recover, the datafile will have a lesser SCN and recovery up to the latest SCN will be seen as necessary.
Which logs to keep? Keep them all unless you don't want to keep your database.
List: Correct me if I am stating this wrong... I had kept the email that had described it so clearly, but lovely LookOut has 'archived' (read: deleted) it.
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: Rahul [mailto:rahul_at_ratelindo.co.id]
Sent: Tuesday, January 23, 2001 5:00 AM
To: Multiple recipients of list ORACLE-L
Subject: will log be generated during hot backup ?
List,
will log generation (and archiving) continues during the backup of a
tablespace ?
if yes, then how will identify which logs to delete/keep after finish my hot
backup ?
regards
rahul sharma
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: rahul_at_ratelindo.co.id 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_01C0853E.2F3DC8FE Content-Type: text/html Content-Transfer-Encoding: quoted-printableReceived on Tue Jan 23 2001 - 07:12:48 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: will log be generated during hot backup ?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Rahul, </FONT>
</P>
<P><FONT SIZE=3D2>This is a lesson I learned the hard way by being =
blasted by the list. Let's see if I can paraphrase this = correctly. </FONT>
</P>
<P><FONT SIZE=3D2>First I'm assuming you are talking about hot =
backups. Putting a tablespace in backup mode means that any = writes to that tablespace will incur writes to the online redo log of = the changed data BLOCK. However consistency is maintained by = keeping the SCN static for the datafiles. THerefore if you have = to recover, the datafile will have a lesser SCN and recovery up to the = latest SCN will be seen as necessary. </FONT></P>
<P><FONT SIZE=3D2>Which logs to keep? Keep them all unless you =
don't want to keep your database.</FONT>
</P>
<P><FONT SIZE=3D2>List: Correct me if I am stating this =
wrong... I had kept the email that had described it so clearly, = but lovely LookOut has 'archived' (read: deleted) it.</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: Rahul [<A =
HREF=3D"mailto:rahul_at_ratelindo.co.id">mailto:rahul_at_ratelindo.co.id</A>]<= /FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, January 23, 2001 5:00 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: will log be generated during hot backup =
?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>List, </FONT>
<BR><FONT SIZE=3D2>will log generation (and archiving) continues during =
the backup of a</FONT>
<BR><FONT SIZE=3D2>tablespace ? </FONT>
<BR><FONT SIZE=3D2>if yes, then how will identify which logs to =
delete/keep after finish my hot</FONT>
<BR><FONT SIZE=3D2>backup ? </FONT>
</P>
<P><FONT SIZE=3D2>regards</FONT>
<BR><FONT SIZE=3D2>rahul sharma</FONT>
</P>
<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: Rahul</FONT>
<BR><FONT SIZE=3D2> INET: rahul_at_ratelindo.co.id</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>
 |
 |