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"