Crontab delete Archivelog

#!/bin/bash

for i in DB1 DB2 ;
do
. oraenv << EOI
$i
EOI
rman target /   << EOI
sql "alter system switch logfile";
delete noprompt archivelog until time 'SYSDATE-7';
EOI
done;

Rebuid em on windows 2008 r2

open CMD as Administrator

set ORACLE_HOSTNAME=hostname
edit c:/windows/system32/driver/etc/host
ipaddress hosname

set ORACLE_UNQNAME=sid

emca -config dbcontrol db -repos recreate

Oracle Database Patchset 11.2.0.4

https://updates.oracle.com/ARULink/PatchSearch/process_form?bug=13390677

• 13390677 – 11.2.0.4 direct download link on MOS
• 742060.1 Release Schedule of Current Database Releases
• 880782.1 ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts
• 1562142.1 11.2.0.4 Patch Set – List of Bug Fixes by Problem Type
  • currently under construction!!!
  • 5479(!!!) BUGs are listed as fixed for now – will it be the MOST STABLE ?
• 1562139.1 11.2.0.4 Patch Set – Availability and Known Issues
  • document is under construction!!!
• 756671.1 Oracle Recommended Patches — Oracle Database
• 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
• 1320966.1 Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
• 1061295.1 Patch Set Updates – One-off Patch Conflict Resolution
• 837570.1 Complete Checklist for Manual Upgrades to 11gR2
• 785351.1 Oracle 11gR2 Upgrade Companion
• 1152016.1 Master Note For Oracle Database Upgrades and Migrations
• Oracle Database 11g Release 2 (11.2.0.3) New Features