Re: Archive mode

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 31 Aug 2001 08:44:14 -0700
Message-ID: <F001.0037F6FF.20010831084713@fatcity.com>

This was posted awhile ago. Search the archives for additional information.

archiving-------
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.

ROR mª¿ªm

>>> jvilla_at_ccss.sa.cr 08/31/01 11:21AM >>>
Hello,

We will set the oracle database to archive mode. If any body have a step by step guide for this please send my it.

Thank's...

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
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).

Received on Fri Aug 31 2001 - 10:44:14 CDT