Oracle Database Patch: 10.2.0.5

Initially 10.2.0.5 patchset was released with respect to Oracle Enterprise Manager (OEM). Oracle have released Oracle 10g 10.2.0.5 Database patch on Apr-29-2010. Oracle has released this database patch - 10.2.0.5 after 2 years of 10.2.0.4 patchset.

Below are the patch numbers:

5337014 Oracle Database Family: Patchset 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER

6810189 Oracle Database Family: Patchset 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER

8202632 Oracle Database Family: Patchset 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER

Metalink note for manual upgrade to 10g R2 is 316889.1 (Complete Checklist for Manual Upgrades to 10gR2)

There is a confusion with what is meant by PSU. PatchSet Update (PSU) is a bunch of one off-patches and critical patch update (CPU). Always raise SR with oracle to confirm the upgrade process before doing it on Production.

Oracle: Duplicate Controlfile in ASM

Control file is one of the most critical components of Oracle Database. It is recommended to have multiple copies spread across different DISKGROUPS (in ASM) or different file system. If the control file is lost Database crashes.

Below are the steps for creating a duplicate control file in ASM with INIT file.

1. Shut down the database using Shutdown Immediate.

2. Edit the init.ora to include the second disk group.

Control_files=('+DISK1','+DISK2')

You can create directory within the DISKGROUP if needed. Below are the two ways to do that

a) Alter diskgroup DISK1 add directory '+DISK1/QA_DB/Control';

or

b)
ASMCMD> cd DISK1/QA_DB
ASMCMD> mkdir Control

3) Startup the database in NOMOUNT state.

4)
rman nocatalog
RMAN> Connect target
RMAN> Restore controlfile from '+DISK1/';

5) Mount the database followed by Open.

6) check the control file by
show parameter control.


Duplicate Control File in ASM with SPFILE

1) Modify the SPFile
Alter system set control_files='+Disk1/QA_DB/Control/current.xxx.yyyy','+DISK2' scope=spfile;

2) Start the instance in NOMOUNT state

3)
rman nocatalog
RMAN> connect target
RMAN> restore controlfile from '+Disk1/QA_DB/Control/current.xxx.yyyy';

4) Mount the database followed by brining to Open status.

5) Validate the controlfile
Select * from v$controlfile;

6) Edit the spfile and refer to the exact controlfile name

Alter system set control_files='+Disk1/QA_DB/Control/current.xxx.yyyy','+Disk2/QA_DB/Control/current.aaa.bbbbbbbb scope=spfile;


Thats it .. we are done.

We make JOY

Maryland: Another silent saturday, I was browsing through youtube.com randomly and saw many advertisements. Most of them were different, humor, some are outstanding. I love cars and checked videos of new models, new features, comparisons. I came across a three letter word 'JOY'. It is simply awesome. Its the BMW advt where the tag line is ' JOY Is BMW'.

Just wondering how creative the people in the world are. Some of the other attractive slogans are Apple's ' Think Different', Nokia's ' Connecting People', Nike's 'Just Do It', ' Think About It" - Hyundai.