oracle修改闪回时间,时光不能倒流--谈oracle服务器的时间修改-CSDN博客

记录当前时间和crs的状态

root@rac01:/# date

Tue Feb 17 01:54:37 EAT 2009

root@rac01:/# crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.rac.db application OFFLINE OFFLINE

ora....s1.inst application OFFLINE OFFLINE

ora....s2.inst application OFFLINE OFFLINE

ora....B1.lsnr application ONLINE ONLINE rac01

ora.rac01.gsd application ONLINE ONLINE rac01

ora.rac01.ons application ONLINE ONLINE rac01

ora.rac01.vip application ONLINE ONLINE rac01

ora....B2.lsnr application ONLINE ONLINE rac02

ora.rac02.gsd application ONLINE ONLINE rac02

ora.rac02.ons application ONLINE ONLINE rac02

ora.rac02.vip application ONLINE ONLINE rac02

回调时间到20分钟前

root@rac01:/# date 02170135

date: do you really want to run time backwards?[yes/no]yes

Tue Feb 17 01:35:00 EAT 2009

root@rac01:/#

root@rac01:/# date

Tue Feb 17 01:35:01 EAT 2009

root@rac01:/# crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.rac.db application OFFLINE OFFLINE

ora....s1.inst application OFFLINE OFFLINE

ora....s2.inst application OFFLINE OFFLINE

ora....B1.lsnr application ONLINE ONLINE rac01

ora.rac01.gsd application ONLINE ONLINE rac01

ora.rac01.ons application ONLINE ONLINE rac01

ora.rac01.vip application ONLINE ONLINE rac01

ora....B2.lsnr application ONLINE ONLINE rac02

ora.rac02.gsd application ONLINE ONLINE rac02

ora.rac02.ons application ONLINE ONLINE rac02

ora.rac02.vip application ONLINE ONLINE rac02

检查与时间服务器的时间偏差

root@rac01:/# ntpdate -d 192.168.3.7

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

server 192.168.3.7, port 123

stratum 11, precision -18, leap 00, trust 000

refid [127.127.1.1], delay 0.02574, dispersion 0.00000

transmitted 4, in filter 4

reference time: cd442729.eba3b000 Tue, Feb 17 2009 1:55:53.920

originate timestamp: cd442730.257e1000 Tue, Feb 17 2009 1:56:00.146

transmit timestamp: cd4422b5.50a74000 Tue, Feb 17 2009 1:36:53.315

filter delay: 0.02582 0.02574 0.02574 0.02574

0.00000 0.00000 0.00000 0.00000

filter offset: 1146.831 1146.831 1146.831 1146.831

0.000000 0.000000 0.000000 0.000000

delay 0.02574, dispersion 0.00000

offset 1146.831323

17 Feb 01:36:53 ntpdate[29377]: step time server 192.168.3.7 offset 1146.831323 sec

检查ntp服务是否正常运行。时间服务会在10分钟左右退出，不知道为什么？

root@rac01:/# ps -ef | grep ntp

root 3609 1 0 00:44:44 ? 0:00 /usr/sbin/xntpd

root 29736 27226 1 01:37:06 pts/tb 0:00 grep ntp

检查alert日志和crs日志，基本没有错误。

root@rac01:/# su - oracle

Value of TERM has been set to "vt100".

rac01:/oracle>

rac01:/oraclelog/rac/bdump>tail -f alert*.log

SMON: enabling tx recovery

Tue Feb 17 01:01:50 2009

Database Characterset is ZHS16GBK

Opening with internal Resource Manager plan

where NUMA PG = 2, CPUs = 8

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=54, OS id=18661

Tue Feb 17 01:01:54 2009

Completed: ALTER DATABASE OPEN

rac01:/oracle/app/oracle/product/10.2.0/crs>ls

JRE cv jdk nls plsql srvm

OPatch diagnostics jlib nnfgt.c precomp sysman

bin evm jre ntcontab.c racg tg4ifmx

cdata has ldap opmn rdbms tg4ingr

cfgtoollogs hs lib oraInst.loc relnotes tg4sybs

clone install lib32 oracore root.sh tg4tera

crs install.platform log oui slax xdk

css inventory network perl sqlplus

rac01:/oracle/app/oracle/product/10.2.0/crs>cd log

rac01:/oracle/app/oracle/product/10.2.0/crs/log>ls

crs rac01

rac01:/oracle/app/oracle/product/10.2.0/crs/log>cd crs

rac01:/oracle/app/oracle/product/10.2.0/crs/log/crs>ls

rac01:/oracle/app/oracle/product/10.2.0/crs/log/crs>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log>cd rac01

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd racg

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>ls

default.log ora.rac01.ons.log ora.rac02.vip.log racgevtf

ora.rac01.gsd.log ora.rac01.vip.log racgeut racgmain

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>ll

