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_01C03F70.7585E970
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
> -----Original Message-----
> From: Eric Lansu [SMTP:eric.lansu_at_quicknet.nl]
> Sent: Thursday, October 26, 2000 11:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Archive log-switch after on-line backup
>=20
> Dear listers,
> =20
> I have a problem in one of my 8.1.6 databases;
> =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
> I know I can solve it by querying the database for the active log =
number,
> but it doesn't make things too easy.....
> =20
> Here is what happens;
> =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
> =20
> Anyone on this?
> =20
> =20
> Met vriendelijke groeten / With regards / Yst=E4v=E4llisin terveisin,
> Sonera Plaza Nederland B.V.
> =20
> ERIC LANSU, RED-IT via Consense
> Oracle DBA / UNIX system manager=20
>=20
------_=_NextPart_001_01C03F70.7585E970
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 COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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?</FONT></P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR>
Satar</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From: </FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Eric Lansu [SMTP:eric.lansu_at_quicknet.nl]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent: </FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Thursday, October 26, 2000 11:25 AM</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To: </FONT></B> <FONT SIZE=3D1 =
FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject: </FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Arial">Archive log-switch after on-line =
backup</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier">Dear listers,</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">I have a problem in one of my 8.1.6 =
databases;</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">After=A0completing 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...</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier">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.</FONT></P>
<P><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">I don't like this. Shouldn't Oracle =
write the .arc-file after a 'archive log stop'?</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">I know I can solve it by querying =
the database for the active log number, but it doesn't make things too =
easy.....</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">Here is what happens;</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">-rw-r-----=A0=A0 1 oracle=A0=A0 =
oinstall=A0 536064 Oct 26 11:00 arch_1_31913.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0 24064 Oct 26 11:02 =
arch_1_31914.arc<BR>
SVRMGR> archive log stop<BR>
Statement processed.<BR>
SVRMGR> !ls -l<BR>
total 608896<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 536064 Oct 26 11:00 =
arch_1_31913.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0 24064 Oct 26 11:02 =
arch_1_31914.arc<BR>
SVRMGR> alter system switch logfile;<BR>
Statement processed.<BR>
SVRMGR> !ls -l<BR>
total 608896<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 536064 Oct 26 11:00 =
arch_1_31913.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0 24064 Oct 26 11:02 =
arch_1_31914.arc<BR>
SVRMGR> archive log start<BR>
Statement processed.<BR>
SVRMGR> !ls -l<BR>
total 609200<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 536064 Oct 26 11:00 =
arch_1_31913.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0 24064 Oct 26 11:02 =
arch_1_31914.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 143872 Oct 26 11:12 =
arch_1_31915.arc<BR>
SVRMGR> alter system switch logfile;<BR>
Statement processed.<BR>
SVRMGR> !ls -l<BR>
total 609204<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 536064 Oct 26 11:00 =
arch_1_31913.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0 24064 Oct 26 11:02 =
arch_1_31914.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0 143872 Oct 26 11:12 =
arch_1_31915.arc<BR>
-rw-r-----=A0=A0 1 oracle=A0=A0 oinstall=A0=A0=A0 2048 Oct 26 11:12 =
arch_1_31916.arc<BR>
</FONT><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">Anyone on this?</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier">Met vriendelijke groeten / With =
regards / Yst=E4v=E4llisin terveisin,<BR>
Sonera Plaza Nederland B.V.</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
Received on Thu Oct 26 2000 - 12:16:20 CDT
