How to configure Offline backup, R3, 4.71, Oracle 9.2.0.7, SunSolaris

[Former Member]

Hi all,

We have Daily online backup at night. We need to change the hard disks so I need to to take offline backup of all including file systems, datafiles etc (how to disable online backup and what command to use for offline backup).

Also after changing the hard disks I need to restore this offline backup (again need to configure regular online backup,)

Should I need to reconfigure all background jobs, Printers etc

No changes in SID & Host name.

Can any one help me in this regards. . . any documents I can get. . . .

Advance Thanks

Regards

[markus_doehr2]

I would consider that as a "homogeneous system copy" because it basically that is.

Check out http://service.sap.com/systemcopy

--> Media Library

--> System Copy SAP Systems Based on SAP Web AS ABAP 6.40 SR1

There you will find a step-by-step guide how to take an offline backup and restore it again to a different (or the same) system.

If you also backup your SAP binaries (/usr/sap/*) and the operating system, it´s won´t be that difficult.

Depending on what spool system you use (Solaris´ lpd or cups) backup those also. The jobs are stored in the database so no need to fiddle with them.

Also check if you have jobs running via cron and backup your crontab also.

To summarize I´d backup beside your database

/

/oracle

/usr/sap

/etc

/var

/opt

/export/home (or /home, depending on your configuration)

I may have forgotten something because I don´t know your filesystem structure so don´t nail me on that.

--

Markus

[fidel_vales]

Hi,

First, you do not indicate HOW are you doing your backup, then it would be difficult to tell you HOW to change that rutine.

I assume that you are using BRBACKUP.

If so, you have the documentation online:

http://help.sap.com/saphelp_47x200/helpdata/en/42/51b3144a1211d182b80000e829fbfe/frameset.htm<a href="http://service.sap.com/sap/support/notes/403704">SAP Database Guide: Oracle (BC-DB-ORA-DBA)</a>

and it is as easy as to change/add the following command:

-t|-type

This BRBACKUP command option defines the online or offline backup type.

Input syntax: <b>-t online|online_cons|offline|offline_force|offline_standby|offline_stop|online_split|offline_split</b>

Default value: offline

Specify the backup mode.

<b>online</b>: The backup is performed for the open database.

<b>online_cons</b>: The backup is carried out whilst the database is open. As well as the database files the offline redo log files generated during the backup are also copied to the same volume. This means that you have a logically consistent dataset available. This backup of the offline redo log files using BRBACKUP runs completely independently of other BRARCHIVE backups.

<b>offline</b>: The database is shut down for the backup when the SAP System has also been shut down. Otherwise, the database is not shut down, and BRBACKUP terminates with an appropriate error message (BR068E).

<b>offline_force</b>: The system does not check whether an SAP System user is active. The database is shut down and an offline backup is performed.

<b>offline_standby</b>: The standby database is stopped for the backup. This option is only relevant for the standby database configuration. For more information, see Standby Database.

<b>offline_stop</b>: Database backup in offline mode, followed by the migration of the saved database into mount standby status.

This type of backup is only relevant in the following case: The productive database is saved and then takes over the role of a standby database. The backup itself becomes a productive system. See Standby Database: BRBACKUP Backup of Database Files

<b>online_split</b>: The splitting and saving of the mirror disks is performed while the database is open. This option is only relevant for the split mirror configuration. See Split Mirror Online Backup.

<b>offline_split</b>: The database is stopped for the splitting of the mirror disks. The backup of the mirror disks is then done directly afterwards, whilst the database is open. This option is only relevant for the split mirror configuration. See Split Mirror Offline Backup

[Former Member]

Just in case u want the command line output for a unix system for an offline backup its

brbackup -c -p /oracle/SID/102_64/dbs/offline_init<sid>.sap.backint -u /

here -p specifies the backint profile name.

in that profile we specify that its backup type as offline

Regards

Bharathwaj V

[Former Member]

Hi,

Thanks for reply. . .

am new to backups concept. Regrding current online backup, I found one background job in sm37 with log like "

.........................................................................................

Job started

Step 001 started (program RSDBAJOB, variant &0000000000512, user ID BACKGROUND)

Execute logical command BRBACKUP On host prd47e

Parameters:-u / -c force -t online -m all -p initSID.sap -a -c force -p initSID.sap -cds

BR051I BRBACKUP 6.20 (128)

BR055I Start of database backup: bdvsrgwp.ant 2007-07-19 00.30.27

BR319I Control file copy created: /oracle/SID/sapbackup/cntrlSID.dbf 13885440

BR280I Time stamp 2007-07-19 00.30.35

BR057I Backup of database: SID

BR058I BRBACKUP action ID: bdvsrgwp

BR059I BRBACKUP function ID: ant

BR110I Backup mode: ALL

BR077I Database file for backup: /oracle/SID/sapbackup/cntrlSID.dbf

BR061I 295 files found for backup, total size 420248.258 MB

BR143I Backup type: online

BR113I Files will be compressed by hardware

BR130I Backup device type: tape

BR102I Following backup device will be used: /dev/rmt/0mn

BR103I Following backup volume will be used: SIDB01

BR289I BRARCHIVE will be started at the end of processing

BR134I Unattended mode with 'force' active - no operator confirmation allowed

BR208I Volume with name SIDB01 required in device/dev/rmt/0mn

BR280I Time stamp 2007-07-19 00.30.35

BR226I Rewinding tape volume in device /dev/rmt/0m ...

.............................................................................................

There are no details available in DB13. Is it possible to hide calender details (This was configured by previous basis guy)..

I like to know

1) How backup configured.

2) How to stop/edit if required.

3) For one day I need to take offline back including FILE Systems (Please help me which command to use)

4) After 24 hrs restore this offline backup and continue the current online backup.

Thanks

[former_member204746]

1) How backup configured.

--> read previous answers and search at help.sap.com

2) How to stop/edit if required.

--> stop backup? edit backup? please explain

3) For one day I need to take offline back including FILE Systems (Please help me which command to use)

--> for backup of FILE system, use OS backup tools (tar, cpio or others)

4) After 24 hrs restore this offline backup and continue the current online backup.

--> errr... you want to backup and restore your system every 24 hours? what is the use? is this a training system? this looks like a weird requirement to me.

[Former Member]

Eric,

Thanks for reply.

Scene here is our storage getting exhausted. Solaris guy has to repalce the HDDs with higher capacity ones. He suggested me to take offline backup including ALL FILE systems. So after his job completed I have to restore this backup and then onwards regular online backup will continue.

--> stop backup? edit backup? please explain

On that particular day instead of online backup I hv to carry offline backup.

regds

[Former Member]

Hi Anna,

What is backint profile name...

Plz explain me...

[former_member204746]

Jalli,

better option is to ask your Unix admin which disk will be replaced and backup contents from this disk. you do not need to backup everything, except if you want to be on the safe side.

If you are lucky and have a lot of free disk space, you could also copy this disk's contents to another one.

so, what filesystem is touched by the HDD replacement?

[Former Member]

Eric,

Thanks.

He told me he is replacing the file system /oracle/SID which comes about 204 GB. And i do not hv that much space in other disks. So need to take backup only on tape.

rgds

[former_member204746]

under normal systems, /oracle/SID should be less than 20GB... why? because /oracle/SID/sapdata* should each have their own filesystems.

If this is not your case,, /oracle/SID contains the database and the Oracle binaries which can be a pain...

so, in you case, I would do this:

stopsap

stop DB

backup /oracle/SID with Os backup utility such as TAR

verify your backup to make sure it is readable

as your unix admin to change HDD

restore your OS backup

cross your fingers

start DB

start SAP

Good luck.

[Former Member]

Hi Eric

thanks !!!!

How to verify backup. (Is there any tool or command for this)

So after changing HDD I need to

.. restore OS first then

.. restore SAP Backup

i mean these activities are to be carried out seperately?

Regds

[former_member204746]

if using TAR:

to backup:

tar cvf /dev/mt0 /oracle/SId

to check:

tar tvf /dev/mt0

to restore:

cd /

tar xvf /dev/nmt0

and you do not need to restore OS if only /oracle/SID is impacted.

[Former Member]

if using TAR:

to backup:

I insert tape of 400 GB (we hv 400GB tapes only) and use the command

tar cvf /dev/mt0 /oracle/SId

to check:

Insert back same tape and use command

tar tvf /dev/mt0

to restore:

cd /

tar xvf /dev/nmt0

and you do not need to restore OS if only /oracle/SID is impacted.

Yes OS will b intact. But I need to restore file system (/oracle/SID) first and then need to go for restoring data files, correct?

For taking offline backup, change of just online to offline will do or i shud change online to offline in initSID.sap also.

rgds