| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Archive log-switch after on-line backup
This is a multi-part message in MIME format.
------=_NextPart_000_1133_01C03F41.52AA71E0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear listers,
I have a problem in one of my 8.1.6 databases;
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.
I don't like this. Shouldn't Oracle write the .arc-file after a 'archive = log stop'?
I know I can solve it by querying the database for the active log = number, but it doesn't make things too easy.....
Here is what happens;
-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.arcSVRMGR> alter system switch logfile;
-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
Met vriendelijke groeten / With regards / Yst=E4v=E4llisin terveisin, Sonera Plaza Nederland B.V.
ERIC LANSU, RED-IT via Consense
Oracle DBA / UNIX system manager=20
------=_NextPart_000_1133_01C03F41.52AA71E0 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><FONT face=3DCourier size=3D2>Dear listers,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>I have a problem in one of my 8.1.6=20
databases;</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>After completing the on-line =
backup=20
(Begin/End backup) I do a 'archive log stop', but the .arc-file is NOT =
written=20
to disk, so my on-line backup is useless...</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>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 =
bytes=20
in it, so I move it too. Now I start the archiver again, and I get an =
IO-error=20
for Oracle can't find the archive-file. After some errors in the =
alert.log=20
Oracle creates a new .arc-file with the same number.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>I don't like this. Shouldn't Oracle =
write the=20
.arc-file after a 'archive log stop'?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>I know I can solve it by querying the =
database=20
for the active log number, but it doesn't make things too =
easy.....</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>Here is what happens;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>-rw-r----- 1 =
oracle =20
oinstall 536064 Oct 26 11:00 =
arch_1_31913.arc<BR>-rw-r----- 1=20
oracle oinstall 24064 Oct 26 11:02=20
arch_1_31914.arc<BR>SVRMGR> archive log stop<BR>Statement=20
processed.<BR>SVRMGR> !ls -l<BR>total =
608896<BR>-rw-r----- 1=20
oracle oinstall 536064 Oct 26 11:00=20
arch_1_31913.arc<BR>-rw-r----- 1 oracle =20
oinstall 24064 Oct 26 11:02 arch_1_31914.arc<BR>SVRMGR> =
alter=20
system switch logfile;<BR>Statement processed.<BR>SVRMGR> !ls =
-l<BR>total=20
608896<BR>-rw-r----- 1 oracle oinstall =
536064 Oct=20
26 11:00 arch_1_31913.arc<BR>-rw-r----- 1 oracle =
oinstall 24064 Oct 26 11:02 arch_1_31914.arc<BR>SVRMGR> =
archive=20
log start<BR>Statement processed.<BR>SVRMGR> !ls -l<BR>total=20
609200<BR>-rw-r----- 1 oracle oinstall =
536064 Oct=20
26 11:00 arch_1_31913.arc<BR>-rw-r----- 1 oracle =
oinstall 24064 Oct 26 11:02=20
arch_1_31914.arc<BR>-rw-r----- 1 oracle =
oinstall =20
143872 Oct 26 11:12 arch_1_31915.arc<BR>SVRMGR> alter system switch=20
logfile;<BR>Statement processed.<BR>SVRMGR> !ls -l<BR>total=20
609204<BR>-rw-r----- 1 oracle oinstall =
536064 Oct=20
26 11:00 arch_1_31913.arc<BR>-rw-r----- 1 oracle =
oinstall 24064 Oct 26 11:02=20
arch_1_31914.arc<BR>-rw-r----- 1 oracle =
oinstall =20
143872 Oct 26 11:12 arch_1_31915.arc<BR>-rw-r----- 1=20
oracle oinstall 2048 Oct 26 11:12=20
arch_1_31916.arc<BR></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>Anyone on this?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>Met vriendelijke groeten / With =
regards /=20
Yst=E4v=E4llisin terveisin,<BR>Sonera Plaza Nederland B.V.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>ERIC LANSU, RED-IT via =
Received on Thu Oct 26 2000 - 04:38:55 CDT
 |
 |