21:Oracle Source Management

A source host is a server that hosts the source databases. A test data environment includes access definition to one source database and a GI. This section describes how to create and manage a Source Host and a Test Data Environment.

To open the Source work area:

1. On the navigation bar, click Source.

The Source Hosts window appears displaying all the source hosts that have been added to the system.

To modify a source host:

1. Select the source host.

2. 

   Click Modify source host.

3. Modify the source host as required.

4. To save your changes, click Modify.

To see source host information:

1. Select the source host.

2. Click Source host info.

The Info window appears.

3. To return to the main Source Management work area, click Close.

To remove a source host:

1. Select the source host.

2. Click Remove source host.

3. Click Remove to confirm the deletion or Cancel to exit without deleting the source host.

The create a test data environment from the VDB Management window:

1. Open the VDB Management window.

2. In the VDB Management window, select a Test Data Environment.

Live GI

To create a Live GI:

1. Click Create LIVE GI.

   

2. Enter a Name.

   

3. Click Create.
   After the GI is created, the following message appears: Golden Image (live) has been created.

4. The VDB Management window displays the GI that was created.

   

5. The GI icon appears on the left.. Click the info icon, next to the GI. It will show the newly created directory on the source server. (The directory was created automatically by Accelario)
   

   

6. You can verify the directory by running df -h command on source. E.g. :
   

   

7. You will need to create your oracle instance on this directory, so all datafiles, controlfiles, redo, archives , dump and audit will point to this path

   E.g. spfile parameters:

   *.audit_file_dest='/main_pool/00000046/adump'

   *.control_files='/main_pool/00000046/control01.ctl'

   *.db_create_file_dest='/main_pool/00000046'

   *.db_create_online_log_dest_1='/main_pool/00000046'

   *.db_recovery_file_dest='/main_pool/00000046'

   *.diagnostic_dest='/main_pool/00000046'

   *.log_archive_dest_1='location=/main_pool/00000046'

    The spfile itself should also be placed on the same directory

8. Once the database is up and running , proceed to activate the GI. Click the Activate icon net to the GI. The Activation verifies that the new database is fully located in the required directory.

   

9. Once the activation is completed, a first snapshot is created and you can proceed with VDB creation.

   

RMAN GI

To create a RMAN GI:

1. Click Create RMAN GI.

2. Enter a Name.

3. Click Create.

The VDB Management window displays the RMAN GI that was created.

To create a test data environment:

To edit a test data environment:

1. Select the test data environment.

2. Click Modify Test Data environment.

The Modify Test Data Environment window appears. Modify the test data environment name if necessary.

3. Click Next to go to the next Modify Test Data Environment window.

To modify a Live GI:

1. Modify the Golden Image Parameters as required.

2. Click Next to go to the next Modify Test Data Environment window.

3. Modify the Source DB Parameters as required.

4. To save your changes, click Modify.

To modify a RMAN GI:

1. Modify the Golden Image Parameters as required.

2. Click Next to go to the next Modify Test Data Environment window.

3. Modify the Source DB Parameters as required.

4. To save your changes, click Modify.

To modify a RMAN STANDBY GI:

1. Modify the Golden Image Parameters as required.

2. Click Next to go to the next Modify Test Data Environment window.

3. Modify the Source DB Parameters as required.

4. To save your changes, click Modify.

To see information about a test data environment:

1. Select the test data environment.

2. Click Test Data Environment Info.

The Info window appears.

3. To return to the main Source Management work area, click Close.

To remove a test data environment:

1. Select the test data environment.

2. Click Remove Test Data Environment.

3. Click Remove to confirm the deletion or Cancel to exit with deleting the test data environment.