Re: Archive log-switch after on-line backup

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Fri, 27 Oct 2000 08:09:21 +0200
Message-Id: <10661.120385@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_12F1_01C03FED.364A9370 Content-Type: text/plain;

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

I've tried everything already - that means a lot -. The start-stop was = suggested in the Oracle 8i DBA handbook by Kevin Loney and Marlene = Theriault. This doesn't work though, for the .arc-file is not written = after the 'archive log stop' so I won't have the .arc-file to roll = forward my hot backup....

Eric Lansu

Original Message -----=20 From: danut.bancea_at_ifl.bmo.ca=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, 26 October 2000 17:45 Subject: Re: Archive log-switch after on-line backup

Hi,=20

I used this but without archive log stop. Why are you using archive = log stop statement ?=20

Danut,=20

       "Eric Lansu" <eric.lansu_at_quicknet.nl>=20
        Sent by: root_at_fatcity.com=20
        10/26/00 06:25 AM=20
        Please respond to ORACLE-L=20

              =20
                To:        Multiple recipients of list ORACLE-L =


<ORACLE-L_at_fatcity.com>=20

                cc:        =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...=20
  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

=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
  -rw-r----- 1 oracle oinstall 536064 Oct 26 11:00 arch_1_31913.arc   -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch_1_31914.arc   SVRMGR> archive log stop
  Statement processed.
  SVRMGR> !ls -l
  total 608896
  -rw-r----- 1 oracle oinstall 536064 Oct 26 11:00 arch_1_31913.arc   -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch_1_31914.arc   SVRMGR> alter system switch logfile;
  Statement processed.
  SVRMGR> !ls -l
  total 608896
  -rw-r----- 1 oracle oinstall 536064 Oct 26 11:00 arch_1_31913.arc   -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch_1_31914.arc   SVRMGR> archive log start
  Statement processed.
  SVRMGR> !ls -l
  total 609200

  -rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch_1_31913.arc
  -rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch_1_31914.arc
  -rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch_1_31915.arc

  SVRMGR> alter system switch logfile;
  Statement processed.
  SVRMGR> !ls -l
  total 609204

  -rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch_1_31913.arc
  -rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch_1_31914.arc
  -rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch_1_31915.arc
  -rw-r-----   1 oracle   oinstall    2048 Oct 26 11:12 arch_1_31916.arc

  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=20

------=_NextPart_000_12F1_01C03FED.364A9370 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>
<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>I've tried everything already - that =
means a lot=20
-. The start-stop was suggested in the Oracle 8i DBA handbook by Kevin = Loney and=20
Marlene Theriault. This doesn't work though, for the .arc-file is not = written=20
after the 'archive log stop' so I won't have the .arc-file to roll = forward my=20
hot backup....</DIV>
<DIV> </DIV>
<DIV>Eric Lansu</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">&nbsp;</DIV>
  <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:danut.bancea_at_ifl.bmo.ca"=20 title=3Ddanut.bancea_at_ifl.bmo.ca>danut.bancea_at_ifl.bmo.ca</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 =

17:45</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: Re: Archive log-switch = after=20
 on-line backup</DIV>
 <DIV> </DIV> Hi, =
 <FONT=20

 face=3Dsans-serif size=3D2>I used this but without archive log stop. Why = are you using=20
 archive log stop statement ? Danut,=20
 
 <TABLE width=3D"100%">
 <TBODY>
 <TR vAlign=3Dtop>

      <TD>
      <TD><FONT face=3Dsans-serif size=3D1><B>"Eric Lansu" &lt;<A=20
        =

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

        <BR><FONT face=3Dsans-serif size=3D1>Sent by: <A=20
        href=3D"mailto:root_at_fatcity.com">root_at_fatcity.com</A></FONT>=20
        <P><FONT face=3Dsans-serif size=3D1>10/26/00 06:25 AM</FONT> =


