修改系统时间对oracle数据库的影响
1. It will affect any records that are inserted while changing the date if it involves the sysdate.
2. It will also affect any scheduler jobs that will run on that date.
Please follow those steps :
1. Take a backup
2. Shutdown database (clean)
3. Change date/time on OS
4. Startup database
参考559660.1
2. It will also affect any scheduler jobs that will run on that date.
Please follow those steps :
1. Take a backup
2. Shutdown database (clean)
3. Change date/time on OS
4. Startup database
参考559660.1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15747463/viewspace-1419095/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 【kylin】Failed to build cube
- Greenplum 数据分布黄金法则 - 论分布列与分区的选择
- oracle 11g_调度程序维护任务或 Autotasks
- How to Find which Session is Holding a Particular Library Cache Lock
- oracle控制文件复制、移动方式
- How To Move Datafiles On AIX Using Raw Logical Volumes To A New Location?
- ASMM/AMM开启时动态调整内存组件(shared_pool_size, db_cache_size等)大小
- RAC中通过nkmod解决各个节点盘符不一致问题
- full backup 与 level 0 incremental backup
- SHARED POOL ORA-04031错误分析
