Posts Categorized: Technical Blog

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation. However, I did review Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit…

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved…

Oracle RMAN Restore to the Same Machine as the Original Database

Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In such situations, the biggest fear is overwriting the original database. Here is a simple procedure…

RMAN Infatuation?

Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear datafile fuzziness If you are, then I will demonstrate this for you. RMAN LEVEL0 backup…

MySQL Community Dinner at Pedro’s

Pythian organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week. Here are the details..

Vim::X – VimL is Eldritch, Let’s Write Perl!

Last week, I finally got around writing a few macros to help with conflict resolution in Vim: ” conflict resolution – pick this one / option 1 / option 2 map ,. $?\v^[<=]{7}jy/\v^[=>]{7}?\v^[<]{7}”_d/\v^\>{7}”_ddP map ,< $?\v^[<]{7}<,>. map ,> $?\v^[<]{7}/\v^[=]{7}<,>. ” … or keep’em both map ,m $?\v^[<]{7}”_dd/\v[=]{7}cc/\v[>]{7}”_dd With that, I can go from conflict to…

RMAN – Validating Archivelog Backup

There are many posts out there about validating backup. However, none seem to address some recent concerns a client of mine had. Currently, backup validation is performed once a week and the question asked,  “How to validate all archivelog backup?” List Backups – [D}atafile and [A]rchivelog backup from Incremental Level 0/1 RMAN> list backup summary;…

What Happens When Active DB Duplication Goes Wrong?

There are many blog posts out there about active database duplication. However, they were all tested in an ideal environment or condition. What happens when a tablespace is created during the middle of active duplication and how to resolve the error? Read on if you would like to know. For my test case, I created…

Page 5 of 59« First...34567...102030...Last »