BRBACKUP directory

[than_martens]

Hi,

I'm doing backups to disk and I've changed my init<sid>.sap so that database and archive backups go to different locations.

Before:

backup_root_dir = F:\oracle\<sid>\sapbackup

archive_copy_dir = F:\oracle\<sid>\sapbackup

After:

backup_root_dir = F:\oracle\<sid>\sapbackupdb

archive_copy_dir = F:\oracle\<sid>\sapbackuparch

PROBLEM is that database backups are failing as they are still trying to go to the OLD directory:

BR0252E Function fopen() failed for 'F:\oracle\Z01\sapbackup\beeihzqt.and' at location main-9

BR0253E errno 2: No such file or directory

BR0121E Processing of log file F:\oracle\Z01\sapbackup\beeihzqt.and failed

YET archive backups are going to the NEW directory!!!

I'm somewhat confused. Do I have to change another parameter somewhere else too? Hmmmm...

Any help is appreciated.

Thanks and Best Regards,

Than

[than_martens · Accepted solution]

Hey Volker,

Yes - True, if I recreate the sapbackup directory where it was before, then Sapbackup will not fail as files will be created in that directory.

But, nothing in init<sid>.sap still points to the original "sapbackup" directory, so why is BRBACKUP trying to place files there?

Surely I should be able to move this directory, especially when I want to move to another drive entirely, say the G: drive.

Than

[volker_borowski2 · Accepted solution]

Yes you are able

Open a CMD.EXE, set SAPBACKUP to any position of your choice and run a backup.

backup_root_dir is a parameter for backups to disk.

Now even a backup to tape writes a log that has to be stored somewhere.

On UNIX it defaults to /oracle/SID/sapbackup

On Windows it defaults to %SAPDATA_HOME%\sapbackup

If you like to set it elsewhere you need to make SAPBACKUP-environment point to a diffrent location

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/e7/4fb2a8ee10294dbb23378a23e84e46/content.htm

The same applies to SAPARCH environment it you like to change it

Best regards

Volker

[than_martens · Accepted solution]

Hey Volker,

Brilliant!

Thanks for the further explanation, I now understand what you were getting at in your first post.

I've learned something new today, good thing too, the day's almost over.

Thanks very much.

Than.

[volker_borowski2]

Hi Than,

if you erased the sapbackup directory, brbackup can not store the logs (*.and) anywhere.

Recreate the sapbackup directory.

You will have the protocols there (*.and) but the the backup-files will be in your desired loaction.

Check your SAPARCH directory.

You will have protocols (i.e. *.cds or *.svd) in that location as well.

If you like to change those, you need to adjust the environment (SAPBACKUP / SAPARCH)

and the profile for the instance as well so DB14 can find the logs.

Hope this helps

Volker