refresh_database

Refreshes the database from the latest data in the source database. This command places the database target under blackout and the database is deleted from the Oracle Home. The database is then recreated from the latest data in the source database and the target is removed from blackout.

Note:

This command only applies to full clone test master databases created using the Database Cloning wizard. It does not apply to thin clone databases.

Format

emcli refresh_database
      -target_name="database target name"
      -target_type="database target type"
      -input_file=data:"file:path" 

Options

• target_name

  The target name of the database to be refreshed.

• target_type

  The target type of the database to be refreshed.

• input_file

  The input file containing parameters for the temporary staging location and all passwords to be set:

  • DB_TEMPLATE_STAGE

    The staging area used to store files transferred from the source host.

  • COMMON_DB_SYSTEM_PASSWORD

    The password to be set for SYSTEM user.

  • COMMON_DB_DBSNMP_PASSWORD

    The password to be set for the DBSNMP user.

  • COMMON_DB_SYS_PASSWORD

    The password to be set for SYS user.

  • ASMSYSPWD

    The ASM SYS password required to sign in to ASM. This password is only required if the database files are on ASM.

Example

The following example refreshes the Oracle database with the name 'database' using the parameters contained in the /tmp/a.txt file:

emcli refresh_database       -target_name="database" 
      -target_type="oracle_database" 
      -input_file=data:"/tmp/a.txt" 

In this example, the /tmp/a.txt has the following content:

DB_TEMPLATE_STAGE=/tmp
COMMON_DB_SYSTEM_PASSWORD=welcome
COMMON_DB_DBSNMP_PASSWORD=welcome
COMMON_DB_SYS_PASSWORD=welcome
ASMSYSPWD=welcome