|
||||
|
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 […]
In My primary alert log, ****************************************************************** LGWR: Setting ‘active’ archival for destination LOG_ARCHIVE_DEST_3 ****************************************************************** LGWR: Error 16047 creating archivelog file ‘STREAMS’ Mon Oct 15 23:58:24 IST 2012 Errors in file /u02/app/oracle/admin/PROD/bdump/prod2_lns2_16765.trc: ORA-16047: DGID mismatch between destination setting and standby LNS: Failed to archive log 5 thread 2 sequence 2759 (16047) Mon Oct 15 23:58:30 […] For doing a consistent expdp backup to use flashback_time , documentation provides to use systimestamp where it will fail always (as in my case now) Error:- Conneted to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64 bit Production With the Partionining,OLAP, Data Mining and Real Applicatiojn Testing options ORA-39001: invalid argument value ORA-39150: bad […] How to find the object that is causing excessive redo or archive generation between a given date. You can get from the v$log_history but for history you will need to query the awr history views as below. SELECT dhso.object_name, sum(db_block_changes_delta) FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhs […] All of the actions below are performed after careful analysis, any act of below in business critical system may cause serious implications. Issue : Undo lob corruption in one of the database. Ironically, the DB is in no archive log mode and no backup exist. Verify is it block corruption using db verify. XXXXXX:TEST1:UAT […] From 10g onwards there is a hidden parameter _fix_control that can be used to turn off/on a particular bug fix. (Be sure, this is hidden parameter and as usual note changing hidden parameters must be done after consulting Oracle) For example, a patch 5483301 has been recently applied to the database using opatch, and after […] Statement/session crashing with Few ora-07445 and a ora-600 (Publishing the statement is irrespective hence skipping)
ORA 600 [rworupo.2] ORA-07445: exception encountered: core dump [__intel_new_memcpy()+382] ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2AD2FD908088], [], [], [], [], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smboQbNxt()+103] [SIGSEGV] [ADDR:0x0] [PC:0x8F22023] [SI_KERNEL(general_protection)] [] Well […] Happy Reading!!! Hope you already aware of tracing sessions with different methods 11g onwards, you can trace a session (other session) with in the alter system command itself , no worries of finding pid etc etc. for example like below SQL> alter session set events ‘sql_trace {process : pid = <pid>, pname = <pname>, […] This time, impdp failing to create a job for import and failing with following error:- ORA-06512: at “SYS.KUPV$FT”, In many cases you sometimes stop data pump job or in case of an abnormal end of the Data Pump job (we call it the orphaned job) or using undocumented parameter KEEP_MASTER=Y, the master table remain in […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!