ITEC Newsletter
Vol.13, No. 1
March 25, 2005


Table of Contents

1.                HP VMS/TRU64 License Paks Expiring
2.                Spring 2005 Wizard Presentations/Evaluation
3.                Oracle Architecture Presentation at Wizard
4.                Logminer and Supplemental Logging


 

 1.    HP VMS/TRU64 License Paks Expiring

Your HP VMS and TRU64 License Paks are about to expire at the end of April 2005.  The new license Paks are now in ITEC’s Web Getsoftware.  Please have your site license manager request the license Paks:  

http://www.itec.suny.edu/scsys/getsoftware  

Third Party / Oracle Offerings – Only for the TRU64 License Paks:
PAKS_APR06_TAR

OR

HP Alpha Software Offerings – Alpha VMS
LICPAKS30APR06

Submitted by Joe Weber (scsys@itec.suny.edu)

 

2.                  Spring 2005 Wizard Presentations/Evaluation

Presentations on Oracle and Comparative Architecture from the Spring 2005 Wizard (March 8 and 9) can be found at: http://www2.itec.suny.edu/wizard/2005/spring

In order to improve the conference and to meet your expectations, we ask that you take a moment to complete the brief online evaluation via the link below. If you have already submitted a paper response, we thank you for your response.

http://www.tc.suny.edu/surveys/spring2005wiz.asp

Submitted by Barbara Boquard (Barb.Boquard@itec.suny.edu)



3.         Oracle Architecture Presentation at Wizard:

For those that missed the spring wizard you can view a presentation ITEC gave on Oracle architecture including RAC at: http://www2.itec.suny.edu/wizard/2005/spring/oracle/ In addition to the presentation check out the Collateral folder for a number of white papers and other presentations on the subject.

FYI - A very useful utility for RAC testing/benchmarking can be found at http://www.dominicgiles.com/swingbench.php – works on Windows, Unix, Linux and even Mac OSX.

Submitted by Dan Brint (scadm@itec.suny.edu)



4.         Logminer and Supplemental Logging:

We recently had an incident in which 1000+ rows were accidentally deleted from a table. When attempting to recover these using Oracles Logminer utility we found that we could not fully recover all of the deleted rows. A number of the rows in V$LOGMNR_CONTENTS had  ‘UNSUPPORTED’ values In Sql_redo and Operation columns and so these could not be recovered. Working with Oracle it was uncovered that there is an existing bug (current today) across multiple versions of Oracle on multiple platforms that caused this (bug 3871388). This bug causes insufficient information to be written to the redo logs for logminer usage.  To LESSEN the probability of this recurring Oracle encourages the enabling of ‘Supplemental Logging’:

To see if supplemental logging is enabled, start a SQL session and query the V$DATABASE fixed view. For example, enter: 

SQL> SELECT SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI FROM V$DATABASE;

If supplemental logging is enabled  you will see results like this:               

SUP SUP

--- ---

YES YES

If not then supplemental logging is not enabled. To enable this feature execute the following statements:

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

SQL> ALTER SYSTEM SWITCH LOGFILE;

The increase in size of redo logs is minimal and the probability of this recurring is greatly reduced.

Submitted by Dan Brint (scadm@itec.suny.edu)

 

Editor:  Barbara A. Boquard

Barb.Boquard@itec.mail.suny.edu

ITEC's General Office

716/878-ITEC (4832)

Operations

716/878-5122

FAX

716/878-3485

Web Page

http://www.itec.suny.edu

 


ITEC Home