Message-Id: <10661.120381@fatcity.com> From: "Eric Lansu" Date: Fri, 27 Oct 2000 07:34:56 +0200 Subject: Re: Archive log-switch after on-line backup This is a multi-part message in MIME format. ------=_NextPart_000_12DF_01C03FE8.67A282C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Archive log-switch after on-line backupThe problem is, I did.... But = on this 8.1.6 instance there was a veeeery small .arc-file already = created for the next redo-log. I don't know why this happens, but after = the move of all archive-logs to the backup-directory, Oracle lost track = of it. This caused a lot of IO-errors and other sh.. in the alert-file. By the way, I changed the 'switch logfile' to 'switch logfile current' = so the file-write is done before the copy starts. It makes no difference = :-( Eric Lansu ----- Original Message -----=20 From: Satar Naghshineh=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, 26 October 2000 20:30 Subject: RE: Archive log-switch after on-line backup 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=20 -----Original Message-----=20 From: Eric Lansu [SMTP:eric.lansu@quicknet.nl]=20 Sent: Thursday, October 26, 2000 11:25 AM=20 To: Multiple recipients of list ORACLE-L=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... 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 =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 8<=20 I deleted this part....=20 >8 =20 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 ------=_NextPart_000_12DF_01C03FE8.67A282C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Archive log-switch after on-line backup
The problem is, I did.... But on this = 8.1.6=20 instance there was a veeeery small .arc-file already created for the = next=20 redo-log. I don't know why this happens, but after the move of all = archive-logs=20 to the backup-directory, Oracle lost track of it. This caused a lot of = IO-errors=20 and other sh.. in the alert-file.
 
By the way, I changed the 'switch = logfile' to=20 'switch logfile current' so the file-write is done before the copy = starts. It=20 makes no difference :-(
 
Eric Lansu
----- Original Message -----
From:=20 Satar Naghshineh =
To: Multiple recipients of list ORACLE-L =
Sent: Thursday, 26 October 2000 = 20:30
Subject: RE: Archive log-switch = after=20 on-line backup

Why are you stopping = the Archive=20 process? Why not just issue a switch logfile command and copy the = archive log=20 (along with previous archived log files) to your backup storage=20 device?

Regards,
Satar

    -----Original Message----- =
    From:   Eric=20 Lansu [SMTP:eric.lansu@quicknet.nl]=20
    Sent:   = Thursday, October 26, 2000 11:25 AM
    To:     Multiple recipients of list ORACLE-L
    Subject:        = Archive log-switch after on-line backup =

    Dear listers,
     
    I have = a problem in=20 one of my 8.1.6 databases;
     =20
    After completing the on-line = backup=20 (Begin/End backup) I do a 'archive log stop', but the .arc-file is = NOT=20 written to disk, so my on-line backup is useless...

    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=20 bytes in it, so I move it too. Now I start the archiver again, and I = get an=20 IO-error for Oracle can't find the archive-file. After some errors = in the=20 alert.log Oracle creates a new .arc-file with the same = number.

 
I don't like=20 this. Shouldn't Oracle write the .arc-file after a 'archive log = stop'?=20
 
I know I can=20 solve it by querying the database for the active log number, but it = doesn't=20 make things too easy.....
  =
Here is what happens; 
  
8<

I deleted this part....

>8

 
Anyone on=20 this?
 
 
Met = vriendelijke=20 groeten / With regards / Yst=E4v=E4llisin terveisin,
Sonera Plaza = Nederland=20 B.V.