...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
You can set up additional test data environments. |
To add a source host:
On the navigation bar, click Source. Explained here
The Source Management window
...
2. Click Add Source Host.
3. Enter the source host details.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
In all dialog boxes, an asterisk * next to a label on the left is used to identify a mandatory user input. |
...
4. Enter the Advanced Parameters if necessary.
...
5. Click Add.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
After the source host is added, the following message appears: Source Host has been added. |
The Source Management window displays the source host(s) that have been added to the system.
...
To create a test data environment:
...
The Source Management window appears.
...
2. Click Create Test Data Environment.the (+) sign in the right panel
3. Select DB type.
...
4. Enter a Name.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
After the test data environment is created, the following message appears: Test Data Environment has been created. |
...
has been created. |
...
5. Continue to https://accelario.atlassian.net/wiki/spaces/DVPD/pages/2176976272/21%3AOracle+Source+Management#Live-GI
...
Enter the test data environment details.
...
2. Click Next. 3. Enter the Source DB Parameters.The application runs an automatic discovery of all running Oracle databases and presents them in a list. More details on how discovery works
...
3. You may choose from the list or enter the details manually:
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
It is recommended to select the Refresh Immediately checkbox to make a full copy of the Golden Image after the test data environment is automatically created. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
After the test data environment is created, the following message appears: Test Data Environment as been created. |
Ignore some errors when building GI
When GI is built, Accelario Virtualization checks automatically all the logs and searches for errors. The errors have a known template: ORA-99999, RMAN-99999
, etc... If any error is found the GI process is accounted to be failed. However, it is possible to configure some errors to be ignored. In order to do it:
Goto GI agent directory on the source server
Edit file
gi-agent-excluded-error-codes.properties
Add error code - one per line.
Restart the GI agent
To create a test data environment from a RMAN STANDBY GI:
...
To create a test data environment from a AWS RDS Oracle GI:
Enter the test data environment details.
...
Click Next.
Enter the Source DB Parameters.
Enter AWS parameters
...
Click Next.
Provide AWS RDS Oracle connectivity parameters, on that step, you can perform a test connection to the AWS.
...
The oracle user in the RDS Oracle database must have the following permissions:
Code Block |
---|
GRANT dba TO acc_rman_user;
GRANT EXECUTE ON RDSADMIN.RDSADMIN_UTIL TO acc_rman_user;
GRANT EXECUTE ON RDSADMIN.RDSADMIN_RMAN_UTIL TO acc_rman_user;
GRANT EXECUTE ON RDSADMIN.RDSADMIN_MASTER_UTIL TO acc_rman_user;
GRANT EXECUTE ON RDSADMIN.RDSADMIN_S3_TASKS TO acc_rman_user;
GRANT EXECUTE ON rdsadmin.rds_file_util TO acc_rman_user;
GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO acc_rman_user; |
Click Next
Enter the Source DB Parameters.
...
Follow the explanations here
To add a target host:
On the navigation bar, click Target.
The Target Management window appears.
...
2. Click Add Target Host.
3. Enter the target host details.
...
4. Enter the Advanced Parameters if necessary.
...
5. Click Add.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
After the target host is added, the following message appears: Target Host has been added. |
The Target Management displays the target host(s) that have been added to the system.
...
In case of Linux or AIX targets, the mount options configuration will be available in the Advanced Parameters section of agent’s properties. These options are used in the
mount
command. The default value is optimized according to Oracle’s recommendations.
For Linux it is :
-t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,nolock
For AIX it is :
-o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144
To add a DB Home:
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
You add a DB Home in the Target work area. |
Click Add DB Home.
...
the (+) sign on the right panel
...
2. Select a DB type.
...
The application runs an automatic discovery of all installed Oracle database software and presents them in a list. More details on how discovery works . Pay attention: the discovery is based on running Oracle databases.
...
4. You may choose from the list or enter the details manually:
...
4. Click Add.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
After the DB Home is added, the following message appears: DB Home has been added. |
The Target Management displays the DB Home(s) that have been added to the system.
...
To create and start a VDB.
...