This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments.
Also to make this blog more useful, please give your comments and share your experience. Thanks

Wednesday, 25 February 2009

Introduction:We had interesting but painfull issue for Oracle backups which are done with Veritas Netbackup. There was activity of patching on Netbackup. And after the patching there was issues with Oracle Backups. All the Oracle backups were failing with following error messages....

The above error messages of udump trace file, was clearly showing that the libobk.so64.1 was not able to load. And also we found valid symbolic link from $ORALCE_HOME/lib/libobk.so to /usr/openv/netbackup/bin/libobk.so64.1

Resolution:After trying every way, finally our system admin did one thing and got resolved the issue. What he did, he renamed the /usr/openv/netbackup directory and again pushed the netbackup client from Netbackup Server, and we again tested the Oracle Backups and it was all working. Following is the simple allocation of channel of 'sbt_tape'

Sunday, 22 February 2009

Introduction:In this article we will see, the impact of "Parallel" clause of rebuilding a partition index. We would also enable tracing on the session which execute the Alter index rebuild statement, and also all those parallel sessions, which are invoked automatically when we use "Parallel" clause.

Steps:For this test, we can make one partitioned index unusable, we will use exchange partition clause of Oracle 9i, without specifying "Update global indexes", this will cause index unusable. And then we will rebuild both with "Parallel" and without "Parallel" clause.

About Me

I have more than 15 years of experience in IT. I am working being Senior Database Administrator / APPS DBA for an IT consultng company in New Zealand. I am Oracle Certified Professional DBA in Oracle 7.3, 8.0, 8i, 9i and 10g. I have worked on Oracle 10g RAC, Oracle Replication and Oracle Data Guard technologies.