Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Redo log files questions. Need help.

Redo log files questions. Need help.

From: Meomeo Nguyen <meomeo22_at_yahoo.com>
Date: Fri, 10 May 2002 14:08:23 -0800
Message-ID: <F001.0045EB6C.20020510140823@fatcity.com>

 I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then enabled automatic archiving of filled groups by setting

 log_archive_start=true

 in the database's parameter file. Finally I used

alter system archive log start;

to enable automatic archiving of filled online redo log group without shutting down the current instance. For some reason, when using the SQL*Plus statement

archive log list;

 it shows the archiving information for the connected instance:

database log mode ARCHIVELOG

automatic archival ENABLED

..........etc

But when I shutdown immediate then startup the instance with database open, I then issue the

archive log list; this time the

automatic archival DISABLED. Anyone came across this problem and had a fix. Please direct me how to fix it. I just wanted to archive online logs to multiple locations, then back up the archived logs. Please help.

Thanks in advance. Your help is greatly appreciated.

Trang



Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Meomeo Nguyen
  INET: meomeo22_at_yahoo.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). Received on Fri May 10 2002 - 17:08:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US