How to take backup, Restore and refresh

[Former Member]

Please explain and show how to take sap backup, restore, recovery and refresh....iam very new to this area......

[former_member204746]

Hi,

the following link contains the answer to all of your requests.

http://bit.ly/vPPDFM

Good luck.

[volker_borowski2]

Hi,

backup ... do brbackup

restore ... do brrestore

refresh ... not officially supported any more

copy ... check the system copy guides

now this sound a bit short and that indeed is my intention.

There are official guides for these topics.

You should work through them ESPECIALLY as you are new in this area.

It is allways good to work with the official documentation.

The DBA-Handbook alone is about a couple of hundreds of pages which

are indeed all very usefull for anyone who is working in this area.

http://help.sap.com/saphelp_erp2005/helpdata/EN/5e/0f123b8d07db53e10000000a11402f/frameset.htm

To make sure, to do first things first, work out the brbackup chapter

and the backup concepts first. Do NOT blindly follow any advice given here,

but make sure that you are operating in a resposible and supported way

following the corresponding guidelines.

This forum is extremly good for getting advice, because quite a lot of us are working

in completely different areas, so the overall knowledge is well spread, and chances are high,

that someone already did something in an aerea, where you have not yet been active.

But you should always and ever compare any advice given here to vendor documentation.

I do not assume that someone will misguide you by bad will, but it might happen, due to

different rating of the importance of documented operating procedures, or simply because

of outdated knowledge (which I need to address to myself for some topics as well).

Backup is one of the most essential topics for you operating your own systems, so you

have to make sure you know what you are doing.

Volker

[Former Member]

...and in addition to Volker's advice.

Get or build a sandbox system and play around, never try something on a production system first!

Good luck, Michael

[former_member182505]

In Addition

read all the pre and post process

also take a backup before doing anything.

Thanks/

Sadiq

[Former Member]

Thank you very much for your nice reply.

Ya ofcourse i already red some db administration texts and pdfs but all of them

not specifically telling about how to do backups? ie i wnat to knw which is the easiest method to

take backup and recovery?

[volker_borowski2]

Well,

to request specific advice without giving some information

about your own system deserved a more general answer.

1) Find a device to backup to.

Could be a tape, could be a seperate disk (less recommended), could be a third party tool.

Snapshots of any type (SAN or journaled FS) are no backups at all.

2) Do you need to deal with several media sets for one backup?

Is the overall backup bigger than one media?

3) ...

You see how this tree can spread out, depending on your specific situation.

Did you try "Database Backup" and then "Backing Up the Database with BR*Tools" from my link above?

It describes how to take the backup menu driven. There are a couple of parameters that need to be set in the

configuration file. They depend on your actually configured device.

So, assuming a standard UNIX installation, assuming a big tape device at /dev/rmt0 and /dev/nrmt0 as the desired device,

find your initSID.sap in $ORACLE_HOME/dbs and customize the parameters:

tape_address=/dev/nrmt0
tape_address_rew=/dev/rmt0
tape_size=500G
compress=hardware
tape_pos_cmd="mt -t $ fsf $"       # might be different on AIX
rewind = "mt -f $ rewind"
rewind_offline = "mt -f $ offline"
cpio_flags=-ovB
cpio_in_flags=-iuvB  
dd_flags="obs=64k"        # if your device allows 64k blocks
dd_in_flags="ibs=64k"      

Look up all of these parameters here:

http://help.sap.com/saphelp_erp2005/helpdata/EN/0d/d308f14a0c11d182b80000e829fbfe/content.htm

and click on the red double arrow to open the navigation tree on the left.

Adjust as required by your Hardware and Unix flavor.

May be this is not all what is needed (it is quite a while since I did my last native tape

backup, as I do 3rd party tools only now), so someone else might help in addition,

if I missed some important ones.

In the brtools menu, you now select a backup type "online_cons" and a

backup device type "tape" and press thumbs

Good luck

Volker