[20160822]11g Restore Point Enhancement2
[20160822]11g Restore Point Enhancements2.txt
--上個星期寫的關於11gRestore Point的問題,連結:
http://blog.itpub.net/267265/viewspace-2123766/
--今天在回家的路上,突然明白為什麼差8個小時.實際上國內在第8時區,也就是smon_scn_time儲存的時間是UTC時間.
--如果執行如下命令:
create restore point restore3 as of timestamp date'2015-08-01';
--這個時間是本地時間,減去8小時才是UTC時間.
--不知道理解是否正確,在實踐中注意,不過還是使用scn更加準確一點.
SYS@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SYS@book> select max(TIME_DP),sysdate from smon_scn_time ;
MAX(TIME_DP) SYSDATE
------------------- -------------------
2016-08-22 23:55:10 2016-08-23 08:00:52
--從檢視也可以看出smon_scn_time記錄的時間是UTC。
--順便學習unix的date命令的轉換問題:
$ date -u -d '1970-01-01 UTC 1438358400 seconds' +"%Y-%m-%d %T"
2015-07-31 16:00:00
$ date -d '1970-01-01 UTC 1438358400 seconds' +"%Y-%m-%d %T"
2015-08-01 00:00:00
$ date -d '2015-08-01 UTC' +"%Y-%m-%d %T"
2015-08-01 08:00:00
--//2015-08-01 UTC 相當於本地時間的2015-08-01 08:00:00。
$ date -d '2015-08-01' +"%s"
1438358400
--//日期的2015-08-01(本地)對比1970/1/1的秒數。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2123831/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RESTORE POINTREST
- [20160820]11g Restore Point EnhancementsREST
- 閃回還原點restore pointREST
- restore point -特色的SCN標誌(一)REST
- Orace Flash Restore Point(閃回還原點)REST
- Oracle10GR2 中的RESTORE POINTOracleREST
- [20171204]guaranteed restore point.txtREST
- restore point特色二&閃回資料庫特性(三)REST資料庫
- 20160822Oracle 11g Temporary TablespaceOracle
- How to Create or Remove Restore Point on Standby database (文件 ID 1672977.1)REMRESTDatabase
- 6150680: Cannot Create Guaranteed Restore Point In Physical Standby DB_602270.1REST
- Oracle OCP 1Z0 053 Q390(Flashback database&Named restore point)OracleDatabaseREST
- 11g asm md_backup md_restoreASMREST
- oracle小知識點3--有保證的復原點guaranteed restore pointOracleREST
- archivelog模式和flashback db以及guarantee restore point之間的相互制約關係!Hive模式REST
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引發的血案.DatabaseREST
- guarantee restore points-Flashback after RMAN restoreREST
- canvas restore()CanvasREST
- JavaScript some pointJavaScript
- study critical point and saddle point using Hessian Matrix
- Restore ArchivelogRESTHive
- DOCKER特性 - LIVE RESTOREDockerREST
- canvas save()和restore()CanvasREST
- SQL Server Backup & RestoreSQLServerREST
- How restore CBO statisticsREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- TMS request queue restoreREST
- Windows Embedded for Point of Service概述Windows
- Windows Embedded for Point of Service 益處Windows
- 收藏What’s the Point of Oracle Checkpoints?Oracle
- tablespace point in time recover (tpitr)
- Restore Points 制定回退方案REST
- restore和recover 區別REST
- restore database check readonlyRESTDatabase
- rman restore archivelog logRESTHive
- restore,recover的區別REST
- Cold backup and restore the entire databaseRESTDatabase