add shardspace

Add a shardspace to the shard catalog.

Syntax

add shardspace -shardspace shardspace_name 
              [-chunks number] 
              [-protectmode dg_protection_mode]
              [repfactor][repunits]

Options

Table 2-15 GDSCTL add shardspace Options

Option	Description
-shardspace shardspace_name	Specify the name of the shardspace. The shardspace name can be up to 30 characters long and can be an alphabetical character followed by zero or more alphanumeric ASCII characters or an underscore (_).
-chunks number	Specify the number of unique chunks in the shardspace. The value of -chunks must be greater than 2 times the size of the largest shardgroup in any shardspace. This parameter does not apply to user-defined sharding or a federated database. All shardgroups in a shardspace have the same number of chunks. If this parameter is not specified, the default number of chunks is determined at the time of execution of the first DEPLOY command and is 120 per database of the shardgroup with the biggest number of databases.
-protectmode dg_protection_mode	Specify the Data Guard protection mode: MAXPROTECTION, MAXAVAILABILITY,or MAXPERFORMANCE (default). This parameter does not apply to Oracle GoldenGate replication.
-repfactor	Replication factor (the number of replicas for each piece of data stored in a shardgroup). This parameter can only be used with NATIVE replication and system-managed or composite sharding, and is mandatory in these cases. It doesn't apply to user-defined sharding or a federated database since there are no shardgroups in this case.
-repunits	Total number of replication units (SNR only).

Usage Notes

The command is applicable to user-defined sharding, composite sharding that assumes multiple shardspaces, and system managed sharding when there are no other shardspaces present in the current configuration.

Examples

Add the GOLD shardspace with Data Guard MAXAVAILABILITY protection mode.

GDSCTL> add shardspace –shardspace gold –protectmode maxavailability