RE: redo logs

It appears that you are unable to switch online redo logs. Are you in archive log mode? Is archiver enabled? If so, it's possible that the archive destination is full, or archiving is enabled but archiver is not, thus you will need to manually archive the redo logs.

Connect as sysdba (using svrmgrl or sqlplus if using 8.1.5) and type the command "archive log list." This will tell you whether your in archive log mode, the archive destination and whether archiver is enabled. Also take a look at v$log if the above is true, too see the whether there are logs that need to be archived.

Comments and corrections are welcome.

James
-----Original Message-----
From: achoto_at_american.edu [mailto:achoto_at_american.edu] Sent: Wednesday, July 12, 2000 8:50 AM
To: Multiple recipients of list ORACLE-L Subject: redo logs

We're getting the following messages in the alert log. Can a kind soul in the list enlighten me with potential problems and the possible cause? Thanks in advance.

Thread 1 advanced to log sequence 7048
  Current log# 2 seq# 7048 mem# 0: /oracle03/oradata/ORTE/redoORTE02.log Wed Jul 12 06:30:47 2000
Thread 1 cannot allocate new log, sequence 7049 Checkpoint not complete
  Current log# 2 seq# 7048 mem# 0: /oracle03/oradata/ORTE/redoORTE02.log Wed Jul 12 06:31:12 2000

Thanks

Ana E. Choto
Systems Programmer
American University
Office of Information Technology
Phone (202) 885-2275
Fax (202) 885-2224

-- 
Author: 
  INET: achoto_at_american.edu

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