{"id":1288,"date":"2007-06-22T12:00:00","date_gmt":"2007-06-22T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1288"},"modified":"2007-06-22T12:00:00","modified_gmt":"2007-06-22T12:00:00","slug":"sigh","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/06\/22\/sigh\/","title":{"rendered":"Sigh"},"content":{"rendered":"

Whilst I might admire Alex G’s<\/a> new BAAG party<\/a>, I have less lofty ideals. My personal battle is against people who keep offering the following sage advice to the crucial question – How do I backup my database?<\/a><\/p>\n

\n

\nAs UNIX user oracle run:\n<\/p>\n<\/p>\n

TODAY=`date \"+%Y-%m-%d\"`\nFILE=$TODAY-$ORACLE_SID.dat\n\nexp system\/manager file=$FILE consistent=y full=y compress=n\ngzip $FILE<\/pre>\n<\/blockquote>\n
There are so many things I could say about that web page, I wouldn’t know where to begin 🙁<\/p>\n
Thanks to Alex Hyslop for the link.<\/p>\n","protected":false},"excerpt":{"rendered":"
Whilst I might admire Alex G’s new BAAG party, I have less lofty ideals. My personal battle is against people who keep offering the following sage advice to the crucial question – How do I backup my database? As UNIX user oracle run: TODAY=`date “+%Y-%m-%d”` FILE=$TODAY-$ORACLE_SID.dat exp system\/manager file=$FILE consistent=y full=y compress=n gzip $FILE There… Continue reading Sigh<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1288","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1156,"url":"http:\/\/orcldoug.com\/blog\/2006\/12\/07\/a-more-complex-statspack-example-part-2\/","url_meta":{"origin":1288,"position":0},"title":"A More Complex Statspack Example – Part 2","date":"December 7, 2006","format":false,"excerpt":"So far we're barely into the comparison of the Statspack reports from the two different test environments and they look quite different already.Next up, the Instance Efficiency Percentages. I have to confess that I rarely find these very useful because the numbers are always near 100% on most databases I\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1585,"url":"http:\/\/orcldoug.com\/blog\/2010\/03\/11\/hotsos-2010-day-4\/","url_meta":{"origin":1288,"position":1},"title":"Hotsos 2010 – Day 4","date":"March 11, 2010","format":false,"excerpt":"First up was Cary Millsap's - Lessons Learned, Version 2010.03 As Cary pointed out, they always try to put the best speakers in the toughest slots - 8:30 in the morning post-party. I think local guys are slightly more reliable too because they might have actually gone home the night\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1574,"url":"http:\/\/orcldoug.com\/blog\/2010\/03\/07\/hotsos-2010-my-agenda\/","url_meta":{"origin":1288,"position":2},"title":"Hotsos 2010 – My Agenda","date":"March 7, 2010","format":false,"excerpt":"Let's see how well I can stick to thisSunday18:00 - Registration and Reception21:00 - BedMonday09:45 - Tom Kyte: All About Metadata: Why Telling the Database about Your Schema Matters\u00a0 \u00a011:00 - Richard Foote: Oracle Indexing Myths12:00 - Lunch (make sure new laptop works with projector, get changed and start panicking\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1701,"url":"http:\/\/orcldoug.com\/blog\/2013\/03\/18\/10053-trace-files-getting-started\/","url_meta":{"origin":1288,"position":3},"title":"10053 Trace Files – Getting Started","date":"March 18, 2013","format":false,"excerpt":"Before getting into the contents of a 10053 trace file and looking at any useful stuff, you need to know what the files are for and how and where they are created. Essentially, setting event 10053 causes the Cost Based Optimizer to write information to a trace file describing the\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1488,"url":"http:\/\/orcldoug.com\/blog\/2009\/04\/22\/diagnosing-locking-problems-using-ashlogminer-part-7\/","url_meta":{"origin":1288,"position":4},"title":"Diagnosing Locking Problems using ASH\/LogMiner \u2013 Part 7","date":"April 22, 2009","format":false,"excerpt":"Picking up from the end of the last example, I immediately generated a log file dump as follows. (You'll need to look back at Part 5 to see that the ROWID, log file name etc. match up or just trust me that these steps came from a continuation of the\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1489,"url":"http:\/\/orcldoug.com\/blog\/2009\/04\/22\/how-to-induce-log-file-sync-waits\/","url_meta":{"origin":1288,"position":5},"title":"How to induce log file sync waits","date":"April 22, 2009","format":false,"excerpt":"(With my tongue causing a minor gash on the inside of my cheek ....)I'm working on an application that seems to suffer constant long waits on log file parallel write and, consequently, log file sync. I thought that the 54 ms log file parallel writes where just typical of an\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1288"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1288\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1288"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}