topic Re: SAP Oracle Onlibe Backup Restore in Operating System - HP-UX

SAP Oracle Onlibe Backup Restore

Kenn Chen_1 — Thu, 21 Oct 2004 04:19:02 GMT

I would like to restore my online backup from LTO1 tape into new server. My backup software is DP5.1 and i have backup the data successfully without error. Now i need to restore all the online data into new box. I have finished all the fs and mounted. I have follow below steps to restore.
1) Goto omniback and choose the files to be restored. (Before that, should I install oracle library or binary files ? I used brbackup to backup the data).
2) Restore all the datafiles ...
3) The restore is ok for small files. It was failed when restoring the big files like oracle datafile (2GB file).

ANy idea ?

Re: SAP Oracle Onlibe Backup Restore

Marcel Boogert_1 — Thu, 21 Oct 2004 04:37:20 GMT

Hi there,

How did you create your filesystems? Did you use the -o largefiles option? If not files greater then 2GB will not restore.

MB.

Re: SAP Oracle Onlibe Backup Restore

Marcel Boogert_1 — Thu, 21 Oct 2004 04:40:18 GMT

Hi there,

For Oracle you can restore the complete application to another server. Just remember to edit alle the config files, like listener.ora, tnsnames.ora, oratab, etc...

You can also online change the largefiles option on your filesystems if you have OnlineJFS.

Regards, MB.

Re: SAP Oracle Onlibe Backup Restore

Simon Hargrave — Thu, 21 Oct 2004 04:51:36 GMT

For each filesystem that needs > 2Gb files: -

unmount thefilesystem
fsadm -Fvxfs -olargefiles /dev/vg01/rdevice (where rdevice is replaced with the actual device name)
remount the filesystem

Re: SAP Oracle Onlibe Backup Restore

Kenn Chen_1 — Thu, 21 Oct 2004 18:44:03 GMT

HI all,

My problem is not due to filesystem limit for 2 GB file. My problem is restore failed when restoring big files. For normal way, restoring datafiles and arch log from DP5.1 should be able to startup oracle, am i right ? or i need to restore oracle binary or library files before restoring datafiles. or using sapdba - brrestore ??

Re: SAP Oracle Onlibe Backup Restore

Indira Aramandla — Thu, 21 Oct 2004 20:13:19 GMT

Hi Kenn,

When you say that you want to restore the On-line backup data files from LTO1 tape to a new server......

1. Do you have the Oracle RDBMS software installed on the new server. This should be of the same release version as that of the backup database.

2.1 If you have the software installed then restore the datafiles, redo logs and the arch logs to the new server. Make sure the file system path names are same.

2.2 If you do not have the Oracle software, then install the software first and then restore the data files and logs.

3. startup mount and then recover to the time you have the archive logs for.

4. If you have a off-line backup (cold backup), then you can restore the datafiles, redo logs and control files and startup the database.

Finally remember to configure the tnsnames.ora, listener.ora and oratab files appropriately with the correct hostname.

Indira A

Re: SAP Oracle Onlibe Backup Restore

Volker Borowski — Fri, 22 Oct 2004 02:32:34 GMT

Hi,

depending on the SAP Release there are diffrent ways for supported ways to copy a SAP system by backup/restore. Checkout the "Systemcopy -guides" for your Platform in http://service.sap.com/instguides.

Doing it the non-supported way on own risk:
- Setup OS-users
- Setup Filesystems
- Install Oracle SW (less good, but works: copy binaries)
- copy filesystems /usr/sap/SID , /sapmnt/SID

- Install DP-client on new box. Ensure proper client setup, you do not want the restore to be restored on source system.

- copy correspondig backup-protocol-file abcdefg.anf (check timestamp) from /oracle/SID/sapbackup to new box
- on new box do
brrestore -m full -b abcdefg.anf -q
---> fix errors and warnings
brrestore -m full -b abcdefg.anf
-> restore will run

Check file abcdefg.anf for sections
"ARCHIVE LOG LIST" before and after backup. This schould reveal which redologs you need to recover the online backup.

Transfer /oracle/SID/saparch/archSID.log to destination box.

brrestore -a - -q
---> fix errors and warnings
brrestore -a -
-> will restore the redologs you need

If you did change the SID, create new controlfile.
Mount the database.
Do from sqlplus
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

Give all the logs.
ALTER DATABASE OPEN RESETLOGS;

Do post-copy-Activities from SAP-Systemcopy-guides.
Watch the system not to comunicate with wrong partners, so i.e there may be need to modify table RFCDES before you start up the sap system (i.e. if this is a copy from production, which pushes data to an external system, you need to ensure that data is not fed from both systems now!).

There may be need for additional postactivities depending on which modules are active in your SAP-system.

Good luck
Volker