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;
}