Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置: 首页 » 技术文章 » AODU

aodu(At Oracle Database Utility)之time

这个函数将Checkpoint Time对应的数值转化为时间


http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=39

FHPRC            VARCHAR2(20)  Previous Resetlog time from database 
FHPRC_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>


DATABASE ENTRY
***************************************************************************
 (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

关键词:aodu 

相关文章

aodu(At Oracle Database Utility)之optim
aodu(At Oracle Database Utility)之asm(二)
aodu(At Oracle Database Utility)之asm(一)
aodu(At Oracle Database Utility)之rac(二)
aodu(At Oracle Database Utility)之rac(一)
aodu(At Oracle Database Utility)之ora600
aodu(At Oracle Database Utility)之asmdisk
aodu(At Oracle Database Utility)之unwrap
aodu(At Oracle Database Utility)之rdba
aodu(At Oracle Database Utility)之drux
aodu(At Oracle Database Utility)之time
aodu(At Oracle Database Utility)之odlog
Top