|
||||
|
When a large transaction got killed, terminated we all know that smon will do the rollback of the transaction, “smon: enable tx recovery” which can evident in alert log. Some time due to fast_start_parallel_rollback =high , lot of parallel sessions invoked and may complete hung your database or not permit any other session to work. […] In RAC, you may all know about a TAF services which gives the failover capability to availability instances when the preferred failed. But how does this can work in when you have a Dataguard Environment with Primary and standby. Well answer is until 10g/11gR1 create a trigger like below and manage the service based upon […] Uh!!, Yes should start with that Uh.. only. Let get back to one more post. One of my databases having I/O error, actually its a VM Linux machine with 11.2.0.2, I have removed the Virtual disk forcibly, (renamed) which is having one datafile. Actually, want to test this new hidden parameter “_datafile_write_errors_crash_instance”, which exactly crashed […] Very recently I have encountered this issue while cataloging the backup pieces in order to sync the standby server. Well this is all about that database DBID is different from the source (primary) database where you cannot/rman cannot see those backups relevant to this destination database. very obvious thing. This db in the issue has […] We all know that sys password is required and should be same on both the primary and standby databases, and many times during switchover, failover we encountered, ORA-01017: invalid username/password; logon denied, due to password mismatch etc. From 11g Onwards, a new parameter REDO_TRANSPORT_USER has been introduced to overcome this issue, […] ADRCI: Automatic diagnostic repository command interface, used to manage the diagnostic, health monitor, or incident packaging solutions for Oracle databases. This is the small adrci automatic purge script rather to rely on traditional log purging or housekeeping scripts. This script will check in /etc/oratab and list down all oracle homes and then set those Oracle […]
Housekeeping of logs , traces, diag directories is every DBA’s job and some may write their own , some adopt from others which is common. Often we found in our environments similar sort of scripts placed, which I found mostly were Non Pluggable to any new environments You cannot port it to others or […] As the data grows in relational databases (new business requirements, managing audit data etc), the cost associated with the disk systems to store that data and the resources required to manage them becomes vital. Hence it is necessary to adopt techniques like compression, de-duplication etc to reduce the storage costs. Lets go one by […] Yesterday My colleague has encountered the following issue, which is interesting. Environment:- 1) Linux & 10g Database 2) Oracle Block size =8192 3) OS Block/Page size = 4096 Issue:- ORA-01200: actual file size of X is smaller than correct size of Y Verification:- 1) Database was not opening (non system datafile) 2) DBV says no […]
When I was working for a tool in Apex some time back, need some scripts on automatic date generation, after some googling and changing the modified ones, here are some scripts that useful to generate a date in sequence etc.
Generating dates for a month =================== select to_date(’01 2010′,’MM YYYY’)-1 + level as […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!