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