fbackup question

[Mark Lawley]

I may be looking in the wrong places but I
haven't been able to find the answer to this
question.

Is it possible to backup raw data for one of our databases using fbackup?

[Sanjay_6 · Accepted solution]

Hi Mark,

I think you cannot backup raw data using fbackup. You can use "dd" to backup raw data from the system.

Hope this helps.

regds

[Rodney Hills]

As long as it exists as a file on a standard hpux file system, fbackup can save it.

If it is a database file, it can't be open at the time of backup. IE no transactions can be running against it.

-- Rod Hills

[S.K. Chan]

If it exists as a file, yes you can. Otherwise you can't use fbackup for raw data.

[Tom Jackson]

Mark:

You must either use the database's backup utility to do a "hot backup", or you can shutdown the database then do a regular backup on the database files. If you backup your database while it's running, there is a chance that one (or more) database files can change while another database file is being backed up. This inconsistency could make the database unusable when restored.

hth - Tom

[Sanjay_6]

Hi Mark,

Take a look at the "dd" help from man pages,

http://docs.hp.com/cgi-bin/fsearch/framedisplay?top=/hpux/onlinedocs/B2355-90680/B2355-90680_top.html&con=/hpux/onlinedocs/B2355-90680/00/00/67-con.html&toc=/hpux/onlinedocs/B2355-90680/00/00/67-toc.html&searchterms=dd&queryid=20020227-080753

Hope this helps.

regds