Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • initUOCIOTTO.ora Oracle
  • Good notes for shared pool Oracle
  • cur_sql.sql Oracle
  • Export With Query Another Example. Oracle
  • block_ident.sql Oracle
  • set_env_dba Linux/Unix
  • runsql_once.ksh Linux/Unix
  • Distributed Transaction Troubleshooting. Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • CPU speed on solaris Linux/Unix
  • Kernel Parameter setting explaination for Processes Parameter Linux/Unix
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • CTAS with LONG Column for 9i and higher Oracle
  • Multiple listeners Oracle
  • setting prompt display with .profile Linux/Unix

Changing unix system clock when Oracle database is running.

Posted on 01-Aug-2005 By Admin No Comments on Changing unix system clock when Oracle database is running.

Q: How does changing the system clock effect Oracle?? specifically, point

in time recovery?? Is it different with V6 and Oracle7??

A: Changing the system clock should really have no effect on the Oracle kernel

until it comes time to do time-based media recovery. Both in V6 and V7 there

may be problems if you use RECOVER DATABASE UNTIL TIME if time has changed

between the time you recover and the time the backup is taken.

Consider:

3pm 4pm 4.30 5pm–>4pm 4.16pm 4.30 5pm

|———|——-|——-|—–|——-|——-|——–|

cold/hot T1 T2 T3 clock T4 T5 T6

backup change

If you wish to recover to the T5, you will not be able to since Oracle will

recover to the first occurance of 4:30 which is T2. In Oracle7 you can recover

to a specific SCN (RECOVER … UNTIL CHANGE) which is systemclock independent,

but when using RECOVER … UNTIL TIME will not give the desired results.

So the lesson to be learned, is when the clock is set back, you should take

full database backup immediately after the system clock change.

NOTE: this only applies in the fall when we set the clocks back.

Oracle, SQL scripts

Post navigation

Previous Post: Paste command syntax
Next Post: cif crons

Related Posts

  • Restoring a user’s original password 1051962.101 Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Good Doc 28-JUN-2006 Oracle
  • Finding Oracle Patches with opatch Oracle
  • sesswait.sql Oracle
  • Oracle Release Explaination Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • create a folder in multiple places Linux/Unix
  • Search and replace pattern Linux/Unix
  • Removing Blank lines from file using grep Linux/Unix
  • adding new line after specific pattern using sed Linux/Unix
  • Good notes on Oracle Events Oracle
  • proc.sql Oracle
  • get_vmstat.ksh Linux/Unix
  • Paste command syntax Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme