Message-Id: <10661.120385@fatcity.com> From: "Eric Lansu" Date: Fri, 27 Oct 2000 08:09:21 +0200 Subject: Re: Archive log-switch after on-line backup This is a multi-part message in MIME format. ------=_NextPart_000_12F1_01C03FED.364A9370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've tried everything already - that means a lot -. The start-stop was = suggested in the Oracle 8i DBA handbook by Kevin Loney and Marlene = Theriault. This doesn't work though, for the .arc-file is not written = after the 'archive log stop' so I won't have the .arc-file to roll = forward my hot backup.... Eric Lansu ----- Original Message -----=20 From: danut.bancea@ifl.bmo.ca=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, 26 October 2000 17:45 Subject: Re: Archive log-switch after on-line backup Hi,=20 I used this but without archive log stop. Why are you using archive = log stop statement ?=20 Danut,=20 "Eric Lansu" =20 Sent by: root@fatcity.com=20 10/26/00 06:25 AM=20 Please respond to ORACLE-L=20 =20 To: Multiple recipients of list ORACLE-L = =20 cc: =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...=20 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 =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 -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 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=20 ------=_NextPart_000_12F1_01C03FED.364A9370 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I've tried everything already - that = means a lot=20 -. The start-stop was suggested in the Oracle 8i DBA handbook by Kevin = Loney and=20 Marlene Theriault. This doesn't work though, for the .arc-file is not = written=20 after the 'archive log stop' so I won't have the .arc-file to roll = forward my=20 hot backup....

Eric Lansu

----- Original Message -----

From:=20 danut.bancea@ifl.bmo.ca

To: Multiple recipients of list ORACLE-L =

Sent: Thursday, 26 October 2000 = 17:45

Subject: Re: Archive log-switch = after=20 on-line backup

Hi, =

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

Danut,=20

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

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

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

Dear listers,

I have a = problem in one of=20 my 8.1.6 databases;

After = completing the=20 on-line backup (Begin/End backup) I do a 'archive log stop', but the = .arc-file=20 is NOT written to disk, so my on-line backup is useless... =
To avoid this, I do an 'alter system switch = logfile', and=20 then stop the archiver. I move the .arc-files to the backup-location. = That's=20 all? No, sometimes the next archive-file has 512 bytes in it, so I = move it=20 too. Now I start the archiver again, and I get an IO-error for Oracle = can't=20 find the archive-file. After some errors in the alert.log Oracle = creates a new=20 .arc-file with the same number.

I don't like = this.=20 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=20 number, but it doesn't make things too easy.....

Here=20 is what happens;
=20
-rw-r----- 1 oracle = oinstall=20 536064 Oct 26 11:00 arch_1_31913.arc
-rw-r----- 1 = oracle=20 oinstall 24064 Oct 26 11:02 = arch_1_31914.arc
SVRMGR>=20 archive log stop
Statement processed.
SVRMGR> !ls -l
total = 608896
-rw-r----- 1 oracle oinstall 536064 Oct = 26 11:00=20 arch_1_31913.arc
-rw-r----- 1 oracle oinstall = 24064=20 Oct 26 11:02 arch_1_31914.arc
SVRMGR> alter system switch=20 logfile;
Statement processed.
SVRMGR> !ls -l
total=20 608896
-rw-r----- 1 oracle oinstall 536064 Oct = 26 11:00=20 arch_1_31913.arc
-rw-r----- 1 oracle oinstall = 24064=20 Oct 26 11:02 arch_1_31914.arc
SVRMGR> archive log = start
Statement=20 processed.
SVRMGR> !ls -l
total 609200
-rw-r----- 1 = oracle=20 oinstall 536064 Oct 26 11:00 = arch_1_31913.arc
-rw-r-----=20 1 oracle oinstall 24064 Oct 26 11:02=20 arch_1_31914.arc
-rw-r----- 1 oracle oinstall = 143872=20 Oct 26 11:12 arch_1_31915.arc
SVRMGR> alter system switch=20 logfile;
Statement processed.
SVRMGR> !ls -l
total=20 609204
-rw-r----- 1 oracle oinstall 536064 Oct = 26 11:00=20 arch_1_31913.arc
-rw-r----- 1 oracle oinstall = 24064=20 Oct 26 11:02 arch_1_31914.arc
-rw-r----- 1 oracle = oinstall=20 143872 Oct 26 11:12 arch_1_31915.arc
-rw-r----- 1 = oracle=20 oinstall 2048 Oct 26 11:12 = arch_1_31916.arc

Anyone=20 on this?
=20

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