Add Database Archive Location

This is a NuoDB Manager command. See NuoDB Manager.

Description

In the rare case where a storage manager (SM) was started but failed to store the archive location in the durable domain configurationThe durable domain configuration provides domain configuration information that is stored consistently on each broker in the domain by means of a Raft log., execute the add database archiveLocation command to store the archive location correctly.

Syntax

add database archiveLocation 
    dbname database_name
    host host_name 
    path path_name 
    journalPath journal_path
    region region_name
    requirementsName process_group_name

Parameters

Interactive Example

Show configuration information about the test database:

nuodb [domain] > show database config 
Database: test

Database: test, INACTIVE, Status=STOPPED, template [Single Host] 
  Variables: {HOST=6e0fc183-988c-4a54-8309-d4ea3e5dc5d2, REGION=us-east-1} 
  Options: {} 
  Default Options: { "commit": "${COMMIT:remote:1}","backoff.reqMinUptime":"30000"}
  Archive Locations: 
  Single Host UNMET

You can see above that there an archive location is not set. Correct this by setting the archive location:

nuodb [domain] > add database archiveLocation 
Database Name: test 
Host or AgentId: 6e0fc183-988c-4a54-8309-d4ea3e5dc5d2 
Archive Pathname: /var/opt/nuodb/production-archives/test 
Journal Pathname: /var/opt/nuodb/production-archives/test_journal 
Region: us-east-1 
Requirements Name: SMs
nuodb [domain] > show database config 
Database: test 
Database: test, INACTIVE, Status=STOPPED, template [Single Host] 
Variables: {HOST=6e0fc183-988c-4a54-8309-d4ea3e5dc5d2, REGION=us-east-1} 
Options: {} 
Archive Locations: 
ec2-54-165-58-157.compute-1.amazonaws.com/172.31.46.122:48004, requirements: 
SMs, region: us-east-1: 
archive: /var/opt/nuodb/production-archives/test 
journal-dir: /var/opt/nuodb/production-archives/test_journal 
Single Host UNMET

Scripting Example

The same add database archiveLocation command can be executed with --command as follows:

$ nuodbmgr --broker host --password password --command "add database archiveLocation \
    dbname test \
    host 6e0fc183-988c-4a54-8309-d4ea3e5dc5d2 \
    path /var/opt/nuodb/production-archives/test \
    journalPath /var/opt/nuodb/production-archives/test_journal \
    region us-east-1 \
    requirementsName SMs"