| 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
This is a multi-part message in MIME format.
--------------0086083C67F509407A95ED02 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Ron Rogers wrote:
> Varad
> As discussed in one of the previous threads about archivelog mode:
>
> 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.
>
> 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:
> --------------------------------
> SVRMGR> archive log start
> Statement processed.
> SVRMGR> archive log list
> 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
> SVRMGR>
> ---------------------------------
>
> 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?
>
> Sorry I can't give credit to the person that wrote this info, but the steps described work to a tee.
> Ron ROgers
> DBA
> Atl.GA
> >>> vrajan_at_hsc.hac.com 06/21/00 01:44PM >>>
> I wanted to turn the Archivelog mode on and if I change the parameter
> in the init.ora file and issue the SQL command
> "ALTER DATABASE ARCHIVELOG', is it enough or do I need to do something
> more. I appreciate your replies. Thanks.
>
> ..Varad
>
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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).
Thanks Ron for you reply. I appreciate very much.
..Varad
--------------0086083C67F509407A95ED02
Content-Type: text/x-vcard; charset=us-ascii;
name="vrajan.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Rajan Varad G Content-Disposition: attachment;
begin:vcard
n:Rajan;Varad
x-mozilla-html:FALSE
org:Hughes Space and Communications;Information Technology
adr:;;;;;;
version:2.1
email;internet:varad.rajan_at_hsc.hac.com
title:Technical Staff
note;quoted-printable:Ph: 310-662-5195=0D=0AFax: 310-364-5933
Received on Wed Jun 21 2000 - 14:01:38 CDT
 |
 |