Re: ARCHIVELOG start

Jared,

The backup and recovery book is right. You only have to do either 1. or 3. to make the database into archivelog mode.

If you don't have that init.ora parameter set (log_archive_start) during startup, the archiver process is not started. Then even though you put the database in archivelog mode, there is no process to do the archive. That is why you will need to last one (alter system archive log start).

Winnie

Jared Still <jkstill_at_bcbso.com> on 06/13/2000 02:58:32 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: 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 jkstill_at_teleport.com - private

--
Author: Jared Still
  INET: jkstill_at_bcbso.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