| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Turn on Archivelog mode..
Morning 'load',
Ok, for Oracle newbies I recommend :
Expert one-on-one Oracle by Thomas Kyte (he of Oracle guru fame) Wrox Press, ISBN : 1-861004-82-6
Beginning Oracle Programming by Sean Dillon, Christopher Beck,Thomas Kyte, Joel Kallman and our very own Howard J Rogers (et al as he is usually known !) Wrox Press, ISBN : 1-861006-90-X
I know the second one seems to be about programming, but trust me, it covers everything you need to know and a few other bits as well about the Oracle database, how it works and why.
HTH
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------
-----Original Message-----
From: loadofcr_ap_at_yahoo.com (gOD) [mailto:loadofcr_ap_at_yahoo.com]
Posted At: Monday, January 27, 2003 6:51 PM
Posted To: server
Conversation: Turn on Archivelog mode..
Subject: Re: Turn on Archivelog mode..
Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:<E2F6A70FE45242488C865C3BC1245DA703399DA7_at_lnewton.leeds.lfs.co.uk>.
..
> Afternoon 'Load',
>
> I have the same feelings towards Yahoo as you do :o)
>
> You asked :
>
> >> I have edited my .ora file and pasted those lines in, but I though
> >> that just enables automatic archiving and the documenation seems to
> >> show that this is actually completely different changing ARCHIVELOG
> >> mode. Excuse my ignorance, but are they two things (enabling
> >> ARCHIVELOG, and enabling automatic archive) actually the same?
>
> It's a two stage thingy this archive logging. The first stage is to
> configure and turn on the ARCH process. This is what you are doing in
> the initSID.ora file. The ARCH process runs in the background and
copies
> full log file off to the location you specified and gives the
filenames
> in the format you specified. It does this when it is 'told' that a log
> file has become full.
>
> The second stage is to put the database in archivelog mode which,
which
> is what you have to do in SQL. Amongst other things, allows the ARCH
> process to 'know' when to do it's stuff, and also, to protect the
online
> log files from being overwritten until such time as ARCH has done the
> copy to a safe place. This answers you following query :
>
> >> Also, do I actually have to run the stuff in SQLPlus? Can't I just
> >> configure the .ORA file and bounce the box? :)
>
> Basically, the archiving process is :
>
> If you have 3 logfile, A, B and C, then when A is full up ARCH will be
> asked to copy it somewhere and B will be used.
> When B fills, ARCH gets told to copy B and the database starts using
C.
> When C fills, ARCH gets told to copy it, and the database will start
> using A again - and so on.
>
> However, if ARCH has not finished copying A - say due to a lack of
space
> - then the database will hang awaiting a fix. The alert log will give
> details - about waiting for logs to be archived.
>
> HTH and apologies if you already know the above :o)
>
> Cheers,
> Norman.
>
Cheers for you information. Should be plenty to keep me going until I have decypted the 800+ pages of the admin guide and the 200+ pages of the backup/recovery guide!
Cheers Received on Tue Jan 28 2003 - 02:18:08 CST
 |
 |