Joords Oracle DBA blog

Is it possible to do a RMAN backup of the Flash Recovery Area (FRA) to disk. The standard method by RMAN is that this is only possible with the use of a SBT channel/library. The RMAN command ' BACKUP RECOVERY AREA ' works only with SBT channels, meaning a tertiary storage such as tape. Oracle has introduce an emulator for SBT library to do a backup of the FRA to disk. The RMAN disksbt library, which emulates a SBT library (but it writes the backups to a disk location). This disksbt , can be used to test backup the FRA to a disk location

New Behaviour for datafile: In patch set 11.2.0.2 a new behaviour for datafile write errors has been implemented.With this release ANY write error to a datafile will cause the instance to abort. Before 11.2.0.2 those errors usually led to an offline datafile if the database operates in archivelog mode (your production database do, don’t they?!) and the datafile does not belong to the SYSTEM tablespace. Internal discussion found this behaviour not up-to-date and alligned with RAC systems and modern storages. Therefore it has been changed and a new underscore parameter got introduced. _DATAFILE_WRITE_ERRORS_CRASH_INSTANCE=TRUE This is the default setting´and the new behaviour beginning with Oracle 11.2.0.2 If you would like to revert to the pre-11.2.0.2 behaviour you’ll have to set in your init.ora/spfile this parameter to false. But keep in mind that there’s a reason why this has been changed. More info in MOSC Note: 7691270.8 New Behaviour for Automatic Mamory ...

Clusterware References; Pro Oracle Database 10g RAC on Linux Metalink Notes 259301.1 CRS and 10g RAC This note contains a useful awk script to improve the output of crs_stat -ls 436067.1 Windows CRS_STAT script to display long names correctly 309541.1 How to start/stop the 10g CRS Clusterware 263897.1 How to stop Cluster Ready Services (CRS) 298073.1 How to remove CRS auto start and restart for a RAC instance 295871.1 How to verify if CRS install is valid 316583.1 VIPCA fails complaining that interface is not public 341214.1 How to cleanup after a failed (or successful) Oracle Clusterware installation 280589.1 How to install Oracle 10g CRS on a cluster where one or more nodes are not to be configured with CRS immediately 357808.1 CRS Diagnostics 272331.1 CRS 10g Diagnostic Guide 330358.1 CRS 10g R2 Diagnostic Collection Guide 331168.1 Oracle Clusterware consolidated logging in 10gR2 342590.1 CRS logs not being written 357808.1 Diagnosability for CRS/EVM/RACG 459694.1 ...

Regarding to the scan listener is the relocation not being handled correctly by Oracle Enterprise Manager(OEM) 11gR1 (shows target as down after relocate!), Oracle has solved this by the following bugs/fixes:

Oracle Locator Express is a replacement tool for the standard Oracle Home Selector. It sits in the system tray and allows you to easily switch between multiple Oracle Homes with just one click. Oracle Locator Express is also compatible with Oracle Instant client. What's new in this version: Version 2.0.1 fixes a bug where the version of the Oracle client was displayed incorrectly for a 11gr2 client

Using UTL_DBWS to make a Database Callout to a Document Style Web service. Update of the  UTL_DBWS – Consuming Web services in Oracle   First, download the latest copy of the dbwsclient.jar file: Pre 10g: dbws-callout-utility.zip (10.1.2) 10g: dbws-callout-utility-10R2.zip (10.1.3.0) 10g & 11g latest: dbws-callout-utility-10131.zip (10.1.3.1) Extract the jar file from the zip file into the $ORACLE_HOME/sqlj/lib directory. The jar file can be loaded into the SYS schema for everyone to access, or into an individual schema that needs access to the web client.