topic Re: taking file backup in Operating System - HP-UX

taking file backup

mehul_3 — Thu, 09 Dec 2004 07:43:19 GMT

Hi,
I want to take a single individual file and other database file under subdirectory from
the following path /oracle/product/oradata/9.2.0.1.0/dbs/orapwgdbs.ora and /u01/gdbs, /u02/gdbs, /u03/gdbs

Is the following fbackup command is correct?
$fbackup -v -f /dev/rmt/0m -i /u01/gdbs -i /u02/gdbs -i /u03/gdbs -i /oracle/product/oradata/9.2.0.1.0/dbs/orapwgdbs.ora

Re: taking file backup

Geoff Wild — Thu, 09 Dec 2004 08:35:54 GMT

Looks good to me.

You could also create a graph file:

i oracle/product/oradata/9.2.0.1.0/dbs/orapwgdbs.ora
i /u01/gdbs
i /u02/gdbs
i /u03/gdbs

Then:

fbackup -v -f /dev/rmt/0m -g /mygraph

Rgds...Geoff

Re: taking file backup

Jose Mosquera — Thu, 09 Dec 2004 08:36:56 GMT

Hi,

Looks fine, but remember stop de databases before make a backup of files that belong them to ensure integrity and consistence. You can check the final status of this backup entering the following command immediately after the finalization of the backup:
# echo $?

Always, in database file case, the status must be 0. To know all available fbackup status pls "man fbackup"

Afther, you can check the tape content entering the command:
# frecover -I /tmp/index.txt -f /dev/rmt/0m

Then cat or edit /tmp/index.txt file to check the tape content.

Rgds.

Re: taking file backup

Michael D. Zorn — Fri, 10 Dec 2004 13:15:40 GMT

Using the graph file is a good idea - you can change it if you need to add more files.

I like to use "-V header -I index" options (could go before the -f), with datestamps in the "header" and "index" filenames - that way, you can search those files for what's on the tape. (Like -V OraHdr20041210).