Hello Bert, Friday, March 4, 2005, 4:13:13 PM, you wrote:
Bpb> Of course I'm interested in your results; Bpb> if I have the time, I will help you with problems that might arise. Bpb> Good luck, Jack$on. Bpb> Kind regards, Bpb> Bert De Ridder Bpb> PeopleWare NV - Head Office Bpb> Cdt.Weynsstraat 85 Bpb> B-2660 Hoboken Bpb> Tel: +32 3 448.33.38 Bpb> Fax: +32 3 448.32.66 Bpb> PeopleWare NV - Branch Office Geel Bpb> Kleinhoefstraat 5 Bpb> B-2440 Geel Bpb> Tel: +32 14 57.00.90 Bpb> Fax: +32 14 58.13.25 Bpb> http://www.peopleware.be Bpb> http://www.mobileware.be Bpb> Jack$on <[EMAIL PROTECTED]>04/03/2005 14:58 Bpb> Please respond to Bpb> Jack$on <[EMAIL PROTECTED]> Bpb> To Bpb> [EMAIL PROTECTED] Bpb> Subject Bpb> Re[4]: backup Oracle DB at Bpb> AMANDA server Bpb> Hello Bert, Bpb> Friday, March 4, 2005, 3:44:54 PM, you wrote: Bpb>> You have to configure amanda like this Bpb>> on the server where the oracle database is located. Bpb>> I guess you could call it a client, Bpb>> since the real scheduling is done on the 'index server' Bpb>> And the indexing server sends the tar Bpb>> command to the other servers. Bpb>> Adapt the script to your local needs, Bpb>> if you need some special processing, that goes in the parts where Bpb> the if's Bpb>> are : Bpb>> if ( $file ne '/dev/null' ) Bpb>> { Bpb>> if ( $dir eq '/your/oracle/dir' Bpb>> ) Bpb>> { Bpb>> system "echo 'Start backup oracle at ' >>>> /var/lib/amanda/runtime" ; system "date >>>> Bpb>> /var/lib/amanda/runtime"; Bpb>> system ( "command to stop oracle >>>> /var/lib/amanda/runtime" ); Bpb>> } Bpb>> } Bpb>> If you want to back up another directory, Bpb>> just add them to your disklist on the index server, this script Bpb> will perform Bpb>> no special operation on the server to be backed up for the other Bpb> directories. Bpb>> It will just perform the tar like it is supposed to. Bpb>> Dumptypes are no compile time options, Bpb>> that are options that are put in your amanda.conf file. Bpb>> Something like this : Bpb>> define dumptype client-compress { Bpb>> global Bpb>> program "GNUTAR" Bpb>> compress client best Bpb>> priority high Bpb>> index yes Bpb>> } Bpb>> In your disklist there will be an entry Bpb>> like this : Bpb>> oracleserver /your/oracle/dir Bpb>> client-compress Bpb>> The --with-gnutar=/bin/amandatar is Bpb>> when you build amanda (which you should do; you cannot use an rpm Bpb> that Bpb>> you downloaded somewhere to use this functionalilty). Bpb>> So : download the sources, untar them Bpb>> ( tar -xvzf amanda_version.tgz ) Bpb>> cd to the dir where the source is extracted Bpb>> configure the source tree, use your Bpb>> own system policy concerning /usr/local etc : Bpb>> ./configure \ Bpb>> --with-user=amanda \ Bpb>> --prefix=/usr/local \ Bpb>> --exec-prefix=/usr \ Bpb>> --bindir=/usr/bin \ Bpb>> --sbindir=/usr/sbin \ Bpb>> --libexecdir=/usr/lib/amanda Bpb>> \ Bpb>> --with-configdir=/etc/amanda Bpb>> \ Bpb>> --with-group=disk \ Bpb>> --with-gnutar=/bin/amandatar Bpb>> \ Bpb>> --with-gnutar-listdir=/var/lib/amanda/gnutar-lists Bpb>> \ Bpb>> --with-tmpdir=/tmp/amanda \ Bpb>> --with-smbclient=/usr/bin/smbclient Bpb>> \ Bpb>> --mandir=/usr/local/man Bpb>> build the sources : Bpb>> make Bpb>> install the resulting binaries : Bpb>> make install Bpb>> Now you can use your home-built Amanda Bpb>> :-) Bpb> wow... Bpb> from 2 mail's I known more, then from many MAN's pages, FAQ Bpb> different articles :). Bpb> thanx a lot! I'm really miss checking the directory name in your Bpb> script. Bpb> thank for the explanation at describing of dumptapes. Now I'm really Bpb> understand how it work :). I think... :) Bpb> Now, i try setup, configure test it. Later i'm send my results, if Bpb> someone interested on it... bad news :(( my Oracle developers & users don't allow me stop Oracle DB :(. now, I make hot backup of Oracle DataBase, then backup files write to the local tape. It seems, thet i can't stop DB, & use your nicely solution :(. Another bad news -- this hot backup finished very closed to start of work day -- i can't run amdump at estimated time, because i have at least 3 servers, with big size data for backup... I think that i'm don't have time to finish backup, before our workers start the job... Finally, new question: can I create different amanda configuration (example -- daily & dailyora). At first I backup all my servers, exclude Oracle DB, fn second -- only Oracle DB. admump daily -- I'm run at the night, amdump dailyora -- at the morning, with rsh from Oracle DB server, after hot backup finished... and the major -- both backups must white to the same tape. (I have tape changer HP 1/8 autoloader, Ultrium LTO2 Tape). If I descibe same amanda.conf, with same labelstr, same tapelist and different disklist, does the amanda white data from both amdump to the same tape at one day? I hope, that I can explain enough my problem... -- Best regards, Jack$on mailto:[EMAIL PROTECTED]
