Re: Archive log-switch after on-line backup

From: <danut.bancea_at_ifl.bmo.ca>
Date: Thu, 26 Oct 2000 10:41:54 -0400
Message-Id: <10661.120288@fatcity.com>

This is a multipart message in MIME format. --=_alternative 0050BD9985256984_=
Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

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

Danut,

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

=20

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:=20
        Subject:        Archive log-switch after on-line backup

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=20 useless...
To avoid this, I do an 'alter system switch logfile', and then stop the=20 archiver. I move the .arc-files to the backup-location. That's all? No,=20 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=20 the archive-file. After some errors in the alert.log Oracle creates a new=20 .arc-file with the same number.
=20
I don't like this. Shouldn't Oracle write the .arc-file after a 'archive=20 log stop'?
=20
I know I can solve it by querying the database for the active log number,=20 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=5F1=5F31913.arc -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch=5F1=5F31914.arc SVRMGR> archive log stop
Statement processed.
SVRMGR> !ls -l
total 608896
-rw-r----- 1 oracle oinstall 536064 Oct 26 11:00 arch=5F1=5F31913.arc -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch=5F1=5F31914.arc SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> !ls -l
total 608896
-rw-r----- 1 oracle oinstall 536064 Oct 26 11:00 arch=5F1=5F31913.arc -rw-r----- 1 oracle oinstall 24064 Oct 26 11:02 arch=5F1=5F31914.arc SVRMGR> archive log start
Statement processed.
SVRMGR> !ls -l
total 609200

-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch=5F1=5F31913.arc
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch=5F1=5F31914.arc
-rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch=5F1=5F31915.arc

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

-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch=5F1=5F31913.arc
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch=5F1=5F31914.arc
-rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch=5F1=5F31915.arc
-rw-r-----   1 oracle   oinstall    2048 Oct 26 11:12 arch=5F1=5F31916.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

--=_alternative 0050BD9985256984_=
Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

 Hi,
 
 I used this but without <font=
size=3D2 face=3D"Courier">archive log stop. Why are you using archiv= e log stop statement ?
 
 Danut,
 
 
 
<table width=3D100%>
<tr valign=3Dtop>
<td>
<td>"Eric Lansu" <eric.l=
ansu_at_quicknet.nl>
 Sent by: root_at_fatcity.com
10/26/00 06:25 AM
 Please respond to ORACLE-L
 
<td>        
         To: &nbs=
p;      Multiple recipients of list ORACLE-L <ORACLE-L_at_fa= tcity.com>
         cc: &nbs=
p;      
         Subject:=
       Archive log-switch after on-line backup<= /table>
 
 Dear listers,
  
 I have a problem in one of my 8.1.6 dat=
abases;
  
 After completing the on-line backup (Be=
gin/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 sw=

itch logfile', and then stop the archiver. I move the .arc-files to the bac=
kup-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-e=
rror 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 wri=
te the .arc-file after a 'archive log stop'?
  
 I know I can solve it by querying the d=
atabase for the active log number, but it doesn't make things too easy.....=

  
 Here is what happens;
  
 -rw-r-----   1 oracle   oinst=
all  536064 Oct 26 11:00 arch=5F1=5F31913.arc -rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch= =5F1=5F31914.arc 
SVRMGR> archive log stop 
Statement processed. 
SVRMGR> !ls -l 
total 608896 
-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch= =5F1=5F31913.arc 
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch= =5F1=5F31914.arc 
SVRMGR> alter system switch logfile; Statement processed. 
SVRMGR> !ls -l 
total 608896 
-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch= =5F1=5F31913.arc 
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch= =5F1=5F31914.arc 
SVRMGR> archive log start 
Statement processed. 
SVRMGR> !ls -l 
total 609200 
-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch= =5F1=5F31913.arc 
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch= =5F1=5F31914.arc 
-rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch= =5F1=5F31915.arc 
SVRMGR> alter system switch logfile; Statement processed. 
SVRMGR> !ls -l 
total 609204 
-rw-r-----   1 oracle   oinstall  536064 Oct 26 11:00 arch= =5F1=5F31913.arc 
-rw-r-----   1 oracle   oinstall   24064 Oct 26 11:02 arch= =5F1=5F31914.arc 
-rw-r-----   1 oracle   oinstall  143872 Oct 26 11:12 arch= =5F1=5F31915.arc 
-rw-r-----   1 oracle   oinstall    2048 Oct 26 11:12 a= rch=5F1=5F31916.arc 
 Anyone on this?
  
  
 Met vriendelijke groeten / With regards=
/ Yst=E4v=E4llisin terveisin, 
Sonera Plaza Nederland B.V.
  
Received on Thu Oct 26 2000 - 09:41:54 CDT