Category Archives: Oracle in general

EMC offers so called cumulative hotfixes which include all available and tested hotfixes for a specific version. These hotfixes can be found at the following URL: ftp://ftp.legato.com/pub/NetWorker/Cumulative_Hotfixes

For corrupting a block dd can be used. Just adjust the “ibs” argument to match your database block size and adjust “count” to specify the amount of blocks to be corrupted. “Seek” specifies how many blocks are skipped (counted from … Continue reading →

Altough not oracle related i successfully completed my certification as an MS SQL Server DBA. In most companies MS SQL is used for smaller databases in addition to oracle. So from my point of view it is a plus. I … Continue reading →

This week a came across the following very interesting scenario: The customer made an RMAN online backup and saved it to an NFS location. Controlfile autobackup was on. During backup the backupset was written to that NFS location. The control … Continue reading →

The linux sg3_utils are small tools intended for working with FC / SCSI / SATA / SAS hard driv.es. They can be used to send SCSI commands (for instance INQUIRY, LOG SENSE, …) to these devices. sg3_utils can be found … Continue reading →

Starting with 11g Release 2 it is possible to store voting disks and OCR in ASM. But how does this affect ASM best practises? Martin Decker found the updated Oracle document about this issue. .

For using Large Pages on Windows some settings are needed: 1. Start > Settings > Control Panel 2. click Administrative Tools. 3. click Local Security Policy. 4. Expand Local Policies and select User Rights Assignment. 5. Select Lock pages in … Continue reading →

To determine the FC HBA WWN on Oracle Enterprise Linux (OEL) use: cat /sys/class/fc_host/host<number>/port_name For example: [root@host sys]# cat /sys/class/fc_host/host6/port_name 0x2100001b329308df [root@host sys]# cat /sys/class/fc_host/host5/port_name 0x2100001b329388d9

Oracle offers the ability to specify so called ‘alternative’ archive log destinations in case the primary archive log destination gets full. You can enable this feature by setting: log_archive_dest_1=’location=+FRA REOPEN=0 MANDATORY alternate=log_archive_dest_2′ log_archive_dest_2=’location=/some_path MANDATORY’ log_archive_dest_state_1=ENABLE log_archive_dest_state_2=ALTERNATE A configuration often used … Continue reading →