NTBACKUP with running SAP system and Oracle

[Former Member]

Hi!

Due to test I would like to backup all the data from my Windows 2003 Server (DB: oracle, appr. 170 GB, SAPEXE, Redo logs).

Can I run a NTBACKUP job over the night by running SAP System and running Oracle DB or do I have some problems by backup of data files, control files, etc.?

Any helpful information will be very appreciated!

[markus_doehr2]

> The only problem is the time: for DB with appr. 160 GB the NTBACKUP needs 13 hours.

Do what device do you back up? to a disk? a tape device?

> Are the some other tools that are faster and with with I can copy data files from Oracle with permitions,

> e.g. xcopy?

> What is the desired commando for xcopy to copy data files from oracle?

Well - there is a number of tools delivered with Oracle - called "brtools". They are the usual way of configuring and executing backups.

Markus

[Former Member]

Many thanks for your reply!

I would like to back up to disk.

The following data I would like to backup:

- the data files of Oracle database

- SAPEXE

- Redo logs

The question still is the performance and the question NTBACKUP vs. xcopy.

E.g. I could backup all the data via the following commando on a backup server

xcopy E:
backupserver\oracle /E/I/H/K/O/X

Or should I rely on NTBACKUP approach that takes appr. 12 hours?

Any helpful information will be very appreciated!

[former_member204746]

both solutions will work.

it's up to you to decide which one is best... as long as Oracle is stopped before attempting this.

[markus_doehr2]

If your backup is running onto the same disk as the data files reside (same physical disk) then a copy process won't be faster. It also depends on the speed of the drive (if it's external).

What hardware do you have?

Markus

[Former Member]

Hi,

May be the following backup process reduce your overall backup time...

Just try this...

With NTBackup backup the application data:

1. <drive>:\usr

2. <drive>:\oracle\<SID>\102

3. Windows System State Data

With BRTOOLS (DB13 t-code):

1. Whole Offline + Redo logs backup

This way you will have complete backup and may be time will be reduced as compare to Full NTBACKUP.

Regards.

Rajesh Narkhede

[Former Member]

Hi ,

For NTbackup ,

You should stop DB , SAPOScol and then SAP . now try to take NTbackup .

you should not get any error .

Regards

[volker_borowski2]

Yes, you will have problems with this.

When the database is running you wil not be able to backup with NTBACKUP

and when doing with another tool, that is able to backup open files, the backup

will not be consistent, as oracle needs to know when files are backed up.

1. You need an ntbackup-ASR Backup to be able to do desaster recovery

This will only backup the partitioninformation and the systemdrive (ususally C:)

2. You can backup everything else but datafiles and online logfiles and controlfiles

You can do this online, worst case, you'll loose some temp/log files or you need to restore

some sap-kernel files from a recent SAP SW archive.

3. You need to do a database backup in addition, if you like to do it online.

Option two is to shut down everything first.

Volker

[markus_doehr2]

> Can I run a NTBACKUP job over the night by running SAP System and running Oracle DB or do I have some problems by backup of data files, control files, etc.?

You will have to shut down the database in order to use NTBACKUP to backup your database.

Any reason why you don't use the br*tools?

Markus

[Former Member]

I tried to use NTBACKUP by running SAP system with oracle. This went without any errors.

The only problem is the time: for DB with appr. 160 GB the NTBACKUP needs 13 hours.

Are the some other tools that are faster and with with I can copy data files from Oracle with permitions,

e.g. xcopy?

What is the desired commando for xcopy to copy data files from oracle?

Has some one experience here?