OraNA :: Oracle News Aggregator

I'm reading the "Expert Oracle Database Architecture" book of Thomas Kyte, which is a must read for everyone who is serious on being an Oracle DBA. Jonathan Lewis already said: "Frankly, if every DBA and developer in the world were made to work carefully through Tom Kyte’s book, I’d probably (more...)

In some cases you may not be able to delete the obsolete RMAN backup pieces that are visible with “report obsolete” command. In my case, after a switchover, i was getting the following error when my daily backup scripts tries to delete obsolete backups after the crosscheck: RMAN-06216: WARNING: db_unique_name mismatch - 334 objects could not be updated RMAN-06218: List of objects requiring

-- Query current status of OCR and Voting Files: oracle@server1:/> cat /etc/oracle/ocr.loc  ocrconfig_loc=/dev/ocr1_test11g ocrmirrorconfig_loc=/dev/ocr2_test11g local_only=FALSE oracle@server1:/> crsctl query css votedisk  0.     0    /dev/voting1_test11g  1.     0    /dev/voting2_test11g  2.     0    /dev/voting3_test11g Located 3 voting disk(s). -- Check OCR integrity

This is a quick note about using LogMiner for mining archived redo logs on the database itself. (Source and mining databases are same) - Specify a dictionary file with the following procedure: EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle/acs/logmnr', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE); - Determine the minimum and maximum archived log sequences that is in the mining scope. -

At the end of this year, i'll speak at the two biggest Oracle events in Europe, DOAG 2012 and UKOUG 2012 conferences. I'm very excited to attend and experience these organizations, also listen to and meet with many Oracle fellows. I'll speak about advanced Data Guard topics on my both presentations. Here are the highlights of my presentation: Configuration Considerations Redo Apply and Redo

Türk Oracle Kullanıcı Grubu TROUG yılın en büyük etkinliğini 11 Ekim'de Bahçeşehir Üniversitesi'nde düzenliyor. Etkinlikte DBA ve Developer odaklı sunumlar farklı salonlarda gerçekleştirilecek. Açılış sunumunda  ACE Director, OCM ve DBA of the Year 2011 ödülünün sahibi Syed JaffarHussain "Oracle High Availability 11g New Features" üzerine konuşacak. Sonrasında birçok değerli Oracle

TROUG Özel İlgi Grubu (SIG) etkinliklerine hız kesmeden devam ediyor. Nisan ayında gerçekleşen "TROUG Exadata SIG Meeting 2012" de Türkiye'deki Exadata kullanıcıları bir araya geldi ve birbirinden faydalı sunumlar yapıldı. Etkinliğin sonunda ise "DWH Global Leaders" program yöneticisi Reiner Zimmermann'ın katıldığı bir sohbet toplantısı gerçekleştirildi.  Siz de TROUG Exadata SIG

I started reading this book last week, and I'm half way through right now. But i wanted to write this review because what i found in the book is fairly enough for this. As the book's tittle expresses it involves examples, recipes, different test cases for almost all topics in the chapters. This is great, because just definitions and descriptions are not enough to fully understand the concept (

I'll present at OUG Ireland Conference, Wednesday 21st March in Dublin. My presentation will be on Oracle Data Guard as in the Open World last year. I'm looking forward to present, listen to and meet with new people. There are a wide range of topics from Oracle professionals in the agenda. There will be 6 streams and 35 sessions in total. Well known Oracle ACEs/ACE Directors and Oracle

Automatic Block Media Recovery is a cool 11gR2 feature. If the database on which a corruption occurs is associated with a real-time query physical standby database, then the database automatically attempts to perform block media recovery. The primary database searches for good copies of blocks on the standby database and, if found, repairs the blocks with no impact to the query that

I was very used to create ASM instance manually before 11gR2. With 11gR2 we must to install Grid Infrastructure even on sigle instance databases if we’re going to use ASM. In my last installation i had strange errors that i’ll share below. First error was complaining about the password and the log file is: INFO: Executing ASMCA INFO: Command /u01/app/oracle/product/11.2.0/grid/bin/asmca -

I had the following error on 11gR2 Grid Infrastructure installation: [INS-20802] Oracle Net Configuration Assistant failed.  The plug-in failed in its perform method tail -50 /u01/app/oraInventory/logs/installActions2012-01-06_09-45-58AM.log INFO: Oracle Net Listener Startup: INFO: The information provided for this listener is currently in use by other software on this computer.

I knew a little about Webcenter and Packt's Oracle Webcenter 11g book was very helpful for me to learn about the new version and developing the administration skills. Yannick Ongena did a greate job on this book with a uniqe style of teaching. In this book topics are covered with 4 dimensions. "Getting ready" "How to do it..." "How it works..." and  "There's more..." With this way of

Here is another greate book i read and recommend, published by Packt and written by  Ashwin Kumar Karkala and Govinda Raj Sambamurthy. This is about Oracle Enterprise Grid Control. Book is named with "Business Service Management" to impress the capabilities of Grid Control. Grid Control is not just for your Database Monitoring needs, but also for a complete service management which includes

I wanted to summirize some complicated RMAN concepts, using the "11gR2 Backup and Recovery User's Guide" definitions. Channel & ParallelismThe number of channels available for use with a device when you run a command determines whether RMAN reads from or write to this device in parallel while performing the command. When the work is done in parallel, the backup of the files is done by more than

I submitted for Open World 2011 with a presentation titled "Effectively using Oracle Data Guard for multiple purposes". After the voting phase, Oracle reviewed and accepted my session. Here are some details of my presentation. Hope to see you there. Type:                               Conference Presenter:                         Emre Baransel Primary Track Database:   High Availability

I've just finished reading the book "Oracle GoldenGate 11g Implementer's Guide" written by John P. Jeffries and published by PACKT. I strongly advise this book for solution/database architects who wants to learn what GoldenGate can do and how, database administrators who are new to GoldenGate and wants to learn the technical details of implementations and GoldenGate experienced administrators who

I'll be presenting at TROUG (Turkish Oracle User Group) Day 2011 on 21 April about "Using Oracle Dataguard Efficiently". Jonathan Lewis will be there with keynote and a presentation titled "Thinking About Joins". There will be very valuable presentations from valuable professionals. You can find event details here: (in Turkish) This event will be live streamed on the internet: http://

I wanted to share my notes on "Oracle Data GuardConcepts and Administration 11g Release 2" document. 11gR1 New Features · Compression of redo traffic over the network in a Data Guard configuration : This feature improves redo transport performance when resolving redo gaps by compressing redo before it is transmitted over the network. · You can now find the DB_UNIQUE_NAME of the primary