Re: Archive logging

I think you need to check that archiving is indeed automatic (spfilexxxx.ora or OEM).

Check Backup Exec manual for possible clues?

"Steve" <sh_at_nojunk.com> wrote in message news:414ae95f.102642562_at_nnrp.news.uk.psi.net...
> 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
> 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
Received on Sat Sep 18 2004 - 18:12:30 CDT