ADSM-L

Re: Method to Backup of Oracle ?

1998-01-31 06:15:17
Subject: Re: Method to Backup of Oracle ?
From: "Boireau, Eric (MED-Cap Gemini)" <BOIREER AT EUROMSX.GEMSE DOT FR>
Date: Sat, 31 Jan 1998 12:15:17 +0100
Thanks a lot Michael, I will try this monday
Eric


> ----------
> From:         Michael Schweiss[SMTP:Michael_Schweiss AT MRO.MAN DOT DE]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         vendredi 30 janvier 1998 16:25
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Method to Backup of Oracle ?
> 
> 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
> 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
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> 
<Prev in Thread] Current Thread [Next in Thread>