Oracle 23c New Features for DBA'sIf anyone want to know about the cron tab entries sequence, here it is.
– – – – – | | | | | | | | | +—– day of week (0 – 6) (Sunday=0) | | | +——- month (1 – 12) | | +——— day of month (1 – 31) | +———– […]
|
||||
|
Dear All, Attached the document for all your reference, which I found very useful and informative on dataguard best practices. this also helps in diagnosing and tuning dataguard related issues. Enjoy reading. http://db.geeksinsight.com/wp-content/uploads//2012/10/dataguard_bestpractices.doc -Thanks Geek DBA Want to know new features in 12c, 18c, 19c, 20c ??? Follow this More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/ More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/ More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/ Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/ Hello The following code snippets are collected from various sources and updating here, (not sure even about […]
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 […] A call today from one of my friend regarding switchover issue, once the role swap has been performed the standby (current primary) is not able to ship the redo log files. Verification:- 1) v$managed_standby in production(current standby) stucks at sequence “waiting for log” 2) Trace files shows Redo shipping client performing standby login OCISessionBegin […]
We all know that CGS (when 10g CRS uses, its OCSSD), (When used third party clusterware, CM) will provide Cluster group service which manages nodes integrity and restart them when there is node level (hardware,network,OS, scheduling) issues happens. So it means the CGS will manage the node level issues and also manages the cluster […] Well there are many sources to explain about the functionality of SQL Stored Outlines SQL Profiles SQL Performance Analyzer Adaptive Cursor Sharing SQL Plan Management Indeed all these tools are available to give the plan stability but with different ways. Basics:- Plan instability can occur due to bind value differences. Binds are used to reduce […] 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 […] |
||||
Follow Me!!!