Let's assume you have some devices defined. To display the list of devices you can use following command:
sp_helpdevice
Knowing that dumpsdev is a valid name of dump device you try to execute following dump command on the Backup Server. Note, that you try to use the name of the device:
DUMP DATABASE ALFA TO dumpsdev AT SAP01_BS WITH COMPRESSION=9
Unfortunatelly the dump command ends with error message:
Could not execute statement.
Error encountered by Backup Server. Please refer to Backup Server
messages for details.
SQLCODE=8009
Server=SAP01, Severity Level=16, State=1, Transaction State=0, Line=16
Line 31
To see, what is a problem, indeed you need to go to backup server logs. Depending on installation specifics the location of file can be different:
tail -f /opt/sap/ASE-16_0/install/SAP01_BS.log
What you will be able to see there is probably something similar to:
Mar 12 15:51:58 2017: Backup Server: 2.23.1.1: Connection from Server SAP01 on Host CANTOR10 with HostProcid 5500.
Mar 12 15:51:58 2017: Backup Server: 4.172.1.4: The value of 'allocated pages threshold' has been set to 40%.
Mar 12 15:51:58 2017: Backup Server: 4.41.1.1: Creating new disk file /dumpsdev.
Mar 12 15:51:58 2017: Backup Server: 1.70.1.2: Configuring the shared memory per stripe to 786432 bytes.
Mar 12 15:51:58 2017: Backup Server: 4.141.2.40: [11] The 'open' call failed for database/archive device while working on stripe device '/dumpsdev' with error number 13 (Permission denied). Refer to your operating system documentation for further details.
What has happened? Backup Server received the name of backup device 'dumpsdev' and treated this as the name of file that should be created for the dump. It decided to create the file in the root folder, where access is of course not allowed, so error 13 (Access Denied) has been recorded.
Conclusion: don't use dump devices on remote Backup Servers, Dump devices can be used only locally.
No comments:
Post a Comment