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

Home -> Community -> Mailing Lists -> Oracle-L -> Archive logging

Archive logging

From: Steven Hovington <steven.hovington_at_procession.com>
Date: Thu, 16 Sep 2004 13:59:37 +0100
Message-ID: <NDBBIPACFBMBIPHABLLAKEHGPOAA.steven.hovington@procession.com>


Hi there,

We're having a problem with a customer's database in Oracle 10g. It has archive logging switched on, and the server also has Backup Exec running with the module which backs up the Oracle database.

Oracle is coming up with a DOS window with the following message: live; ARC1: Beginning to archive log 1 thread 1 sequence 791

   Press ENTER to acknowledge message
live; ARC1: Creationg local archive destination LOG_ARCHIVE_DEST_1:
'd:\oracle\....' (etc)

   Press ENTER to acknowledge message
live; ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1:
'd:\oracle\....' (etc)

   Press ENTER to acknowledge message
live; ARC1: Completed archiving log 1 thread 1 sequence 791

   Press ENTER to acknowledge message

I've put a screen dump of the message here: http://www.hovington.com/images/message.jpg (~360k) This is not the usual error message about 'Can not allocate log. Archival required'
It may be prompted by Backup Exec. It happens during the afternoon, but I'm told the backup happens at night. The alert log below seems to contradict this. Can anyone shed any light on this?

This is running on Windows server 2003.

Any help appreciated.

Thanks
Steven Hovington



Wed Sep 15 14:42:21 2004
Private_strands 2 at log switch
Thread 1 advanced to log sequence 754
  Current log# 4 seq# 754 mem# 0: D:\ORACLE\ORADATA\LIVE\REDO04LIVE.LOG Wed Sep 15 14:42:21 2004
ARC1: Evaluating archive log 3 thread 1 sequence 753 Committing creation of archivelog
'D:\ORACLE\ORADATA\LIVE\ARCHIVE\LIVE00100753534606280.ARC'
Wed Sep 15 14:52:41 2004
ALTER TABLESPACE "RBS" BEGIN BACKUP
Completed: ALTER TABLESPACE "RBS" BEGIN BACKUP Wed Sep 15 14:54:03 2004
ALTER TABLESPACE "RBS" END BACKUP
Wed Sep 15 14:54:03 2004
Completed: ALTER TABLESPACE "RBS" END BACKUP Wed Sep 15 14:54:03 2004
ALTER TABLESPACE "ROLLBACK_DATA" BEGIN BACKUP Completed: ALTER TABLESPACE "ROLLBACK_DATA" BEGIN BACKUP Wed Sep 15 14:54:25 2004
ALTER TABLESPACE "ROLLBACK_DATA" END BACKUP Wed Sep 15 14:54:25 2004
Completed: ALTER TABLESPACE "ROLLBACK_DATA" END BACKUP Wed Sep 15 14:54:25 2004
ALTER TABLESPACE "SYSAUX" BEGIN BACKUP
Completed: ALTER TABLESPACE "SYSAUX" BEGIN BACKUP Wed Sep 15 14:54:48 2004
ALTER TABLESPACE "SYSAUX" END BACKUP
Wed Sep 15 14:54:48 2004
Completed: ALTER TABLESPACE "SYSAUX" END BACKUP Wed Sep 15 14:54:48 2004
ALTER TABLESPACE "SYSTEM" BEGIN BACKUP
Completed: ALTER TABLESPACE "SYSTEM" BEGIN BACKUP Wed Sep 15 14:55:24 2004
ALTER TABLESPACE "SYSTEM" END BACKUP
Wed Sep 15 14:55:24 2004
Completed: ALTER TABLESPACE "SYSTEM" END BACKUP Wed Sep 15 14:55:24 2004
ALTER TABLESPACE "TOOLS" BEGIN BACKUP
Completed: ALTER TABLESPACE "TOOLS" BEGIN BACKUP Wed Sep 15 14:55:28 2004
ALTER TABLESPACE "UNDOTBS01" BEGIN BACKUP Completed: ALTER TABLESPACE "UNDOTBS01" BEGIN BACKUP Wed Sep 15 14:56:31 2004
ALTER TABLESPACE "UNDOTBS01" END BACKUP
Wed Sep 15 14:56:31 2004
Completed: ALTER TABLESPACE "UNDOTBS01" END BACKUP Wed Sep 15 14:56:31 2004
ALTER TABLESPACE "USERS" BEGIN BACKUP
Completed: ALTER TABLESPACE "USERS" BEGIN BACKUP Wed Sep 15 14:56:46 2004
ALTER TABLESPACE "USERS" END BACKUP
Wed Sep 15 14:56:46 2004
Completed: ALTER TABLESPACE "USERS" END BACKUP Wed Sep 15 14:56:46 2004
ALTER TABLESPACE "USER_DATA" BEGIN BACKUP Completed: ALTER TABLESPACE "USER_DATA" BEGIN BACKUP Wed Sep 15 14:57:01 2004
ALTER TABLESPACE "USER_DATA" END BACKUP
Wed Sep 15 14:57:01 2004
Completed: ALTER TABLESPACE "USER_DATA" END BACKUP Wed Sep 15 14:57:05 2004
Private_strands 2 at log switch
Thread 1 advanced to log sequence 755
  Current log# 5 seq# 755 mem# 0: D:\ORACLE\ORADATA\LIVE\REDO05LIVE.LOG Wed Sep 15 14:57:05 2004
ARC1: Evaluating archive log 4 thread 1 sequence 754 Committing creation of archivelog
'D:\ORACLE\ORADATA\LIVE\ARCHIVE\LIVE00100754534606280.ARC'
Wed Sep 15 15:03:55 2004
ALTER DATABASE BACKUP CONTROLFILE TO 'D:\ORACLE\ORADATA\LIVE\BECFLIVE.BAK' REUSE
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 16 2004 - 07:55:18 CDT

Original text of this message

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