So your dutiful Infrastructure Team upgrades the Data Domain backup appliance with the latest DD OS code and patches, bringing you up to the latest patch level.
After this, your RMAN backups using DD Boost start failing, and checking the sbtio.log file, which is found in the user dump destination, we see entries like this:
SBT-27970 (211074992) 04/01/16 21:45:01 ERR : [6D42:C94BFB0] ddp_open_file() failed for File: dd0205_boost/XIO11WSB_df_svr1vlas_1_1.bk, Err: 5034-nfs create failed (nfs: Permission denied)
SBT-27970 (211074992) 04/01/16 21:45:01 error 7501: sbtbackup: Could not create file XIO11WSB_df_svr1vlas_1_1.bk on host rstdd0205mgmt.us.oracle.com, error 5034
SBT-27973 (227712944) 04/01/16 21:45:01 ERR : [6D45:D929FB0] ddp_open_file() failed for File: dd0205_boost/XIO11WSB_df_t0r1vlas_1_1.bk, Err: 5034-nfs create failed (nfs: Permission denied)
SBT-27973 (227712944) 04/01/16 21:45:01 error 7501: sbtbackup: Could not create file XIO11WSB_df_t0r1vlas_1_1.bk on host rstdd0205mgmt.us.oracle.com, error 5034
Hybrid Columnar Compression is one of the new features that Oracle has been touting to persuade DBAs on the virtues of their Exadata and ZFSSA storage solutions.
As stated in my bio, I currently get paid by EMC, but this blog post is not another critique of Oracle sales massaging technical numbers on the assumption that you can use HCC for OLTP loads.
Rather, this is a USE AT YOUR OWN RISK method to explore what HCC can and cannot do. Using this method will render your databases unsupported by Oracle and you must NOT do this on any production or mission critical system. Please note I accept no responsibility for anyone destroying critical data from trying any of this.
Despite all the updates to the Oracle RAC installer, it is still an extremely brittle install process that frequently goes pear shaped.
A common problem is pilot-error, and a regular mistake is running the root.sh script on secondary nodes before it has fully completed on the primary node.
Oracle now provides the rootcrs.pl script in the Grid home crs/install directory.
To execute the script, connect to your first node and execute as follows:
Time Required: 60 minutes
- 5GB of disk space
- an ASCII text editor
Next we are going to add some shared disk to our new freshly minted VMs
VMware Workstation makes the allocation of shared disk to VMs very simple. Shared disk has been the biggest obstacle to create Oracle RAC clusters at home, but now VMware gives us a reliable and portable solution that does not require fire-wire hacks, your own NFS server or a SCSI disk array.
Best of all this whole solution can exist on a single laptop, so you can take your RAC on the road.
Back in 2005 I got interested in reverse engineering the Oracle data block.
I had already spent far too much time breaking apart the redo blocks, and had published an interesting paper on the matter called Disassembling the Redo Block which Frank Naude over at orafaq was kind enough to host for me. This was back before “blogging” became the ubiquitous pass time of Oracle DBAs it appears to be today.
Rich Niemiec at TUSC forwarded to me an interesting article on the Terilingua Block Viewer for Oracle, and so after a lot of searching around I found the BBED tool. What’s more, BBED was included in the standard Oracle distribution for Windows and Linux. On Linux all you had to do was link it.
And so armed with an old IBM Aptiva running Linux 8 Pro and a copy of Oracle 9i, I set about trying to figure out how the blocks of a database held together.
The result was a detailed analysis of BBED and how to use it. Although obsolete today, the article is still interesting to those DBAs who want to understand the inner working of Oracle. At the time it was quite popular, being cited by Pete Finnegan and Don Burlseon among others.
I include it here for posterity.
And no, you still have to work out the password for yourself 🙂
BBED – Disassembling the Oracle Data Block
Part IV – Fixing the Mess
When the 10g installer completes you will have an Oracle 10g install, a Clusterware Service and no database.
With the logical 32GB partition now stamped for ASM, it is now possible to use DBCA to create a new empty database, and DBCA will allow you to specify ASM as the storage medium, whereupon DBCA will also create the ASM instance for you.
However by default on Windows 7 this process will fail, with errors in the Clusterware Service.
Part III – Stamping the Logical Disk
Okay, so we partitioned the disk and we installed Oracle 10g. We now need to stamp our 32GB logical partition for ASM to use. To do this Oracle provides a helpful tool called asmtoolg.exe in the Oracle Home bin directory.
Launching this under Windows 7 results in the following: