fbackup

[Michael Brooks_4]

Hello all,

I'm trying to backup Oracle on a HP machine to a file. I can't seem to get the protocol of it. Can anyone assist?

Thank you very much!
Michael

[Mister_Z]

Hi Michael,

the options for fbackup are (see man pages):

-f device file
sets the device file used. Example: /dev/rmt/c4t3d0BEST.

-i path
identifies the file or directory to include in the backup.

-e path
identifies the file/directory to exclude

-g graph
graph is a file containing the list of files/directories to include (i) and exclude (e). This sample graph file:
i /data
i /index
i /oraclelog
i /oracle

would include the directories /data /index /oraclelog and /oracle.

-0-9
Backup level (used for incremental backups). By default level 0.

-u
Update the file /var/adm/fbackupfiles/dates that registers the graph files used.

-I path
Create an index in the path specified

===

Example:
1) backup with graph file:

#fbackup -f /dev/rmt/c4t3d0BEST -g graphAEAa28266

[Mister_Z]

Michael,

in the -f option you can define a standard file where the backup is stored:

#fbackup -f /DUMPS/jj/bup -i /DUMPS/jj/p4
fbackup(1004): session begins on Tue Dec 9 18:02:08 2003
fbackup(3024): writing volume 1 to the output file /DUMPS/jj/bup
fbackup(3055): total file blocks read for backup: 13130
fbackup(3056): total blocks written to output file /DUMPS/jj/bup: 15256

after that, you can use frecover to restore the backup:

#frecover -f /DUMPS/jj/bup -xXv

[Kurt Beyers.]

Michael,

Do you mean an online backup with RMAN to a file on disk?

The RMAN script would be something like:

run {
allocate channel dev1 type disk;
backup
incremental level 0
format '/u01/backup/rman/datafile_%U'
database;

backup
format '/u01/backup/rman/controlfile_%U'
current controlfile;

sql 'alter system archive log current';

backup
archivelog all
format '/u01/backup/rman/archlog_%U'
delete input;


release channel dev1;
}

Kurt

[rmueller58]

I would export the database and backup the exported filesystem..

fbackup -f /dev/rmt/0m -d /exportfs