<BR><FONT=20

        face=3Dsans-serif size=3D1>Please respond to ORACLE-L</FONT> =


<BR></P>

      <TD><FONT face=3DArial size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; =


</FONT><BR><FONT=20

        face=3Dsans-serif size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; To: =
&nbsp; &nbsp;=20
        &nbsp; &nbsp;Multiple recipients of list ORACLE-L &lt;<A=20
        =

href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>> =

= cc:  =20

=20

      Subject:        Archive =

log-switch after on-line =
backup</TR></TBODY></TABLE> <FONT=20 face=3DCourier size=3D2>Dear listers,   I have a = problem in one of=20
 my 8.1.6 databases;   After = completing the=20
 on-line backup (Begin/End backup) I do a 'archive log stop', but the = .arc-file=20
 is NOT written to disk, so my on-line backup is useless... =
 <FONT=20

 face=3DCourier size=3D2>To avoid this, I do an 'alter system switch = logfile', and=20
 then stop the archiver. I move the .arc-files to the backup-location. = That's=20
 all? No, sometimes the next archive-file has 512 bytes in it, so I = move it=20
 too. Now I start the archiver again, and I get an IO-error for Oracle = can't=20
 find the archive-file. After some errors in the alert.log Oracle = creates a new=20
 .arc-file with the same number.   I don't like = this.=20
 Shouldn't Oracle write the .arc-file after a 'archive log = stop'?=20
   I know I can solve it by querying the database for the active = log=20
 number, but it doesn't make things too easy..... <FONT=20 face=3D"Times New Roman" size=3D3>  Here=20
 is what happens;  =20
 -rw-r-----   1 oracle   = oinstall=20
  536064 Oct 26 11:00 arch_1_31913.arc -rw-r-----   1 = oracle=20
   oinstall   24064 Oct 26 11:02 = arch_1_31914.arc SVRMGR>=20
 archive log stop Statement processed. SVRMGR> !ls -l total =

608896 -rw-r-----   1 oracle   oinstall  536064 Oct = 26 11:00=20
 arch_1_31913.arc -rw-r-----   1 oracle   oinstall   = 24064=20
 Oct 26 11:02 arch_1_31914.arc SVRMGR> alter system switch=20 logfile; Statement processed. SVRMGR> !ls -l total=20 608896 -rw-r-----   1 oracle   oinstall  536064 Oct = 26 11:00=20
 arch_1_31913.arc -rw-r-----   1 oracle   oinstall   = 24064=20
 Oct 26 11:02 arch_1_31914.arc SVRMGR> archive log = start Statement=20
 processed. SVRMGR> !ls -l total 609200 -rw-r-----   1 = oracle=20
   oinstall  536064 Oct 26 11:00 = arch_1_31913.arc -rw-r-----=20
   1 oracle   oinstall   24064 Oct 26 11:02=20 arch_1_31914.arc -rw-r-----   1 oracle   oinstall =  143872=20
 Oct 26 11:12 arch_1_31915.arc SVRMGR> alter system switch=20 logfile; Statement processed. SVRMGR> !ls -l total=20 609204 -rw-r-----   1 oracle   oinstall  536064 Oct = 26 11:00=20
 arch_1_31913.arc -rw-r-----   1 oracle   oinstall   = 24064=20
 Oct 26 11:02 arch_1_31914.arc -rw-r-----   1 oracle   = oinstall=20
  143872 Oct 26 11:12 arch_1_31915.arc -rw-r-----   1 = oracle=20
   oinstall    2048 Oct 26 11:12 = arch_1_31916.arc<FONT=20
 face=3D"Times New Roman" size=3D3> Anyone=20
 on this?  =20
   Met vriendelijke groeten / With regards / Yst=E4v=E4llisin=20 terveisin, Sonera Plaza Nederland B.V. <FONT=20 Received on Fri Oct 27 2000 - 01:09:21 CDT