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

Home -> Community -> Usenet -> c.d.o.server -> Backups in Archive Log Mode

Backups in Archive Log Mode

From: Brian Rankin <brankin_at_enbonline.net>
Date: 7 May 2002 10:31:23 -0700
Message-ID: <fc0674ce.0205070931.7734d6e5@posting.google.com>


Hello,

I'm running Oracle 8.1.7.3 in archive log mode, doing hot backups every night. At the end of the backup I switch logfiles during the backup, thus:

But, this results in an error in my alert log. It looks as if the log sequences gets out of sync. Notice the failure in log 1243:

Tue May 7 03:07:42 2002
alter database backup controlfile to trace Completed: alter database backup controlfile to trace Tue May 7 03:07:42 2002
alter database backup controlfile to
'/data02/orabackups/current/control.foo.
07May020300'
Completed: alter database backup controlfile to '/data02/orab Tue May 7 03:07:46 2002
Thread 1 advanced to log sequence 1244
  Current log# 1 seq# 1244 mem# 0:
/data01/oracle/oradata/foo/redo03.log
Tue May 7 03:07:46 2002
ARC0: Beginning to archive log# 3 seq# 1243 Tue May 7 03:07:46 2002
ARCH: Beginning to archive log# 3 seq# 1243 ARCH: Failed to archive log# 3 seq# 1243 Tue May 7 03:07:46 2002
ARC0: Completed archiving log# 3 seq# 1243

I've had to restore the database from backup using the archive logs, so far no problem. What does this error mean? Received on Tue May 07 2002 - 12:31:23 CDT

Original text of this message

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