Message-Id: <10661.120288@fatcity.com> From: danut.bancea@ifl.bmo.ca Date: Thu, 26 Oct 2000 10:41:54 -0400 Subject: Re: Archive log-switch after on-line backup 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" Sent by: root@fatcity.com 10/26/00 06:25 AM Please respond to ORACLE-L =20 To: Multiple recipients of list ORACLE-L 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 archive log stop. Why are you using archiv= e log stop statement ?

Danut,


"Eric Lansu" <eric.l= ansu@quicknet.nl>
Sent by: root@fatcity.com

10/26/00 06:25 AM
Please respond to ORACLE-L

       
        To: &nbs= p;      Multiple recipients of list ORACLE-L <ORACLE-L@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.