Re: Method to Backup of Oracle ?
1998-01-30 10:25:41
That's correct
Here is a example of dsm.sys:
.
.
.
SErvername server_a
TCPPort 1500
TCPServeraddress adsm_server1
Users root
SCHEDMODe PRompted
SCHEDLOGname /usr/system/adsm_log/schedule.log
INCLEXCL /usr/lpp/adsm/bin/dsm_excl
TCPCLIENTADDRESS 172.16.10.24
TCPCLIENTPort 1501
COMPression ON
.SErvername srv_dbfb
COMMmethod TCPip
TCPPort 1500
TCPServeraddress adsm_server1
Users root
TCPCLIENTADDRESS 172.16.10.24
TCPCLIENTPort 1503
COMPression ON
INCLEXCL /usr/lpp/adsm/bin/dsm.excl_dbf
[end dsm.sys]
The schedule process is an dsmc sched -server=server_a ....
The process to backup our Oracle files is dsmc sel xxx.dbf
-server=server_dbfb ....
The exclude file for incremental backup dsm_excl excludes all *.dbf files
The exclude file for incremental backup dsm_excl excludes all *.dbf files
because they are useless if database was not shutdown.
exclude /.../core
exclude /.../*.dbf
The exclude file for database backup looks like:
exclude /.../*
include /.../*.dbf oracledb
Hope this helps
Michael
Boireau, Eric (MED-Cap Gemini) schrieb:
> Thanks Michael,
> I would appreciate your sample. If I understood correctly, I define
> several server on the client side with the same IP address. So I can
> used different include/exclude definition.
> Correct ?
>
> Regards.
> Eric
>
> > ----------
> > From: Michael Schweiss[SMTP:Michael_Schweiss AT MRO.MAN DOT DE]
> > Reply To: ADSM: Dist Stor Manager
> > Sent: vendredi 30 janvier 1998 14:28
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Method to Backup of Oracle ?
> >
> > Eric,
> > you can use different servers, which you define in dsm.sys. Each
> > server has
> > its own include/exclude file. So you can forget your link. If you need
> > examples just e-mail again.
> >
> > If you want to be sure that your database is down when starting your
> > backup,
> > cron is the safest way i know. The scheduler starts your backup not
> > always
> > the same time..
> >
> > Regards
> > Michael Schweiss
> >
> >
> >
> > Boireau, Eric (MED-Cap Gemini) schrieb:
> >
> > > Hello,
> > > I want to do a "cold" backup of our Oracle DataBase (Weekly Backup).
> > But
> > > I want also to backup all other filesystem daily with incremental
> > > backup. We don't want to buy ADSM Connect Agent for Oracle.
> > > To do this I exclude in opt file /dbase*/.../*. But when I want to
> > > backup /dbase* I need to used a symbolic link on root directory (
> > > /bkpadsmoracle -> / ) to bypass the include/exclude definition, and
> > I
> > > have to schedule backup with cron ( Script wich Stop DB, launch
> > Backup;
> > > then Start DB). Is there an other way to do this with the ADSM
> > Scheduler
> > > ?
> > >
> > > Note :
> > > Oracle Server : SUN E3000 Solaris 2.5.1 ADSM 2
> > > ADSM Server : AIX V2.1x Future (NT V3.1).
> > >
> > > Thanks
> > >
> > > > g GE Medical Systems
> > > > __________________________________
> > > > Eric Boireau GITS
> > > > Unix / NT System Engineer
> > > >
> > > > GE Medical Systems S.A
> > > > 283, rue de la Minière
> > > > 78533 BUC Cedex France
> > > > Tél: (33) 01 30 70 39 51, DC: 8*644 3951
> > > > Fax: (33) 01 30 70 39 20, DC: 8*644 3920
> > > > mailto:boireer AT euromsx.gemse DOT fr
> > > >
> > > > Salutations / Best Regards
> > > >
> > > >
> > > >
> > > >
> >
|
|
|