Re: ARCHIVELOG start

Confusing at first isn't it?

1. The init.ora parameter log_archive_start is to start the archiver process(es) when the database starts.
2. 'alter database archivelog' puts the database in archive log mode.
3. 'alter system archive log start' starts automatic archiving.

'Oracle Backup and Recovery Handbook' states that either of 1 or 3 is necessary.

I must confess that I do all 3 when putting a database in archive mode.

Jared

On Tue, 13 Jun 2000 Lisa_Koivu_at_gelco.com wrote:

> Good morning -
>
> I've created about 5 databases in the last week. Why is it that I can set
> log_archive_start=TRUE but when the database comes up the first time it's in
> noarchive mode? I have to manually put it in archive mode - after I do that,
> the database will come up in archive mode every time.
>
> Just wondering....
> Lisa
> Minneapolis,MN,USA
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue Jun 13 2000 - 15:32:24 CDT