- 最后登录
- 2014-5-24
- 在线时间
- 17 小时
- 威望
- 3
- 金钱
- 67
- 注册时间
- 2012-7-22
- 阅读权限
- 10
- 帖子
- 22
- 精华
- 0
- 积分
- 3
- UID
- 639
|
1#
发表于 2012-7-28 20:36:21
|
查看: 5405 |
回复: 3
现在的时间是20:30:08 2012, 我做个日志切换,但是数据库alert日志显示的时间为凌晨4点 多,如下:
查看了其他生产库 DBTIMEZONE 也是+00:00
SQL> SELECT DBTIMEZONE FROM DUAL;
DBTIME
------
+00:00
[email=oracle@shtdb01]oracle@shtdb01[/email]:~> date
Sat Jul 28 20:30:03 CST 2012
[email=oracle@shdb01]oracle@shdb01[/email]:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 28 20:30:08 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2012-07-28 20:30:18
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL>
现在查看alert.log
Sat Jul 28 04:30:25 2012
Thread 1 advanced to log sequence 215 (LGWR switch)
Current log# 5 seq# 215 mem# 0: +DATA/mpdb/onlinelog/group_5.270.781824791
Current log# 5 seq# 215 mem# 1: +DATA/mpdb/onlinelog/group_5.271.781824791
Sat Jul 28 04:32:31 2012
Thread 1 advanced to log sequence 216 (LGWR switch)
Current log# 7 seq# 216 mem# 0: +DATA/mpdb/onlinelog/group_7.272.781824793
Current log# 7 seq# 216 mem# 1: +DATA/mpdb/onlinelog/group_7.273.781824795
Thread 1 advanced to log sequence 217 (LGWR switch)
Current log# 1 seq# 217 mem# 0: +DATA/mpdb/onlinelog/group_1.266.781824787
Current log# 1 seq# 217 mem# 1: +DATA/mpdb/onlinelog/group_1.267.781824787
Sat Jul 28 04:32:52 2012
Thread 1 cannot allocate new log, sequence 218
Checkpoint not complete
Current log# 1 seq# 217 mem# 0: +DATA/mpdb/onlinelog/group_1.266.781824787
Current log# 1 seq# 217 mem# 1: +DATA/mpdb/onlinelog/group_1.267.781824787
Thread 1 advanced to log sequence 218 (LGWR switch)
Current log# 2 seq# 218 mem# 0: +DATA/mpdb/onlinelog/group_2.268.781824789
Current log# 2 seq# 218 mem# 1: +DATA/mpdb/onlinelog/group_2.269.781824789 |
|