Re: Archive log-switch after on-line backup

Here you are the nice url ;-)

Radu Caulea

http://www.uaex.edu/srea/bkupreco.htm

On Thu, 26 Oct 2000 07:35:24 -0800, you wrote:

>Eric,
>=20
>I also use an archive log switch. To avoid the situation you're
>experiencing, I added a short "sleep" after the logfile switch to allow
>(hopefully) my switched logfile to at least begin archiving. I then =
make a
>quick list of the files in the archive directory and use this list to
>determine which archive logs to copy and delete.
>=20
>The command I use for listing is:
>=20
>ls /oracle/leads/redo/arch/*.ARC >logfile.lst
>sleep 10
>cat logfile.lst |
>sed "s/\(.*\/\)\([^\/].*\)/mv \1\2 \/home1\/orabackup\/`date
>+%b%dleads`\/\2/" >logfile.shl
>sh logfile.shl
>=20
>The second "sleep" in this puppy is to allow the archive log to finish
>archiving (hopefully) before the copy (move) process begins.
>=20
>I got this command from a white paper I found on the web after a
>conversation about this very problem last year. I think perhaps Rachael
>Carmichael looked over my previous script and suggested an improvement.
>=20
>Sorry, I don't have the URL.
>=20
>Hope this helps.
>
>=20
>
>David A. Barbour=20
>Oracle DBA - ConnectSouth=20
>512-681-9438=20
>dbarbour_at_connectsouth.com=20
>
>-----Original Message-----
>Sent: Thursday, October 26, 2000 5:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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
>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
>I know I can solve it by querying the database for the active log =
number,
>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_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
>=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
>

--=20
Radu 'kernel' Caulea, http://perso.club-internet.fr/caulea/ Received on Thu Oct 26 2000 - 10:48:10 CDT