taking file backup

[mehul_3]

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

[Geoff Wild · Accepted solution]

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

[Jose Mosquera]

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.

[Michael D. Zorn]

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).