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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
