alter system switch logfile的执行时间是多久。

上一篇 / 下一篇 2007-11-14 16:07:38 / 个人分类：Oracle资料与实践

查看( 566 ) / 评论( 16 )

alter system switch logfile，命令执行需要多久，我执行之后，每次都死在那里。也不知道什么时候完。

[ 本帖最后由 foxmile 于 2007-12-10 15:05 编辑 ]

论坛模式推荐收藏分享给好友推荐到圈子管理

TAG:

firebird发布于2007-11-14 16:11:06: 正常的话很快完成，检查一下alert log文件，看看发生了什么。

棉花糖ONE发布于2007-11-14 16:12:32: 看下alert.log报了什么错

alantany 发布于2007-11-14 16:12:52: 应该很快的，是不是要切换的日志的checkpoint还没做完？

pulf 发布于2007-11-14 16:14:03: 应该是检查点没有完成，具体情况具体分析

棉花糖ONE发布于2007-11-14 16:15:24: 应该很快的，是不是要切换的日志的checkpoint还没做完？

应该是下一个日志的checkpoint没完成吧，或者是下一个日志归档没完成

PondKa发布于2007-11-14 16:17:25: Re: alter system switch logfile的执行实践是多久。

QUOTE:
最初由 foxmile 发布
[B]alter system switch logfile，命令执行需要多久，我执行之后，每次都死在那里。也不知道什么时候完。 [/B]
是归档模式，还是非归档模式？是自动归档，还是手工归档？归档目录所在文件系统是否有足够空间？

liuandrew33发布于2007-11-14 16:18:31: 有可能是：1）归档盘满了；
2）checkpoint hang
检查一下：有没有session block?或归档盘空间

howard_zhang 发布于2007-11-14 16:21:43: 最好把ARCHIVE LOG LIST贴出来.
LZ是10G还是9I?

棉花糖ONE发布于2007-11-14 16:23:49: 别猜了，alert.log一帖出来，大概就知道是什么导致的了

xmlct78 发布于2007-11-14 16:25:01: 是啊，alert.log最能说明问题了

komman 发布于2007-11-14 16:26:19: LZ又跑了??

ignu 发布于2007-11-18 23:06:34: 空间

zhangg91发布于2007-11-18 23:22:37: QUOTE:
原帖由 komman 于 2007-11-14 16:26 发表
LZ又跑了??
又白忙活！

foxmile 发布于2007-12-10 14:43:40: Mon Dec 10 08:57:59 2007
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Mon Dec 10 08:57:59 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
  processes             = 150
  timed_statistics       = TRUE
  shared_pool_size       = 50331648
  large_pool_size       = 8388608
  java_pool_size          = 33554432
  control_files          = D:\oracle\oradata\zero\control01.ctl, D:\oracle\oradata\zero\control02.ctl, D:\oracle\oradata\zero\control03.ctl
  db_block_size          = 8192
  db_cache_size          = 25165824
  compatible             = 9.2.0.0.0
  log_archive_dest_1    = LOCATION=C:\arc_zero
  db_file_multiblock_read_count= 16
  fast_start_mttr_target = 300
  undo_management       = AUTO
  undo_tablespace       = UNDOTBS1
  undo_retention          = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain             =
  instance_name          = zero
  dispatchers             = (PROTOCOL=TCP) (SERVICE=zeroXDB)
  hash_join_enabled       = TRUE
  background_dump_dest    = D:\oracle\admin\zero\bdump
  user_dump_dest          = D:\oracle\admin\zero\udump
  core_dump_dest          = D:\oracle\admin\zero\cdump
  sort_area_size          = 524288
  db_name                = zero
  open_cursors          = 300
  sql_trace             = TRUE
  star_transformation_enabled= FALSE
  query_rewrite_enabled = FALSE
  pga_aggregate_target    = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Dec 10 08:58:10 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 10 08:58:12 2007
alter database mount exclusive
Mon Dec 10 08:58:19 2007
Successful mount of redo thread 1, with mount id 85719140.
Mon Dec 10 08:58:19 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Dec 10 08:58:19 2007
alter database open
Mon Dec 10 08:58:21 2007
Beginning crash recovery of 1 threads
Mon Dec 10 08:58:21 2007
Started first pass scan
Mon Dec 10 08:58:24 2007
Completed first pass scan
18 redo blocks read, 13 data blocks need recovery
Mon Dec 10 08:58:24 2007
Started recovery at
Thread 1: logseq 5, block 801, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORADATA\ZERO\REDO01.LOG
Mon Dec 10 08:58:25 2007
Ended recovery at
Thread 1: logseq 5, block 819, scn 0.1345410
13 data blocks read, 13 data blocks written, 18 redo blocks read
Crash recovery completed successfully
Mon Dec 10 08:58:27 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 6
Thread 1 opened at log sequence 6
  Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\ZERO\REDO02.LOG
Successful open of redo thread 1.
Mon Dec 10 08:58:30 2007
SMON: enabling cache recovery
Mon Dec 10 08:58:38 2007
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Dec 10 08:58:38 2007
SMON: enabling tx recovery
Mon Dec 10 08:58:38 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon Dec 10 14:28:58 2007
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace
Mon Dec 10 14:40:29 2007
Thread 1 advanced to log sequence 7
  Current log# 3 seq# 7 mem# 0: D:\ORACLE\ORADATA\ZERO\REDO03.LOG
Mon Dec 10 14:44:18 2007
ARCH: Evaluating archive log 1 thread 1 sequence 5
ARCH: Beginning to archive log 1 thread 1 sequence 5
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ARC_ZERO\ARC00005.001'
ARCH: Completed archiving  log 1 thread 1 sequence 5
ARCH: Evaluating archive log 2 thread 1 sequence 6
ARCH: Beginning to archive log 2 thread 1 sequence 6
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ARC_ZERO\ARC00006.001'
ARCH: Completed archiving  log 2 thread 1 sequence 6
Mon Dec 10 14:44:20 2007
Thread 1 advanced to log sequence 8
Mon Dec 10 14:44:20 2007
ARCH: Evaluating archive log 3 thread 1 sequence 7
Mon Dec 10 14:44:20 2007
  Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\ZERO\REDO01.LOG
Mon Dec 10 14:44:20 2007
ARCH: Beginning to archive log 3 thread 1 sequence 7
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ARC_ZERO\ARC00007.001'
ARCH: Completed archiving  log 3 thread 1 sequence 7
Mon Dec 10 14:44:28 2007
Thread 1 advanced to log sequence 9
  Current log# 2 seq# 9 mem# 0: D:\ORACLE\ORADATA\ZERO\REDO02.LOG
Thread 1 advanced to log sequence 10
  Current log# 3 seq# 10 mem# 0: D:\ORACLE\ORADATA\ZERO\REDO03.LOG

不好意思各位，那天有点事，把这个帖子给忘记了。
上面是我今天做的测试。顺便说一下，如果我执行一下
alter system archive log current;
则可以执行
alter system switch logfile;

[ 本帖最后由 foxmile 于 2007-12-10 14:46 编辑 ]