Search This Blog

Saturday, March 28, 2009

Create cluster on OC4J 10.3

Step 1: Ensure that servers are ping each other
Step 2: Check the opmn ports ( $ORACLE_HOME/opmn/conf/opmn.xml)

Step 3:
#Server 1
opmnctl config topology update discover="server2.domain.cy:6200"
opmnctl reload
#Server 2
opmnctl config topology update discover="server1.domain.cy:6200"
opmnctl reload


Check the status of the cluster
===============================
opmnctl @cluster status


delete a note

==============

opmnctl config topology delete discover
opmnctl reload

Oracle secure backup

go to obtool web , configure , host , choose host and to be client,administrator,mediaServer

Create Virtual library
============================
obtool --user admin --password oracle mkdev -t library -o -S 4 -a ACER_ONE:/vlib -v vlib
Create Virtual Tape
obtool --user admin --password oracle mkdev -t tape -o -a ACER_ONE:/vt -v -l vlib -d 1 vt

C:\>obtool
ob> lsdev
library vlib in service
drive 1 vt in service
ob> lsmf --long
OSB-CATALOG-MF:
Write window: 7 days
Keep volume set: 14 days
Appendable: yes
Volume ID used: unique to this media family
Comment: OSB catalog backup media family
RMAN-DEFAULT:
Keep volume set: content manages reuse
Appendable: yes
Volume ID used: unique to this media family
Comment: Default RMAN backup media family
ob>

ob> lsdev
library vlib in service
drive 1 vt in service


Create database selector
=========================

mkssel --dbid 1190329173 --host ACER_ONE --content full --family RMAN-DEFAULT ssel1

ob> lsssel
Name Database Database Host name Content Copy Media Device Resource
name id # family restriction wait time
____________________________________________________________________________________________________
ssel1 all 1190329173 ACER_ONE full * RMAN-DEFA- none 1 hour
ULT

Backup with RMAN

RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
SEND 'OB_DEVICE vt';
BACKUP DATABASE;
}

Recreate dbconsole on RAC Database 10.2

export ORACLE_SID=orclinst1

-- drop repository if exist

emca -deconfig dbcontrol db -repos drop

---reconfigure again

emca -config dbcontrol db -repos create -cluster

References :
How to manage DB Control 10.2 for RAC Database with emca Doc ID: 395162.1How To Drop, Create And Recreate DB Control In A 10g Database Doc ID: 278100.1