total 30

-rw-r--r-- 1 oracle dba 469 Feb 11 00:22 default.log

-rw-r--r-- 1 oracle dba 1918 Feb 17 01:00 ora.rac01.gsd.log

-rw-r--r-- 1 oracle dba 1731 Feb 17 01:00 ora.rac01.ons.log

-rw-r--r-- 1 root sys 7446 Feb 16 23:11 ora.rac01.vip.log

-rw-r--r-- 1 root sys 1521 Feb 11 11:02 ora.rac02.vip.log

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgeut

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgevtf

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgmain

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>ls -lrt

total 30

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgmain

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgeut

drwxrwxrwt 2 oracle dba 96 Jan 19 15:30 racgevtf

-rw-r--r-- 1 oracle dba 469 Feb 11 00:22 default.log

-rw-r--r-- 1 root sys 1521 Feb 11 11:02 ora.rac02.vip.log

-rw-r--r-- 1 root sys 7446 Feb 16 23:11 ora.rac01.vip.log

-rw-r--r-- 1 oracle dba 1731 Feb 17 01:00 ora.rac01.ons.log

-rw-r--r-- 1 oracle dba 1918 Feb 17 01:00 ora.rac01.gsd.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>date

Tue Feb 17 01:41:16 EAT 2009

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/racg>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd crsd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/crsd>ls

crsd.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/crsd>ls -lrt

total 414

-rw-r--r-- 1 root root 203039 Feb 17 01:00 crsd.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/crsd>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd cssd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/cssd>ls -l

total 284

-rw-rw-rw- 1 oracle dba 219 Feb 17 00:59 cssdOUT.log

drwxr-xr-x 2 oracle dba 96 Jan 19 15:30 oclsmon

-rw-rw-rw- 1 oracle dba 0 Feb 17 00:59 oclsmon.log

drwxrwxrwx 2 oracle root 1024 Feb 17 00:59 oclsomon

drwxrwxrwx 2 oracle root 96 Jan 19 17:08 oclsvmon

-rw-r--r-- 1 oracle dba 133182 Feb 17 01:00 ocssd.log

-rw-rw-rw- 1 oracle dba 6 Jan 19 15:30 rac01.pid

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/cssd>ls -lrt

total 284

drwxr-xr-x 2 oracle dba 96 Jan 19 15:30 oclsmon

-rw-rw-rw- 1 oracle dba 6 Jan 19 15:30 rac01.pid

drwxrwxrwx 2 oracle root 96 Jan 19 17:08 oclsvmon

-rw-rw-rw- 1 oracle dba 0 Feb 17 00:59 oclsmon.log

drwxrwxrwx 2 oracle root 1024 Feb 17 00:59 oclsomon

-rw-rw-rw- 1 oracle dba 219 Feb 17 00:59 cssdOUT.log

-rw-r--r-- 1 oracle dba 133182 Feb 17 01:00 ocssd.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/cssd>tail -f ocssd.log

[ CSSD]2009-02-17 01:00:06.865 [17] >TRACE: clssgmInitialRecv: (6000000000ada730) accepted a new connection from node 1 born at 2 active (2, 2), vers (10,3,1,2)

[ CSSD]2009-02-17 01:00:06.865 [17] >TRACE: clssgmInitialRecv: conns done (2/2)

[ CSSD]2009-02-17 01:00:06.865 [22] >TRACE: clssgmEstablishMasterNode: MASTER for 2 is node(0) birth(1)

[ CSSD]2009-02-17 01:00:06.865 [22] >TRACE: clssgmMasterCMSync: Synchronizing group/lock status

[ CSSD]2009-02-17 01:00:06.867 [22] >TRACE: clssgmMasterSendDBDone: group/lock status synchronization complete

[ CSSD]CLSS-3000: reconfiguration successful, incarnation 2 with 2 nodes

[ CSSD]CLSS-3001: local node number 0, master node number 0

[ CSSD]2009-02-17 01:00:06.933 [22] >TRACE: clssgmReconfigThread: completed for reconfig(2), with status(1)

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/cssd>

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/cssd>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/evmd>ls

evmd.log evmdOUT.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/evmd>ls -lrt

total 268

-rw-r--r-- 1 oracle dba 2003 Feb 17 00:59 evmdOUT.log

-rw-r--r-- 1 oracle dba 126073 Feb 17 01:00 evmd.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/evmd>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd client

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/client>ls -lrt

total 422

-rw-r--r-- 1 oracle dba 1875 Feb 11 00:22 clsc15.log

-rw-r--r-- 1 oracle dba 271 Feb 11 11:00 clsc16.log

-rw-r--r-- 1 oracle dba 271 Feb 11 11:00 clsc17.log

-rw-r--r-- 1 oracle dba 271 Feb 11 11:01 clsc18.log

-rw-r--r-- 1 oracle dba 271 Feb 11 11:01 clsc19.log

-rw-r--r-- 1 root root 271 Feb 11 11:01 css129.log

-rw-r--r-- 1 oracle dba 271 Feb 11 11:01 css130.log

-rw-r--r-- 1 oracle dba 18882 Feb 11 11:06 oifcfg.log

-rw-r----- 1 oracle dba 387 Feb 11 11:27 ocr_13737_7.log

-rw-r--r-- 1 oracle dba 1875 Feb 11 11:27 clsc20.log

-rw-r--r-- 1 oracle dba 271 Feb 11 12:11 clsc21.log

-rw-r--r-- 1 oracle dba 271 Feb 11 12:11 clsc22.log

-rw-r--r-- 1 oracle dba 271 Feb 11 12:11 clsc23.log

-rw-r--r-- 1 oracle dba 271 Feb 11 12:11 css132.log

-rw-r--r-- 1 root root 271 Feb 11 12:11 css131.log

-rw-r--r-- 1 oracle dba 1875 Feb 16 23:43 clsc24.log

-rw-r--r-- 1 oracle dba 271 Feb 17 00:59 clsc25.log

-rw-r--r-- 1 oracle dba 271 Feb 17 00:59 clsc26.log

-rw-r--r-- 1 oracle dba 271 Feb 17 00:59 clsc27.log

-rw-r--r-- 1 root root 271 Feb 17 00:59 css133.log

-rw-r--r-- 1 oracle dba 271 Feb 17 00:59 css134.log

-rw-r--r-- 1 oracle dba 1729 Feb 17 00:59 clsc28.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/client>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls -lrt

total 32

drwxr-xr-x 2 oracle dba 96 Jan 19 15:30 admin

drwxr-xr-x 2 root dba 96 Jan 19 15:30 crsd

drwxr-xr-x 2 oracle dba 96 Jan 19 15:30 evmd

drwxr-xr-x 5 oracle dba 1024 Jan 19 17:08 cssd

drwxrwxrwt 5 oracle dba 1024 Feb 11 11:02 racg

drwxr-xr-x 2 oracle dba 4096 Feb 17 00:59 client

-rw-rw-rw- 1 root dba 10204 Feb 17 01:00 alertrac01.log

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd admin

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/admin>ls -lrt

total 0

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01/admin>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>ls

admin client cssd racg

alertrac01.log crsd evmd

rac01:/oracle/app/oracle/product/10.2.0/crs/log/rac01>cd ..

rac01:/oracle/app/oracle/product/10.2.0/crs/log>ls

crs rac01

rac01:/oracle/app/oracle/product/10.2.0/crs/log>cd

rac01:/oracle>date

Tue Feb 17 01:43:05 EAT 2009

rac01:/oracle>

rac01:/oracle>crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.rac.db application OFFLINE OFFLINE

ora....s1.inst application OFFLINE OFFLINE

ora....s2.inst application OFFLINE OFFLINE

ora....B1.lsnr application ONLINE ONLINE rac01

ora.rac01.gsd application ONLINE ONLINE rac01

ora.rac01.ons application ONLINE ONLINE rac01

ora.rac01.vip application ONLINE ONLINE rac01

ora....B2.lsnr application ONLINE ONLINE rac02

ora.rac02.gsd application ONLINE ONLINE rac02

ora.rac02.ons application ONLINE ONLINE rac02

ora.rac02.vip application ONLINE ONLINE rac02

rac01:/oracle>

rac01:/oracle>exit

logout

root@rac01:/# ntpdate -d 192.168.3.7

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

receive(192.168.3.7)

transmit(192.168.3.7)

server 192.168.3.7, port 123

stratum 11, precision -18, leap 00, trust 000

refid [127.127.1.1], delay 0.02574, dispersion 0.00000

transmitted 4, in filter 4

reference time: cd4428a9.eba70000 Tue, Feb 17 2009 2:02:17.920

originate timestamp: cd4428ba.11dd9000 Tue, Feb 17 2009 2:02:34.069

transmit timestamp: cd44243f.3b79f000 Tue, Feb 17 2009 1:43:27.232

filter delay: 0.02580 0.02574 0.02576 0.02574

0.00000 0.00000 0.00000 0.00000

filter offset: 1146.837 1146.837 1146.837 1146.837

0.000000 0.000000 0.000000 0.000000

delay 0.02574, dispersion 0.00000

offset 1146.837371

17 Feb 01:43:27 ntpdate[4625]: step time server 192.168.3.7 offset 1146.837371 sec

root@rac01:/#

root@rac01:/# date

Tue Feb 17 01:46:06 EAT 2009

[本帖最后由 BTxigua 于 2009-3-28 14:49 编辑]