To set up the infrastructure in the Data Virtualization Module, do the following procedure:
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#Self-service-deployment-for-Oracle-RMAN
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#To-add-a-source-host%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#To-create-a-test-data-environment%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#To-add-a-target-host%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#To-add-a-DB-Home%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371969202176975966/Oracle+Initial+Setup#To-create-and-start-a-VDB.
Self-service deployment for Oracle RMAN
You can use a self-service deploy wizard to define your first Oracle RMAN golden image of a production database and to create your first VDB. The following operations can be done with the self-service deploy wizard:
...
With the self-service deploy wizard, you can configure the source and target Accelario agents, validate the host name and agent port, and automatically discover the source and target databases. The wizard will also deploy the Oracle RMAN Golden Image, load it with an initial set of data, provision the first VDB, and permit you to start to work immediately. This can be done without assistance from a third-party vendor or technical support team. Additionally, you can set up additional test data environments.
To deploy an Oracle RMAN with the Self-service Deploy wizard:
Click the Self-service Deploy app on the taskbar
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
You can set up additional test data environments. |
To add a source host:
On the navigation bar, click Source.
...
The Source Management window displays the source host(s) that have been added to the system.
...
To create a test data environment:
On the navigation bar, click Source.
...
4. Enter a Name.
...
5. Click Next.
To create a test data environment from a LIVE GI:
Enter the test data environment details.
Make sure to enable “Force creation”
...
5. Continue to https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21370671082176976272/Oracle21%3AOracle+Source+Management#Live-GI
To create a test data environment from a RMAN 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.propertiesAdd error code - one per line.
Restart the GI agent
To create a test data environment from a RMAN STANDBY GI:
Enter the test data environment details.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
After the test data environment is created, the following message appears: Test Data Environment as been created. |
To create a test data environment from a AWS RDS Oracle GI:
Follow the explanations here
To add a target host:
On the navigation bar, click Target.
The Target Management window appears.
...
The Target Management displays the target host(s) that have been added to the system.
...
To add a DB Home:
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
You add a DB Home in the Target work area. |
Click Add DB Home.
...
2. Select a DB type.
...
3. Enter the DB Home details.
...
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.
To create a VDB:
On the navigation bar, click VDB.
The VDB Management window appears.
...
To select a GI:
In the VDB Management window, select a Test Data Environment.
...
2. Select the GI.
...
Adding a snapshot:
Select the source.
Click Add Snapshot.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
It is possible to scroll using the time and date to the right of a search screenshot. |
To create a VDB from a snapshot:
Select a snapshot.
Click Create VDB.
...
The following icons display information about a VDB:
Icon | Description |
 | VDB Locked |
 | VDB Stopped |
 | VDB Started |
 | VDB Creation Failed |