VKTM detected a time drift.
Problem Summary VKTM detected a time drift. Please check trace file for more details. Download and apply patch # 11837095. …
Previous articles
Dataguard Delay / Apply and Transport Lag
i.e. SQL> set linesize 2000 select sysdate,sum(apply_finish) apply_finish, sum(apply_lag) apply_lag, sum(transport_lag) transport_lag, sum(startup_time) startup_time, min(TIME_COMPUTED) TIME_COMPUTED from ( select decode(name,’apply …
Delete Duplicate Rows
Finding and deleteing the duplicate rows of a table in Oracle Database. DELETE FROM OWNER.TABLEx z WHERE z.ROWID IN (SELECT …
MRP0: Detected orphaned datafiles!
Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback… Errors …
File # added to control file as UNNAMED
Errors in file …/trace/RAPOR_pr00_2801804.trc: ORA-01119: error in creating database file ‘/data/datafile_1.dbf’ ORA-27054: NFS file system where the file is created …
Difference between Hadoop and RDBMS
Hadoop vs RDBMS: RDBMS and Hadoop are different concepts of storing, processing and retrieving the information. DBMS and RDBMS are …
Excluding Table Partitions – expdp EXCLUDE=TABLE_DATA
Oracle Datapump – Using expdp utility excluding table & table partitions in a par file can be managed with the …
Physical Dataguard Configuration
Some fast and easy configuration scripts for Physical Dataguard installation… PRIMARY Site ALTER SYSTEM SET db_unique_name = DATABASE; ALTER SYSTEM …
SQLs for Tivoli Storage Manager
http://thobias.org –> I really appreciate the post of SQLs for Tivoli Storage Manager. Check out the site http://thobias.org SQLs for Tivoli …
Digital Economy Rankings 2010 – EIU
Digital Economy Rankings 2010 – EIU EIU Digital Economy Rankings – 2010
