tag:blogger.com,1999:blog-10170351012349118492024-03-29T07:26:45.893+03:00Emre Baransel - Oracle Blog$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:00Mount Clone Database in TSPITR"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 "TablespaceEmre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com358tag:blogger.com,1999:blog-1017035101234911849.post-67477054048178537572015-11-30T10:31:00.000+02:002015-11-30T10:35:50.871+02:00Backup to ZFS Storage Appliance Best Practices for Exadata Database Machine
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.com83tag:blogger.com,1999:blog-1017035101234911849.post-65351133228298811982015-09-16T10:58:00.000+03:002016-06-20T23:08:20.146+03:00Exadata 12.1.2.2.0 Software is Released 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.com168tag:blogger.com,1999:blog-1017035101234911849.post-45829182435496336212015-09-15T16:57:00.001+03:002015-09-15T16:57:35.412+03:00DBMCLI for Exadata Database ServersMonitoring 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.com22tag:blogger.com,1999:blog-1017035101234911849.post-76625025548473632772015-07-20T15:18:00.000+03:002015-08-09T19:24:14.261+03:00Auditing on Physical Standby Database with XML
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 aEmre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com63tag:blogger.com,1999:blog-1017035101234911849.post-5513007123009769902015-06-20T16:17:00.001+03:002015-08-09T19:31:16.017+03:00A Deep Dive into ASM redundancy in ExadataI 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.com285tag:blogger.com,1999:blog-1017035101234911849.post-52137683226562066472015-05-18T00:16:00.000+03:002015-08-11T00:37:28.398+03:00TIMESTAMP to DATE Conversion with Online Redefinition
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.com76tag:blogger.com,1999:blog-1017035101234911849.post-58009501587194627642015-05-18T00:12:00.002+03:002015-08-10T00:35:28.343+03:00Standby Database SCN - x$kcvfh
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.com25tag:blogger.com,1999:blog-1017035101234911849.post-55873626228468664602015-05-18T00:09:00.000+03:002015-08-10T23:48:08.995+03:00Auditing on Oracle Database in a Nutshell (11gR2)
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.com158tag:blogger.com,1999:blog-1017035101234911849.post-61868693030257065592014-11-12T21:28:00.002+02:002014-11-12T22:13:09.981+02:00Active Data Guard 12c New Features - Oracle Day 2014Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com16tag:blogger.com,1999:blog-1017035101234911849.post-47836209843866649432013-12-05T15:34:00.000+02:002013-12-05T15:34:18.539+02:00Exadata MAA Presentation - Oracle Day 2013 Istanbul Exadata Maximum Availability Architecture from Yunus Emre Baransel Emre Baranselhttp://www.blogger.com/profile/02685026258606153633noreply@blogger.com5tag:blogger.com,1999:blog-1017035101234911849.post-50524421718248812482013-10-21T14:35:00.001+03:002013-10-21T14:37:00.129+03:00Packt Publishing e-book PromotionI 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:00The Book is Out!
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:00Data Guard Queries
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 beingEmre 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:00TROUG - Oracle EBS Day 2013Emre 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:00About "Expert Oracle Database Architecture" Book
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.com57tag:blogger.com,1999:blog-1017035101234911849.post-35571333897898429232013-02-18T16:46:00.001+02:002013-02-18T16:46:53.328+02:00Delete Force Noprompt Backuppiece
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:00Moving OCR & Voting Files In 11gR1 (Using Raw Devices)
-- 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:00Basic Oracle LogMiner StepsThis 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:00My Presentations at DOAG and UKOUG 2012 ConferencesAt 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:00TROUG Day 2012
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:00TROUG Exadata SIG Meeting 2012
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 ExadataEmre 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:00Book Review: Oracle Database 11gR2 Performance Tuning Cookbook
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:00My Presentation at OUG Ireland Conference 2012
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.com16tag:blogger.com,1999:blog-1017035101234911849.post-59631449581284199782012-02-06T01:11:00.000+02:002012-02-06T01:13:18.519+02:00Automatic Block Media Recovery on Maximum Performance ModeAutomatic 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