Ad-hoc tips (fbackup/frecover commands in HP-UX)

Posted on July 22, 2008. Filed under: DBA/Admin Tips |

We use HP-UX for running one of our 11i instances and i manage the backups using fbackup and frecover commands. I am sharing the syntax for some of the basic commands. Hope it would help.

======== Fbackup =========

(1)
Create a defaults file (eg, defaults.prod) and include/exclude file systems to be backed up/excluded.

$ cat defaults.prod
i /u02/oracle
e /u02/oracle/proddb/8.1.6
i /u07/oracle/proddata

This will backup all of /u02/oracle but would skip proddb/8.1.6

(2)
Create a configuration file (eg, config.prod) and define configuration parameters for the backup

$cat config.prod

blocksperrecord 256
records 32
checkpointfreq 1024
readerprocesses 6
maxretries 5
retrylimit 5000000
filesperfsm 2000

(3) Use following simple fbackup command

fbackup -f <device name, eg /dev/rmt/c5t2d0BESTb>  -uv0g defaults.prod -c config.prod
===========Frecover ===========

frecover -r -v -f <device name>  ====> For a full restore

frecover -x -e <directories/filenames to exclude> -f <device name> ===> For excluding certain files during extract !!

frecover -x -i /u01/oracle/prodappl/fnd/11.5.0/log/l4043065.req -f /dev/rmt/c5t4d0BESTb  ==> To extract one file !!

Thanks,

OPS team

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

One Response to “Ad-hoc tips (fbackup/frecover commands in HP-UX)”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

your defaults.prod and config.prod is acting as a script file right? and also what is the -c function for your fbackup?

jasonntp.wordpress.com


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: