tag:blogger.com,1999:blog-10170351012349118492026-04-08T14:20:06.396+03:00$emre/baransel@oracle as sysdbaEmre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.comBlogger96125tag:blogger.com,1999:blog-1017035101234911849.post-1578222112357546382016-02-04T16:57:00.002+02:002016-02-04T16:58:31.650+02:00

"alter database mount clone database" is a statement that forces all datafiles to be put OFFLINE when mounting the target instance. You'll see it's being used in the background when you run RMAN commands like: "transport tablespace" "recover tablespace .. auxiliary destination .." "recover table"  (12c feature) In my case, i was trying to recover an 11.2.0.4 dropped table using "Tablespace

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com372tag:blogger.com,1999:blog-1017035101234911849.post-67477054048178537572015-11-30T10:31:00.000+02:002015-11-30T10:35:50.871+02:00

I made a presentation called "Best Practices for Exadata Maximum Availability" at BGOUG autumn event last week. In addition to general Exadata best practices about backup&recovery, disaster recovery, RAC&ASM, corruption detection features; i reserved half of my time to speak about integration of Exadata and ZFS storage appliance for the best performance of database backup&recovery.

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com92tag:blogger.com,1999:blog-1017035101234911849.post-65351133228298811982015-09-16T10:58:00.000+03:002016-06-20T23:08:20.146+03:00

Good new features announced, such as finding Flash Cache and Flash Log statistics on AWR, automatic ASM data redundancy check even shutting down a storage server by pressing the power button or through ILOM, preventing Flash Cache population in cell to cell rebalance, disabling SSH on Storage Servers and running CellCLI commands from Compute Nodes via new ExaCLI utility. Find details in the MOS

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com178tag:blogger.com,1999:blog-1017035101234911849.post-45829182435496336212015-09-15T16:57:00.001+03:002015-09-15T16:57:35.412+03:00

Monitoring database servers for hardware failures in Exadata used to be an issue. We have CELLCLI for storage servers where we can make many administration tasks and set SMTP configuration to receive e-mail for hardware failures. For the DB servers we were able to configure SMTP Client on database server's ILOMs for email alerts but it was not a straightforward and easy configuration as we do in

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com24tag:blogger.com,1999:blog-1017035101234911849.post-76625025548473632772015-07-20T15:18:00.000+03:002015-08-09T19:24:14.261+03:00

Turning on auditing on a physical standby database may be preferred when you want to audit the queries against the read only standby database. Obviously it's not possible to keep audit records on standby database by setting audit_trail to DB or DB_EXTENDED. Because the database is read-only and the aud$ table is just being synchronized with the primary aud$. So the DB or DB_EXTENDED setting on a

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com71tag:blogger.com,1999:blog-1017035101234911849.post-5513007123009769902015-06-20T16:17:00.001+03:002015-08-09T19:31:16.017+03:00

I made this presentation at Serbia Oracle User Group event in Zlatibor and Harmony 2015 event in Tallinn at last month. Both were very nice organizations that i really enjoyed, learned much and met with many Oracle experts. I prepared this presentation to answer to following questions, which i think are really important for Exadata Database Machine administrators: - To what degree, disk and

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com287tag:blogger.com,1999:blog-1017035101234911849.post-52137683226562066472015-05-18T00:16:00.000+03:002015-08-11T00:37:28.398+03:00

Online redefinition is a great way to make structural change on "big" tables having "lots of" DML. Using online redefinition, partitioning-nonpartitioning, adding-dropping columns, changing column data types, moving to another tablespace and more can be done with a very small unavailability of the table when compared with direct operations.  Here are some online redefinition MOS

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com77tag:blogger.com,1999:blog-1017035101234911849.post-58009501587194627642015-05-18T00:12:00.002+03:002015-08-10T00:35:28.343+03:00

