topic Re: USING FBACKUP in Operating System - HP-UX

USING FBACKUP

Sven Verboort — Fri, 21 Feb 2003 11:07:24 GMT

Hello,

We have a HP9000 Server running HP-UX 11 with one oracle 8i enterprise database on it.

We use Fbackup. We schedule a full backup(NFS included) every day.

If I check the log, I get a couple of warnings.

FBACKUP(1102)Warning:Unable to stat file /var/spool/sockets/pwgr/client17922 and /var/stm/logs/sys/activity_log was not succesfully backed up.

Is there also a script available that brings down the database, then begins the backup and finally brings the database back online?

Is there someone out there with a solution?

regards,
Sven Verboort

Re: USING FBACKUP

U.SivaKumar_2 — Fri, 21 Feb 2003 11:14:55 GMT

Hi,

The files /var/spool/sockets/pwgr/client17922 and /var/stm/logs/sys/activity_log are open file viz . they are busy files used by pwgrd daemon and stm daemons.

So if you want to get rid of that error , you have to go single user mode and take backup.

regards,
U.SivaKumar

Re: USING FBACKUP

Nitsulenko Sergey — Fri, 21 Feb 2003 11:39:14 GMT

Hello.
I for a long time wrote a script for 2 DB 7.3.4 (APPL and bdifs in a script), but I use it and for 8i. Backup goes on a tape, but you can edit under your needs. Look -probably help You. It is started for each of DB accordingly:
su - ora734 -c "/mmz/usr/bin/copyDB.sh" 1>/mmz/tmp/copyIFS.lst 2>&1 ||{ echo "`date '+%c'` ERROR copy IFS!"; exit; } 1>>/mmz/tmp/copyIFS.lst 2>&1

su - oracle -c "/mmz/usr/bin/copyDB.sh" 1>/mmz/tmp/copyAPPL.lst 2>&1 ||{ echo "`date '+%c'` ERROR copy APPL!"; exit; } 1>>/mmz/tmp/copyAPPL.lst 2>&1

Re: USING FBACKUP

Ravi_8 — Fri, 21 Feb 2003 11:41:25 GMT

Hi

fbackup is designed to take backup while system is active.

to bring the database down and perform backup, you can use a script like:

dbshut normal
fbackup .....
dbstart

Re: USING FBACKUP

Jose Mosquera — Fri, 21 Feb 2003 12:47:02 GMT

Hi,

Why do you not exclude boot of them from fbackup command?

Several dirs keeps files for temporaly uses, then when backup start the first thing to do is a index file to make the backup follow this index, so if any file included in this index was deleted meanwhile this index file point is reached a warning message is displayed. Similar case is exposed in http://www4.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000062972954 (a very interesting doc)

To exlude these kind of dirs use "-e" fbackup option, i.e:

fbackup -0 -v -n -i / -e /var/spool/sockets/pwgr -e /var/stm/logs -f /dev/rmt/

Rgds.

Re: USING FBACKUP

Elif Gius — Fri, 21 Feb 2003 15:03:11 GMT

Hi Sven,

In this case you should not worry. These are files which are open during the backup. In this case the fbackup gets an error. If you want to ignore them pls change your graph file for fbackup.
If you want to backup your DB with fbackuo, simple write a shell script which stops your DB (..like shutdown immediate...) then start your backup. After successful backup start your DB again. Your DB administrator should help you.