Date: 6st August 2010 HOTFIX: DBED SUPPORT FOR ORACLE 11g R2 OS: SunOS OS Version: 5.10 Etrack Incidents:2070798 Errors/Problems Fixed: Added support for Oracle 11g R2 (2070798) OVERVIEW ---------------- This hotfix adds support for Oracle 11g R2 for Veritas Storage Foundation for Oracle 5.0MP3RP4 on SunOS. INSTALLING THE HOTFIX ------------------------------------ 1. Stop/ Kill any dbed scripts that are running/ in use. 2. Download and copy the hotfix files to a temporary location, for example /tmp. 3. Install the hotfix patch: patchadd /tmp/patches/145439-01 patchadd /tmp/patches/145440-01 patchadd /tmp/patches/145441-01 4. Run sfua_db_config. 5. Restart vxdbd if required: /opt/VRTS/bin/vxdbdctrl start UNINSTALLING THE HOTFIX ----------------------------------- 1. Stop/ Kill any dbed scripts that are running/ in use. 2. Uninstall the hotfix patch: patchrm 145439-01 patchrm 145440-01 patchrm 145441-01 3. Run sfua_db_config again. 4. Restart vxdbd if required: /opt/VRTS/bin/vxdbdctrl start ADDITIONAL NOTES ---------------- No reboot is required after installation or un-installation of these patches. Install these patches only on top of version 5.0 MP3 RP4. KNOWN ISSUES ---------------------- Incident: 2090213 Abstract : The dbed_clonedb command for the offline checkpoint fails with message ORA-00600 with Oracle 11gR2 when ODM is enabled Description: If ODM is enabled, the dbed_clonedb command fails when performing offline checkpoint database cloning on Oracle 11gR2. Sample command output: ------------------------------------ bash-3.00$ dbed_clonedb -S OFFCLN -c Checkpoint_1279170618 -m /tmp/mnt1 Primary Oracle SID is FLAS11r2 New Oracle SID is OFFCLN Cloning an offline Storage Checkpoint Checkpoint_1279170618. Mounting Checkpoint_1279170618 at /tmp/mnt1. All redo-log files found. Creating initOFFCLN.ora from /tmp/vxdba.rel.tmp.8389/initFLAS11r2.ora. Altering db_name parameter in initOFFCLN.ora. Editing remote_login_passwordfile in initOFFCLN.ora. Altering control file locations in initOFFCLN.ora. Copying initOFFCLN.ora to /oracle/11gr2/dbs/initOFFCLN.ora. About to start up new database and begin reconfiguration. Database OFFCLN is being reconfigured. Did not see error regarding database name. Shutting down clone database. Altering clone database archive log directory. Updating log_archive_dest in clone database init file. Found archive log destination at /snap_arch11r2/FLAS11r2. Mounting clone database. Resetting logs on new database OFFCLN. SFORA dbed_clonedb ERROR V-81-4920 Database OFFCLN is still in recovery mode. SFORA dbed_clonedb ERROR V-81-4881 Log file is at /tmp/oralog.out.8389. bash-3.00$ cat /tmp/oralog.out.8389 ALTER DATABASE OPEN RESETLOGS * ERROR at line 1: ORA-00600: internal error code, arguments: [ksfdgmsn4], [ODM ERROR V-41-4-2-207- 1 Not owner], [], [], [], [], [], [], [], [], [], [] ORA-00318: log 1 of thread 1, expected file size 512 doesn't match 512 ORA-00312: online log 1 thread 1: '/tmp/mnt1/snap_data11r2/FLAS11r2/redo01.log' ------------------------------------ Workaround: Perform the offline checkpoint cloning for 11gR2 on another ORACLE_HOME where ODM is disabled.