1. Command Line Interface
  2. Verb Reference
  3. EM CLI Verbs
  4. create_standby (deprecated)

create_standby (deprecated)

Creates a standby database generated from a backup of a primary database.

Note:

Since create_standby is deprecated, use create_standby_database instead.

Format

emcli create_standby      
		 -source_db_target_name="<standby database target name>"
      -source_db_target_type="oracle_database|rac_database"
      -dest_oracle_sid="<standby instance name>"
      -spname="<standby database unique name>"
      [-source_db_creds_name="primary database credential name"]
		 [-source_host_creds_name="primary database host credential name"]
		 [-dest_host_creds_name="standby database host credential name"]
		 [-asm_inst_creds_name="asm instance credential name"]
 		 [-dest_host_name="standby host name"]
		 [-dest_oracle_home="standby database oracle home"]
		 [-dest_target_name="standby database target name"]
		 [-use_duplicate=\"Yes|No\"]
		 [-source_staging_area="primary staging directory"]
		 [-storage_type="storage type"]
		 [-dest_db_database_area="standby database files location"]
		 [-dest_db_recovery_area="standby database fast recovery area"]
		 [-dest_listener_selection="standby database listener selection"]
		 [-dest_listener_name="standby database listener name"]
		 [-dest_listener_port="standby database listener port"]
		 [-stby_type="standby type"]
		 [-use_broker=\"Yes|No\"]
		 [-use_sys_dba_monitoring_creds="use sys dba monitoring creds"]
		 [-dest_staging_area="standby staging directory"]
		 [-configure_with_oracle_restart]

Options

  • source_db_target_name

    Primary database Enterprise Manager target name source. Can either be a single-instance database or a cluster database instance.

  • source_db_target_type

    Primary database target type. Specify oracle_database for single instance, or rac_database for cluster.

  • dest_oracle_sid

    Standby database instance name.

  • spname

    Standby database unique name.

  • source_db_creds_name

    Primary database named credential for a user with SYSDBA or SYSDG role. Default is to use preferred credential.

  • source_host_creds_name

    Primary database host named credential for an operating system user who can access the primary database Oracle Home. Default is to use preferred credential.

  • dest_host_creds_name

    Standby database host named credential for an operating system user who can access the primary database Oracle Home. Default is to use preferred credential.

  • asm_inst_creds_name

    ASM instance named credential.

  • dest_host_name

    Standby database host name. Default is primary host name.

  • dest_oracle_home

    Standby database Oracle Home location. Default is primary database Oracle Home location.

  • dest_target_name

    Standby database Enterprise Manager target name. Default is standby database unique name.

  • use_duplicate

    Database files moved directly to clone the database host by the Recovery Manager(RMAN). Default is yes.

  • source_staging_area

    Staging area used to store the backup of a primary database. This option is applicable only when use_duplicate is not set.

  • storage_type

    Standby database storage type.

    • FILE_SYSTEM: Standby database files are in a regular file system.

    • ASM_STORAGE: Standby database uses Automatic Storage Management (ASM).

    Default is FILE_SYSTEM.

  • dest_db_database_area

    Standby database files Oracle-managed files (OMF) location. Can be a regular file system (if storage_type is FILE_SYSTEM) or an ASM diskgroup (if storage_type is ASM_STORAGE).

  • dest_db_recovery_area

    Standby database fast recovery area.

  • dest_listener_selection

    Standby database listener selection.

    • GRID_INFRA: Uses the Grid Infrastructure Home listener.

    • DEST_DB_HOME: Uses the listener from the standby database Oracle Home.

    Default is GRID_INFRA.

  • dest_listener_name

    Standby database listener name. This option is applicable only if dest_listener_selection is set to DEST_DB_HOME.

    If not specified, default value is the first existing TCP listener found in the standby database Oracle Home. Note that if dest_listener_name is specified, then dest_listener_port must also be specified.

  • dest_listener_port

    Standby database listener port. This option is applicable only if dest_listener_selection is set to DEST_DB_HOME. Note that if dest_listener_port is specified, then dest_listener_name must also be specified.

  • stby_type

    Type of the standby database to be created.

    • PHYSICAL

    • LOGICAL

    Default is PHYSICAL.

  • use_broker

    Uses Data Guard broker to manage the Data Guard configuration. Default is yes.

  • use_sys_dba_monitoring_creds

    Uses SYSDBA credentials to monitor the standby database. Default is no.

  • dest_staging_area

    Staging area used to store the backup files transferred from the primary host. This option is applicable only when use_duplicate is not set.

  • configure_with_oracle_restart

    If the destination host has Oracle Restart configured, it configures the standby database with Oracle Restart. When required, Oracle Restart automatically starts the standby database. Default is no.

Examples

Example 1

The following command creates a standby database with the unique name “database1" generated from the backup of a primary single-instance database named “Database".

emcli create_standby
      -source_db_target_name="database"
      -source_db_target_type="oracle_database"
      -dest_oracle_sid="database1"
      -spname="database1"

Example 2

The following command creates a standby database with the unique name "database1" generated from the backup of a cluster database named "primary". The standby database uses SYSDBA credentials for monitoring and uses Data Guard broker to manage the Data Guard configuration.

emcli create_standby 
      -source_db_target_name="primary"
      -source_db_target_type="rac_database"
      -dest_oracle_sid="database1"
      -spname="database1"
      -use_broker="Yes"
      -use_sys_dba_monitoring_creds="Yes"