最近归档目录下的文件自己会消失,或者是被删除。
通过监控发现每天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
解决方案 »
- oracle 添加字段造成锁表
- 存储过程 输出函数为clob字段 为什么输出时还出现“ora-06502 字符串缓冲太小”错误
- 问一下关于Clob的问题,20分奉送别嫌少!
- oracle实现全文索引怎么做?另要求:查到的关键字在记录中出现次数最多,排在最前,,,,是不是很变态,怎么做呀
- 高手急救oracle 9i 如何禁掉8080端口[在线]
- 有劳朋友,做ORACLE数据库和J2EE 都用到那些开发软件?OS用2000,2000SERVER,还是XP Pro?
- 请问在Delphi中如何访问Oracle数据库
- 为什么安装了Oracle之后我得Enterprise Manager Console不能运行呢?
- 请问有没有将一个值转换成浮点类型的函数,类似to_number()之类的
- 求大神求解oracle触发器问题
- 关于NVL2()函数的用法!!!!谁会???急!!!
- 请教大虾~
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目录,然后问了系统管理员才清楚的。
谢谢各位的帮助。