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
Search This Blog
Saturday, March 28, 2009
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;
}
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
-- 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
Subscribe to:
Posts (Atom)