Re: Archive log-switch after on-line backup

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Fri, 27 Oct 2000 07:34:56 +0200
Message-Id: <10661.120381@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_12DF_01C03FE8.67A282C0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: Archive log-switch after on-line backupThe problem is, I did.... But = on this 8.1.6 instance there was a veeeery small .arc-file already = created for the next redo-log. I don't know why this happens, but after = the move of all archive-logs to the backup-directory, Oracle lost track = of it. This caused a lot of IO-errors and other sh.. in the alert-file.

By the way, I changed the 'switch logfile' to 'switch logfile current' = so the file-write is done before the copy starts. It makes no difference = :-(

Eric Lansu

Original Message -----=20 From: Satar Naghshineh=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, 26 October 2000 20:30 Subject: RE: Archive log-switch after on-line backup

Why are you stopping the Archive process? Why not just issue a switch = logfile command and copy the archive log (along with previous archived = log files) to your backup storage device?

Regards,
Satar=20

-----Original Message-----=20
From: Eric Lansu [SMTP:eric.lansu_at_quicknet.nl]=20 Sent: Thursday, October 26, 2000 11:25 AM=20

    To:     Multiple recipients of list ORACLE-L=20
    Subject:        Archive log-switch after on-line backup=20

    Dear listers,=20
     =20
    I have a problem in one of my 8.1.6 databases;=20
     =20

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.

=20

I don't like this. Shouldn't Oracle write the .arc-file after a = 'archive log stop'?=20

=20

I know I can solve it by querying the database for the active log = number, but it doesn't make things too easy.....=20

=20

Here is what happens;=20
=20

8<=20

I deleted this part....=20

=20

  Anyone on this?=20
=20
=20

  Met vriendelijke groeten / With regards / Yst=E4v=E4llisin terveisin,   Sonera Plaza Nederland B.V.=20
=20

  ERIC LANSU, RED-IT via Consense
  Oracle DBA / UNIX system manager

------=_NextPart_000_12DF_01C03FE8.67A282C0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Archive log-switch after on-line backup</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>The problem is, I did.... But on this =

8.1.6=20
instance there was a veeeery small .arc-file already created for the = next=20
redo-log. I don't know why this happens, but after the move of all = archive-logs=20
to the backup-directory, Oracle lost track of it. This caused a lot of = IO-errors=20
and other sh.. in the alert-file.</DIV> <DIV> </DIV>
<DIV>By the way, I changed the 'switch = logfile' to=20
'switch logfile current' so the file-write is done before the copy = starts. It=20
makes no difference :-(</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:Satar.Naghshineh_at_irvine.mellesgriot.com"=20 title=3DSatar.Naghshineh_at_irvine.mellesgriot.com>Satar Naghshineh</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Thursday, 26 October 2000 =

20:30</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: RE: Archive log-switch = after=20
 on-line backup</DIV>
 <DIV> </DIV>
 Why are you stopping = the Archive=20
 process? Why not just issue a switch logfile command and copy the = archive log=20
 (along with previous archived log files) to your backup storage=20 device?
 Regards, Satar 
 <UL>
 -----Original Message----- = <FONT=20

face=3DArial size=3D1>From:   Eric=20

Lansu [<A=20
=
href=3D"mailto:SMTP:eric.lansu_at_quicknet.nl">SMTP:eric.lansu_at_quicknet.nl</= A>]=20

Sent:   = <FONT face=3DArial=20

size=3D1>Thursday, October 26, 2000 11:25 AM <FONT = face=3DArial=20

size=3D1>To:     Multiple recipients of list ORACLE-L <FONT =

face=3DArial=20
    =
size=3D1>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> =

<FONT=20

face=3DArial size=3D1>Archive log-switch after on-line backup =

Dear listers, <FONT=20 face=3DArial>  I have = a problem in=20

one of my 8.1.6 databases;  =20

After completing the on-line = backup=20

(Begin/End backup) I do a 'archive log stop', but the .arc-file is = NOT=20
written to disk, so my on-line backup is useless... To avoid this, I do an 'alter = system switch=20

logfile', and then stop the archiver. I move the .arc-files to the=20 backup-location. That's all? No, sometimes the next archive-file has = 512=20

bytes in it, so I move it too. Now I start the archiver again, and I = get an=20

IO-error for Oracle can't find the archive-file. After some errors = in the=20

alert.log Oracle creates a new .arc-file with the same = number.</UL>
   I don't like=20
 this. Shouldn't Oracle write the .arc-file after a 'archive log = stop'?=20
   I know I can=20
 solve it by querying the database for the active log number, but it = doesn't=20
 make things too easy.....   = <FONT=20
 face=3DCourier size=3D2>Here is what happens;  <FONT=20 face=3DArial>   8<

  <P><FONT face=3DCourier size=3D2>I deleted this part.... </FONT></P>
  <P><FONT face=3DCourier size=3D2>&gt;8</FONT></P>
  <P><FONT face=3DArial>&nbsp;</FONT> <BR><FONT face=3DCourier =

size=3D2>Anyone on=20
 this?   <FONT=20 face=3DArial>  Met = vriendelijke=20
 groeten / With regards / Yst=E4v=E4llisin terveisin, Sonera Plaza = Nederland=20
 B.V.   <FONT = Received on Fri Oct 27 2000 - 00:34:56 CDT