USING FBACKUP

[Sven Verboort]

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

[U.SivaKumar_2]

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

[Nitsulenko Sergey]

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

[Ravi_8]

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

[Jose Mosquera]

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.

[Elif Gius]

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.