最近归档目录下的文件自己会消失,或者是被删除。
通过监控发现每天4点15左右当天的归档文件会自动被删除,查看alert日志发现这个时间会有报错,而且较白天有较多的归档生成。
以下是日志,麻烦各位高手看看会是啥原因。
Tue Apr 17 04:15:41 2007
Thread 1 advanced to log sequence 1451
Current log# 2 seq# 1451 mem# 0: /oracle/oraHome/oradata/hnyldb/redo02.log
Tue Apr 17 04:15:41 2007
ARCH: Evaluating archive log 1 thread 1 sequence 1450
ARCH: Beginning to archive log 1 thread 1 sequence 1450
Tue Apr 17 04:15:41 2007
ARC1: Evaluating archive log 1 thread 1 sequence 1450
ARC1: Unable to archive log 1 thread 1 sequence 1450
Tue Apr 17 04:15:41 2007
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1450.dbf'
Tue Apr 17 04:15:41 2007
Log actively being archived by another process
ARC1: Evaluating archive log 1 thread 1 sequence 1450
ARC1: Unable to archive log 1 thread 1 sequence 1450
Log actively being archived by another process
Tue Apr 17 04:15:44 2007
ARCH: Completed archiving log 1 thread 1 sequence 1450
Tue Apr 17 04:15:47 2007
Thread 1 advanced to log sequence 1452
Current log# 3 seq# 1452 mem# 0: /oracle/oraHome/oradata/hnyldb/redo03.log
Tue Apr 17 04:15:47 2007
ARCH: Evaluating archive log 2 thread 1 sequence 1451
ARCH: Beginning to archive log 2 thread 1 sequence 1451
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1451.dbf'
Tue Apr 17 04:15:47 2007
ARC1: Evaluating archive log 2 thread 1 sequence 1451
ARC1: Unable to archive log 2 thread 1 sequence 1451
Log actively being archived by another process
Tue Apr 17 04:15:47 2007
ARCH: Completed archiving log 2 thread 1 sequence 1451
Wed Apr 18 04:15:50 2007
Thread 1 advanced to log sequence 1453
Current log# 1 seq# 1453 mem# 0: /oracle/oraHome/oradata/hnyldb/redo01.log
Wed Apr 18 04:15:50 2007
ARCH: Evaluating archive log 3 thread 1 sequence 1452
ARCH: Beginning to archive log 3 thread 1 sequence 1452
Wed Apr 18 04:15:50 2007
ARC1: Evaluating archive log 3 thread 1 sequence 1452
ARC1: Unable to archive log 3 thread 1 sequence 1452
Log actively being archived by another process
Wed Apr 18 04:15:50 2007
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1452.dbf'
ARCH: Completed archiving log 3 thread 1 sequence 1452
Wed Apr 18 04:15:55 2007
Thread 1 advanced to log sequence 1454
Current log# 2 seq# 1454 mem# 0: /oracle/oraHome/oradata/hnyldb/redo02.log
Wed Apr 18 04:15:55 2007
ARCH: Evaluating archive log 1 thread 1 sequence 1453
ARCH: Beginning to archive log 1 thread 1 sequence 1453
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1453.dbf'
Wed Apr 18 04:15:55 2007
ARC1: Evaluating archive log 1 thread 1 sequence 1453
[SIZE=3] ARC1: Unable to archive log 1 thread 1 sequence 1453[/SIZE]
Log actively being archived by another process
Wed Apr 18 04:15:55 2007
ARCH: Completed archiving log 1 thread 1 sequence 1453
Wed Apr 18 10:06:07 2007
ALTER SYSTEM SET log_archive_dest_1='LOCATION=/database/oraback/hnyldb' SCOPE=MEMORY;
Wed Apr 18 10:09:59 2007
Thread 1 advanced to log sequence 1455
Current log# 3 seq# 1455 mem# 0: /oracle/oraHome/oradata/hnyldb/redo03.log
Wed Apr 18 10:09:59 2007
ARC1: Evaluating archive log 2 thread 1 sequence 1454
ARC1: Beginning to archive log 2 thread 1 sequence 1454
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1454.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 1454
通过监控发现每天4点15左右当天的归档文件会自动被删除,查看alert日志发现这个时间会有报错,而且较白天有较多的归档生成。
以下是日志,麻烦各位高手看看会是啥原因。
Tue Apr 17 04:15:41 2007
Thread 1 advanced to log sequence 1451
Current log# 2 seq# 1451 mem# 0: /oracle/oraHome/oradata/hnyldb/redo02.log
Tue Apr 17 04:15:41 2007
ARCH: Evaluating archive log 1 thread 1 sequence 1450
ARCH: Beginning to archive log 1 thread 1 sequence 1450
Tue Apr 17 04:15:41 2007
ARC1: Evaluating archive log 1 thread 1 sequence 1450
ARC1: Unable to archive log 1 thread 1 sequence 1450
Tue Apr 17 04:15:41 2007
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1450.dbf'
Tue Apr 17 04:15:41 2007
Log actively being archived by another process
ARC1: Evaluating archive log 1 thread 1 sequence 1450
ARC1: Unable to archive log 1 thread 1 sequence 1450
Log actively being archived by another process
Tue Apr 17 04:15:44 2007
ARCH: Completed archiving log 1 thread 1 sequence 1450
Tue Apr 17 04:15:47 2007
Thread 1 advanced to log sequence 1452
Current log# 3 seq# 1452 mem# 0: /oracle/oraHome/oradata/hnyldb/redo03.log
Tue Apr 17 04:15:47 2007
ARCH: Evaluating archive log 2 thread 1 sequence 1451
ARCH: Beginning to archive log 2 thread 1 sequence 1451
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1451.dbf'
Tue Apr 17 04:15:47 2007
ARC1: Evaluating archive log 2 thread 1 sequence 1451
ARC1: Unable to archive log 2 thread 1 sequence 1451
Log actively being archived by another process
Tue Apr 17 04:15:47 2007
ARCH: Completed archiving log 2 thread 1 sequence 1451
Wed Apr 18 04:15:50 2007
Thread 1 advanced to log sequence 1453
Current log# 1 seq# 1453 mem# 0: /oracle/oraHome/oradata/hnyldb/redo01.log
Wed Apr 18 04:15:50 2007
ARCH: Evaluating archive log 3 thread 1 sequence 1452
ARCH: Beginning to archive log 3 thread 1 sequence 1452
Wed Apr 18 04:15:50 2007
ARC1: Evaluating archive log 3 thread 1 sequence 1452
ARC1: Unable to archive log 3 thread 1 sequence 1452
Log actively being archived by another process
Wed Apr 18 04:15:50 2007
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1452.dbf'
ARCH: Completed archiving log 3 thread 1 sequence 1452
Wed Apr 18 04:15:55 2007
Thread 1 advanced to log sequence 1454
Current log# 2 seq# 1454 mem# 0: /oracle/oraHome/oradata/hnyldb/redo02.log
Wed Apr 18 04:15:55 2007
ARCH: Evaluating archive log 1 thread 1 sequence 1453
ARCH: Beginning to archive log 1 thread 1 sequence 1453
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1453.dbf'
Wed Apr 18 04:15:55 2007
ARC1: Evaluating archive log 1 thread 1 sequence 1453
[SIZE=3] ARC1: Unable to archive log 1 thread 1 sequence 1453[/SIZE]
Log actively being archived by another process
Wed Apr 18 04:15:55 2007
ARCH: Completed archiving log 1 thread 1 sequence 1453
Wed Apr 18 10:06:07 2007
ALTER SYSTEM SET log_archive_dest_1='LOCATION=/database/oraback/hnyldb' SCOPE=MEMORY;
Wed Apr 18 10:09:59 2007
Thread 1 advanced to log sequence 1455
Current log# 3 seq# 1455 mem# 0: /oracle/oraHome/oradata/hnyldb/redo03.log
Wed Apr 18 10:09:59 2007
ARC1: Evaluating archive log 2 thread 1 sequence 1454
ARC1: Beginning to archive log 2 thread 1 sequence 1454
Creating archive destination LOG_ARCHIVE_DEST_1: '/database/oraback/hnyldb/1_1454.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 1454
1004 Full 1M SBT_TAPE 00:00:52 24-APR-07
BP Key: 1003 Status: AVAILABLE Tag: TAG20070424T042430
Piece Name: cntrl_1006_1_620713470
Controlfile Included: Ckp SCN: 521670338 Ckp time: 24-APR-07BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1005 Incr 1 184M SBT_TAPE 00:06:37 25-APR-07
BP Key: 1004 Status: AVAILABLE Tag: HOT_DB_BK_LEVEL0
Piece Name: bk_1008_1_620798743
List of Datafiles in backup set 1005
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 1 Incr 522504879 25-APR-07 /oracle/oraHome/oradata/hnyldb/indx01.dbf
9 1 Incr 522504879 25-APR-07 /oracle/oraHome/oradata/hnyldb/xdb01.dbf
11 1 Incr 522504879 25-APR-07 /database/oradata/hnyldb/AASTDATA.dbf
12 1 Incr 522504879 25-APR-07 /oracle/oraHome/oradata/hnyldb/OPERATE.dbf
13 1 Incr 522504879 25-APR-07 /database/oradata/hnyldb/perfstat.dbf
有啥办法能查到RMAN备份的记录?何时,哪个主机调用RMAN命令等情况
系统管理员说前段时间磁带库有问题停掉了,一直没启用。
我刚来这家公司不久才了解。我写脚本抓到了运行的进程和脚本路径,看到了NETBACKUP目录,然后问了系统管理员才清楚的。
谢谢各位的帮助。