The case was to roll forward a physical standby with an RMAN SCN incremental backup taken from primary. The standby database was just restored and necessary archived logs was missing somehow (That's another story). It was something i already did in the past so we set to work with my previous notes. Took the backup, copied files to standby server and recovered standby database. But the problem

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com29tag:blogger.com,1999:blog-1017035101234911849.post-55873626228468664602015-05-18T00:09:00.000+03:002015-08-10T23:48:08.995+03:00

In an Oracle Database we can mention following auditing types: Mandatory Auditing Standard Auditing Fine-Grained Auditing SYS Auditing Mandatory Auditing causes database start-up/shut-down and SYSDBA-SYSOPER login logout information to be written into AUDIT_FILE_DEST. This auditing cannot be turned off and it's always written into operating system directory specified with

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com159tag:blogger.com,1999:blog-1017035101234911849.post-61868693030257065592014-11-12T21:28:00.002+02:002014-11-12T22:13:09.981+02:00

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com15tag:blogger.com,1999:blog-1017035101234911849.post-47836209843866649432013-12-05T15:34:00.000+02:002013-12-05T15:34:18.539+02:00

Exadata Maximum Availability Architecture from Yunus Emre Baransel

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com6tag:blogger.com,1999:blog-1017035101234911849.post-50524421718248812482013-10-21T14:35:00.001+03:002013-10-21T14:37:00.129+03:00

I would like to inform you that, to mark Columbus Day, Packt is offering its entire catalog of eBooks and videos at 50% off. This is te last day of the promotion. If you plan to buy some e-books don't miss this. http://bit.ly/1bqvB29 Discount code: COL50 

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com6tag:blogger.com,1999:blog-1017035101234911849.post-10069430025830175572013-07-18T01:23:00.000+03:002013-07-18T01:23:24.594+03:00

After one year of hard work, it's very nice to introduce the Oracle Data Guard 11gR2 Administration book written by me and Nassyam Basha. As for me, i can honestly say that it has been a really good book and will help its reader a lot to learn and implement Data Guard. We wanted to prepare a book that starts Data Guard from scratch and covers all important details of it with clear and easy to

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com8tag:blogger.com,1999:blog-1017035101234911849.post-28501036645423326022013-07-02T17:27:00.000+03:002015-12-02T14:40:21.525+02:00

After all those years, my 5 years old post “How To Query Dataguard Status” still has the top visitors of this blog, so I wanted to write a fresh one including newer queries, commands. Here it is: Standby database process status: You can run following query on standby database to see what MRP and RFS processes are doing, which block of which archivelog sequences are being shipped or being

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com15tag:blogger.com,1999:blog-1017035101234911849.post-30381488486995676682013-03-19T01:02:00.002+02:002013-03-19T01:03:12.364+02:00

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com3tag:blogger.com,1999:blog-1017035101234911849.post-90389881338355833132013-03-19T00:21:00.000+02:002013-03-19T00:24:26.399+02:00

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 have to start offering consultancy services to SQL Server users because the number of clients needing

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com56tag:blogger.com,1999:blog-1017035101234911849.post-35571333897898429232013-02-18T16:46:00.001+02:002013-02-18T16:46:53.328+02:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com5tag:blogger.com,1999:blog-1017035101234911849.post-23227086804678094232013-02-16T10:25:00.001+02:002013-02-16T10:27:03.513+02:00

-- 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 &

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com10tag:blogger.com,1999:blog-1017035101234911849.post-19979183969504302132013-02-16T08:13:00.001+02:002013-02-16T08:21:21.983+02:00

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.

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com24tag:blogger.com,1999:blog-1017035101234911849.post-39849336946204128452012-10-09T16:05:00.000+03:002013-02-16T08:14:37.395+02:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com3tag:blogger.com,1999:blog-1017035101234911849.post-14108942471333824872012-10-01T16:28:00.000+03:002013-03-19T01:03:23.013+02:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com6tag:blogger.com,1999:blog-1017035101234911849.post-64013699058862838322012-05-15T14:51:00.001+03:002013-03-19T01:03:33.558+02:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com7tag:blogger.com,1999:blog-1017035101234911849.post-90955083845367518992012-04-12T15:49:00.001+03:002012-04-13T19:59:03.640+03:00

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 (

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com10tag:blogger.com,1999:blog-1017035101234911849.post-39755111259192111262012-02-20T14:31:00.000+02:002012-04-13T19:58:15.990+03:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com17tag:blogger.com,1999:blog-1017035101234911849.post-59631449581284199782012-02-06T01:11:00.000+02:002012-02-06T01:13:18.519+02:00

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

Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com15