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

Get Schemas size in Oracle

select owner, sum(bytes)/1024/1024 tsize
from dba_segments
group by owner
order by tsize desc;

netsh Command

# Add IP
netsh int ipv4 add address name="Local Area Connection 1" addr=10.114.1.35
 mask=255.255.255.240 skipassource=true

# List ip addresses
netsh int ipv4 show ipaddresses level=verbose

# Delete IP
netsh int ipv4 delete address "Local Area Connection 1" 10.114.1.35

rebuild em oracle

(MEIS) /export/home/oracle $ emca -config dbcontrol db -repos recreate

STARTED EMCA at Aug 6, 2013 11:22:20 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: MEIS
Listener port number: 1521
Listener ORACLE_HOME [ /data/oracle/product/11.2.0.2/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /data/oracle/product/11.2.0.2/dbhome_1

Local hostname ................ rman1
Listener ORACLE_HOME ................ /data/oracle/product/11.2.0.2/dbhome_1
Listener port number ................ 1521
Database SID ................ MEIS
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 6, 2013 11:22:50 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /data/oracle/cfgtoollogs/emca/MEIS/emca_
Aug 6, 2013 11:22:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 6, 2013 11:24:49 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 6, 2013 11:24:50 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 6, 2013 11:30:10 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 6, 2013 11:30:16 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos                                                                                                                                                             itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 6, 2013 11:31:16 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 6, 2013 11:31:20 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 6, 2013 11:31:29 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 6, 2013 11:31:29 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 6, 2013 11:31:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 6, 2013 11:31:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rman1:5500/em <<<<<<<<<<<
Aug 6, 2013 11:31:59 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /data/oracle/product/11.2.0.2/dbhome_1/rman1_MEIS/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 6, 2013 11:31:59 AM
(MEIS) /export/home/oracle $


emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

or

emca -deconfig dbcontrol db
emca -config dbcontrol db -repos recreate

Nesting FOR Command in Batch

FOR %A IN (1 2) DO FOR %A IN (A B) DO ECHO %A