RMAN/DD Boost backup fails with Error 5034 after Data Domain upgrade

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

Continue reading

Using Oracle HCC Compression on VMware Workstation without Exadata or ZFSSA disk

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.

Continue reading

Oracle 11gR2 RAC Install – cleaning up a failed install on Linux

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:

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VIII

Time Required: 60 minutes

Class Materials:

  • 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.

Continue reading

Disassembling The Oracle Data Block

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

ASM Sandbox – Oracle 10gR2 on Windows7 32bit – Part IV

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.

Continue reading

ASM Sandbox – Oracle 10gR2 on Windows7 32bit – Part III

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:



Continue reading