Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • Very clear article about oracle dataguard Oracle
  • replace alphabets using sed Linux/Unix
  • AWR license Oracle
  • Find Plan Hash value fphv.sql Oracle
  • VIvek Encryption Package and Its Usage Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Database logon trigger issue Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • block_ident.sql Oracle
  • Export With Query Another Example. Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • Import and export statements Oracle
  • Histogram Overview Oracle

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

  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • sql_plan9i.sql Oracle
  • lck.sql Oracle
  • V$CONTROLFILE_RECORD_SECTION reference notes. Oracle
  • DB Console Mainenance. Oracle
  • SQL Tracker by SID sqltrackerbysid.sql 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • VIvek Encryption Package and Its Usage Oracle
  • Identical Dblink Issue… Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • fkwoind.sql fkwoindex.sql Oracle
  • v$backup.status information Oracle
  • Finding locked objects Oracle
  • proc.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme