这个函数将Checkpoint Time对应的数值转化为时间
http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=39
FHPRC VARCHAR2(20) Previous Resetlog time from databaseFHPRC_I NUMBER Previous Resetlog time as an number
SQL> select fhprc,fhprc_i from x$kcvfh; FHPRC FHPRC_I -------------------- ---------- 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927 07/07/2014 05:38:47 852269927
12 rows selected.
SQL>
SQL> oradebug setmypid; Statement processed. SQL> oradebug dump controlf 3; Statement processed. SQL> oradebug tracefile_name; /u01/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_17943.trc SQL>
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
03/10/2016 10:28:14
DB Name "CDB1"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 03/10/2016 10:28:14
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.0018531f Resetlogs Timestamp 03/10/2016 10:28:16
Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 07/07/2014 05:38:47
[oracle@db1 ~]$ ./aodu
AT Oracle Database Utility,Release 1.1.0 on Mon Jun 13 14:31:21 2016
Copyright (c) 2014, 2015, Robin.Han. All rights reserved.
http://ohsdba.cn
E-Mail:375349564@qq.com
AODU> time 852269927
checkpoint time : 2014-07-07 05:38:47
AODU>
Reference
http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=47
http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=39
