A very tricky and interesting situation came-up this morning while configuring one of the standby databases of over 1.5TB sized . Whilst the database is being cloned to the DR site as part of the DUPLICATE..ACTIVE DATABASE command, which actually took more than 1.5 day, a couple of
(more...)
A quick update about the new page.
I have created a new page (tab) 'Data Guard' on my blog to share/discuss all data guard related issues that we confronted during our extensive DR setup and testing. The objective is to record all the errors/issues of data guard setup and how
(more...)
Just a very quick update about my upcoming tasks and what I will be doing for the next 3 weeks time.
It is indeed going to be a super busy rest of the month for the entire team as over 41 RAC databases data guard configuration need to be done.
(more...)
The objective of this summary is to emphasize the importance of considering things like verifying the patch compatibility and relinking the home after the underlying Operating System (OS) patch deployment in any Oracle environment. I would like to share an incident (a little story) that we encountered a few days
(more...)
My upcoming webinar 'Managing & Troubleshooting Cluster - 360 degrees' sponsored/arranged by RedGate is scheduled on 25th April 2013. The following topic will be covered during the course of the presentation:
What's new in 11gR2
Clusterware – Key new features at a glance
Oracle 11gR2 Clusterware software stack
Clusterware start
(more...)
I am afraid, it is not a so good news for those who manage 11.2.0.1|2 RAC databases. On a very unfortunate day, an RAC database db | instance shutdown normal|transactional|immediate mode could result in an ORA-600 errors or may cause logical corruption to the redo stream .
According to the MOS ID [1318986.1] , when a RAC instance(s) (11.2.0.1|2) shutdown either in normal|transactional|immediate
Are you planning a database upgrade keeping a back-out (downgrade) plan in mid? Here are a few very important MOS docs explains all about:
How To Downgrade From Database 11.2 To Previous Release (includes 11.2.0.3-11.2.0.1) [ID 883335.1]
Database Server Upgrade/Downgrade Compatibility Matrix [ID 551141.1]
Master Note For Oracle Database Downgrade [ID 1151427.1]
Downgrading Database Without
The IOUG Cloud Computing Special Interest Group (SIG) is
dedicated to communication and information interchange around the
subject matter of Cloud Computing centric to Oracle.
The main purpose of the SIG is to discuss and share independent
thought, challenges, options, and best practices on key areas of Cloud
Computing from the perspective of Oracle. Topics will be discussed
freely in this
Just a very quick update about the upcoming event in your city (India).
If you are around in India, don't miss the OTNYathra event scheduled between 15 & 27 February 2013. Many world known Oracle ACE Directors, Java champions and other experts are presenting. For more details and registration, visit the following links:
www.otnyathra.com or otnyathra.info
Good luck to all the presenters and
Interested learning more about Virtualization and Oracle VM technologies? Don't wait, just enroll now to the upcoming IOUG Virtualization SIG Symposium, scheduled on November 7-8, to hear what the industry experts has to say on virtualization technologies.
Here is a brief synopsis/highlights of IOUG SIG Virtualization Symposium:
November 7 - Oracle on Oracle VMRegister Today10:00am - 10:55am
Well, as an Oracle DBA, we have been taught and learnt the various database shutdown modes, NORMAL|IMMEDIATE|TRANSACTIONAL|ABORT that would be used as situation demands.
When the NORMAL|IMMEDIATE mode doesn't work, as a last resort, we use the 'SHUTDOWN ABORT' to terminate an active instance as quickly as possible, leaving a database inconsistent mode. Of course, the subsequent database startup
The other day I was building some test scenarios for my chapter, and accidentally discovered adding new instance to an existing RAC database was made simply in 11.2.0.2. I still remember the long procedure we use to practice to add a new instance, either manual or using the DBCA. However, in 11.2.0.2, with simple 'srvctl add instance -d -i -n ' command
Subscribing the 'Oracle Support HOT Topics' to receive an email notification about Oracle latest Bugs, Knowledge articles, Product News and etc via MOS was one of the good things I had done in the recent past. Upon subscription, all MOS users start receiving a daily dosage of important updates about BUGS, SRs, Articles and etc. If you don't want to miss the important updates, do subscribe
Well, I have got very exciting news to share with you all here. For the first time ever in my professional career, I would be presenting a keynote session: Yet another milestone in my professional career. I am indeed very much excited, at the same time, a bit nervous too.
I would be presenting a keynote session on 'Oracle 11g High Availability New Features' topic at the upcoming Turkish Oracle
Interested learning more about Virtualization and Oracle VM technologies? Don't wait, just enroll now to the upocming IOUG Virtualization SIG Symposium, scheduled on November 7-8, to hear what the world known virtualization experts has to say about the technologies.
Here is a brief synopsis/highlights of IOUG SIG Virtualization Symposium:
November 7 - Oracle on Oracle VM
Register Today
10:
After successfully applying the latest PSU (7) patch in two non-production and one production 11gR2 cluster environments, now its time to get ourselves more tougher and stronger. Its now time to apply the patch in the most business critical and very complex cluster (20 node) environment.
With our past patching experience in different cluster environments, we noted that the average time that
When a full database datapump import operations executed this morning to load data from an Oracle 11gR1 db to 11gR2 db, the job got failed with the following ORA errors on over 50 tables that has LOB data type:
ORA-31693: Table data object failed to load/unload & is being skipped due to ORA-02354: error in exporting/importing dataORA-00600: internal error code, arguments: [
Here is a very quick and short blog update about the issue we had confronted whilst performing an addNode action.
As part our ongoing HPUX servers migration project (Superdom 1 to Superdome 2 ), we agreed on a plan, where we wanted to add same amount of nodes (new configuration) to the exists cluster environment and then delete the old nodes after successfully migrating everything over the new
Hi everyone,
A very quick update about upcoming OOW2012 event.
OOW2012 content catalog is out now (https://blogs.oracle.com/oracleopenworld/entry/it_s_alive). You can now search for your favorite sessions and sessions. Don't wait any longer, start planning your events from now.
See you at OOW2012.
Jaffar
Before I really get started discussing seriously about the subject matter, I would like to shared and echo what Coskan's had said at his blog.
"Every Oracle version, developers at Oracle add or change some of the
undocumented parameters to do better optimization. Most of the time
these new optimizations
works fine but from time to time they have a negative effect for the
generated plan which
RSS