| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ARCHIVELOG start
if database is in no archive log mode and you have automatic archival
enabled(init para) .. oracle simply ignores it ..
atleast for 8i
deepAk
-----Original Message-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Tuesday, June 13, 2000 6:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ARCHIVELOG start
Let's backup a minute... To start automatic archiving you need to either: 1) change the init.ora parm and restart the database; or 2) issue "archive log start" from svrmgrl. You can have archiving started but not have the database in archivelog mode. See the below listing:
Database log mode No Archive Mode Automatic archival Enabled Archive destination /u01/oracle/product/8.1.6/dbs/arch Oldest online log sequence 2140 Current log sequence 2142
But to implement archiving you need to shutdown the database, startup mount, alter database archivelog, archive log start, alter database open, then do an "archive log list" to make sure both the database is in log mode AND automatic archiving is enabled.
I once left automatic archiving enabled on a database that wasn't in archivelog mode. Eventually when it wrapped around and started having "recursive SQL errors" until it crashed. At least that's the way it was in Oracle 7.3. Right?
Steve Orr
Silicon Valley
-----Original Message-----
Winnie_Liu_at_infonet.com
Sent: Tuesday, June 13, 2000 5:14 PM
To: Multiple recipients of list ORACLE-L
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)
Confusing at first isn't it?
'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 also send the HELP command for other information (like subscribing). -- Author: INET: Winnie_Liu_at_infonet.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). -- Author: Steve Orr INET: sorr_at_arzoo.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-LReceived on Tue Jun 13 2000 - 19:58:08 CDT
 |
 |