create_far_sync
Creates a far sync instance.
Format
emcli create_far_sync -primary_target_name="<primary database target name>" -primary_target_type="oracle_database|rac_database" -far_sync_sid="<far sync instance name>" -far_sync_db_unique_name="<far sync instance unique name>" [-far_sync_em_target_name="<far sync instance target name>"] [-far_sync_host_name="<far sync instance host name>"] [-far_sync_oracle_home="<far sync instance Oracle home>"] [-far_sync_db_create_file_dest="<far sync instance files location>"] [-far_sync_fra_location="<far sync instance fast recovery area>"] [-far_sync_fra_size="<far sync instance fast recovery area size>"] [-primary_db_creds_name="<primary database credential name>"] [-primary_host_creds_name="<primary database host credential name>"] [-far_sync_host_creds_name="<far sync instance host credential name>"] [-far_sync_asm_cred_name="<far sync instance asm credential name>"] [-far_sync_storage_type="<far sync instance storage type>"] [-far_sync_listener_name="<far sync instance listener name>"] [-far_sync_listener_port="<far sync instance listener port>"] [-redo_source="<far sync instance redo source>"] [-redo_mode="<far sync instance redo shipping mode>"] [-redo_dest="<far sync instance redo destination>"]
Options
-
primary_target_name
Primary database Enterprise Manager target name. Can be either a single-instance database or a cluster database.
-
primary_target_type
Primary database target type. Allowed values:-
oracle_database: Single-instance database
-
rac_database: Cluster database
-
-
far_sync_sid
Far sync instance name.
-
far_sync_db_unique_name
Far sync instance unique name.
-
far_sync_em_target_name
Far sync instance Enterprise Manager target name. The default value is far_sync_db_unique_name followed by db_domain.
-
far_sync_host_name
Far sync instance host name. The default value is primary host name.
-
far_sync_oracle_home
Far sync instance host Oracle home location. The default value is primary database Oracle home location.
-
far_sync_db_create_file_dest
Oracle-managed files (OMF) location for far sync instance files. Can be a regular file system (if storage_type is FILE_SYSTEM) or an ASM diskgroup (if storage_type is ASM_STORAGE). The default values are:-
File system - Far sync instance's <oracle_base>/oradata
-
ASM - Mandatory
-
-
far_sync_fra_location
Far sync instance fast recovery area.
The default values are:-
File system - Far sync instance's <oracle_base>/fast_recovery_area
-
ASM - Mandatory
-
-
far_sync_fra_size
Far sync instance fast recovery area size in MB. The default value is Primary fra_size.
-
primary_db_creds_name
Primary database named credential for a user with SYSDBA or SYSDG role. Preferred credentials will be used as the default value.
-
primary_host_creds_name
Primary database host named credential for an operating system user who can access the primary database Oracle home. Preferred credentials will be used as the default value.
-
far_sync_host_creds_name
Far sync instance host named credential for an operating system user who can access the far sync instance Oracle home. Preferred credentials will be used as the default value.
-
far_sync_asm_cred_name
Automatic Storage Management named credential.
-
far_sync_storage_type
Far sync instance storage type. The allowed values are:-
FILE_SYSTEM: Far sync instance files will be in a regular file system
-
ASM_STORAGE: Far sync instance will use Automatic Storage Management
The default value is FILE_STORAGE.
-
-
far_sync_listener_name
Far sync instance listener name. If the default value is not specified, the first existing TCP listener found in the far sync instance Oracle home or a running GRID INFRA listener will be used. If listener_name is specified, listener_port must also be specified.
-
far_sync_listener_port
Far sync instance listener port. If listener_port is specified, listener_name must also be specified.
-
redo_source
db_unique_name of the database that will act as a redo source for the new far sync instance. The default value is Primary database db_unique_name.
-
redo_mode
The mode of redo shipping to the new far sync instance. The default value is sync and the allowed value is sync or async.
-
redo_dest
The list of db_unique_names of the standby databases to which the new far sync instance will ship redo. For example "standby1,standby2". There is default value for this option.
Examples
Example 1
The following command creates a file system based far sync instance.
emcli create_far_sync -primary_target_name=database -primary_target_type="oracle_database" -far_sync_sid="fsd4" -far_sync_db_unique_name="fsd4" -primary_db_creds_name=SYS -primary_host_creds_name=HOST_CRED -db_create_file_dest=/scratch/orabase/ORADATA -far_sync_em_target_name=fsd4 -far_sync_host_name=abc.example.com -far_sync_oracle_home=/scratch/orabase/product/12.1.0/dbhome_1 -fra_location=/scratch/orabase/fra -fra_size=3000 -far_sync_host_creds_name=HOST_CRED -listener_name=LIST_L -listener_port=1531
Example 2
The following command creates an ASM based far sync instance.
emcli create_far_sync -primary_target_name="database" -primary_target_type="oracle_database" -far_sync_sid="asmfs2" -far_sync_db_unique_name="asmfs2" -primary_db_creds_name=SYS -primary_host_creds_name=HOST_CRED -db_create_file_dest='+DATA' -far_sync_em_target_name=asmfs2 -far_sync_host_name=abc.example.com -far_sync_oracle_home=/scratch/orabase/product/12.1.0/dbhome_1 -fra_location=+DATA -fra_size=3000 -far_sync_host_creds_name=HOST_CRED -far_sync_asm_cred_name=ASM_CRED -redo_source=farsync1 -redo_mode=async -redo_dest="stdb1,stdb2"