求教：归档进程的管理

显示全部楼层 · 2007-10-20 08:38:44

求教：归档进程的管理
Fri May 25 20:46:06 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/ora_rman_backup/crtl_backup/c-4205638757-20070525-00'
Fri May 25 20:46:11 2007
Thread 1 advanced to log sequence 535
Current log# 1 seq# 535 mem# 0: /dev/udpay/lv_redo11_256m
Current log# 1 seq# 535 mem# 1: /dev/udpay/lv_redo12_256m
Fri May 25 20:46:11 2007
ARCH: Evaluating archive log 6 thread 1 sequence 534
ARCH: Beginning to archive log 6 thread 1 sequence 534
Creating archive destination LOG_ARCHIVE_DEST_1: '/archivelog/arch/1_534.dbf'
Fri May 25 20:46:12 2007
ARC0: Evaluating archive log 6 thread 1 sequence 534
ARC0: Unable to archive log 6 thread 1 sequence 534
Log actively being archived by another process
Fri May 25 20:46:15 2007
ARCH: Completed archiving log 6 thread 1 sequence 534
Fri May 25 20:46:18 2007
Thread 1 advanced to log sequence 536
Current log# 2 seq# 536 mem# 0: /dev/udpay/lv_redo21_256m
Current log# 2 seq# 536 mem# 1: /dev/udpay/lv_redo22_256m
Fri May 25 20:46:18 2007
ARCH: Evaluating archive log 1 thread 1 sequence 535
ARCH: Beginning to archive log 1 thread 1 sequence 535
Creating archive destination LOG_ARCHIVE_DEST_1: '/archivelog/arch/1_535.dbf'
Fri May 25 20:46:19 2007
ARC0: Evaluating archive log 1 thread 1 sequence 535
ARC0: Unable to archive log 1 thread 1 sequence 535
Log actively being archived by another process
Fri May 25 20:46:19 2007
ARCH: Completed archiving log 1 thread 1 sequence 535
Fri May 25 20:46:40 2007
Starting control autobackup
Control autobackup written to DISK device
handle '/ora_rman_backup/crtl_backup/c-4205638757-20070525-01'
为什么一秒后
oracle又启动了另外一个进程去归档
oracle关于归档进程的管理是怎么的呢？
实在不解，请大家指教一下

千问 · 2007-10-20 08:38:44

找影响日志切换的原因

千问 · 2007-10-20 08:38:44

connect catalog rman/rman@rman;
connect target sys/sys@udpay;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora_rman_backup/crtl_backup/%F';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CROSSCHECK ARCHIVELOG ALL;
run{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
backup full databaseformat 'D:/%T_%d' include current controlfile;
sql 'alter system archive log current';
backupfilesperset 3 format 'D:/arch%u_%s_%p' archivelog all;
DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'SYSDATE-2';
release channel ch1;
}