Enable Point In Time Recovery on ArcGIS Data Store 11.3

Question

I made a full backup yesterday using webgisdr, and tonight I wanted to make an incremental backup, but when I tried to run webgisdr with a new properties file that had BACKUP_RESTORE_MODE = incremental, I got the following response:

==================================================

Starting the WebGIS DR utility.

==================================================

The point-in-time recovery is turned off in the Relational Data Store: https://my_domain:2443/arcgis

Use the changedbproperties tool within the tools folder of the ArcGIS Data Store installation directory to enable point-in-time recovery. Visit the ArcGIS Data Store help for more information.

Exiting the WebGIS DR utility.

I then attempted to enable pitr with:

./changedbproperties.sh --store relational --pitr enable

You are changing the following database properties:

...Point-In-Time Recovery: enable

WARNING: You are trying to turn on Point-In-Time Recovery. A backup will be created following the change, and that might take a while.

Changing database configurations could cause the database to restart. Please do not interrupt the process once it has started.

Do you want to continue (Yes or No)?

I responded with No. Does the response mean that just a data store backup will be performed? Do I need to delete my last full webgisdr backup and start over after changing the pitr setting? I checked all the online documentation and the community for more information, but couldn't find anything that gives me any confidence in how to proceed.

Any additional information is greatly appreciated.

BGISPro · Answer

Hi @bcunningham04 ,

In 11.5, pitr is indeed disabled by default when being installed, not sure about 11.3, but it's probably disabled too based on all the observations that's been discussed in this thread.

The reason I believe this is the case is because in Esri's Chef cookbook (v5.3.0) for 11.5's base deployment file 'arcgis-enterprise-primary.json', it reads the below for the data store section:

"data_store": {            "install_dir": "C:\Program Files\ArcGIS\DataStore",            "setup_options": "ADDLOCAL=relational,object",            "install_system_requirements": true,            "data_dir": "C:\arcgisdatastore",            "preferredidentifier": "hostname",            "types": "relational,object",            "object": {                "backup_type": "fs",                "backup_location": "\\FILESERVER\arcgisbackup\object"            },            "relational": {                "backup_type": "fs",                "backup_location": "\\FILESERVER\arcgisbackup\relational",                "disk_threshold_readonly": 5120,                "max_connections": 150,                "pitr": "disable",                "enablessl": true

bcunningham04 · Answer

Is this something that changed by default when we upgraded to 11.3? I just now noticed almost a year after upgrading to 11.3 that my incremental backups have not been running because of the same issue that @IngoSchmied posted about. Prior to upgrading (I was on 10.9.1 before making the 11.3 jump last year) my incremental backups ran weekly.

Is the pitr disabled by default when ArcGIS Server is installed/upgraded, or is this something that ESRI changed in 11.x for a particular reason?

Thanks,

Brian

BillFox · Answer

select Yes to continue

that will create a new full backup that will become your new base point for the incremental backups to rely on until the next full backup