2.5
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director Administrator and User Guide
- VMware vFabric Data Director Overview
- Managing Data Director Resources
- Resource Management Overview
- Resource Bundles and Resource Pools
- System Resource Bundle
- Resource Assignment
- vSphere Resource Pools and Data Director
- Viewing Resource Information
- Create the System Resource Pool
- Create the System Resource Bundle
- Monitor Resource Usage
- Create a Resource Pool
- Create a Resource Bundle
- Assign a Resource Bundle to an Organization
- Perform Advanced Cluster Configuration
- Managing Users and Roles
- Building DBVMs and Base DB Templates
- Database Virtual Machine OVA Files
- Deploy a DBVM OVA File
- Build a SLES and Oracle Base Database Virtual Machine
- Build a Custom RHEL and Oracle Database Template
- Deploy the base database VM into the System Resource Pool
- Repackage the Linux ISO Image
- Install Linux on a Blank Virtual Machine
- Initialize the Virtual Machine to Make It Oracle and Data Director Compliant
- Install Oracle 11g R2 Software
- Convert a Base DBVM into a Base DB Template
- Validate a Base DB Template
- Assign a Base DB Template to a Resource Bundle
- Install the Operating System and Database Software in a Blank DBVM
- Requirements for the Kickstart File
- Database Update Configuration
- Configure a vFabric Postgres Update Chain
- Update an Oracle Database
- Identify Existing Target DBVM
- Create a Base Database VM from an Existing Template
- Apply a Patch to the Base Database Virtual Machine
- Convert a Base DBVM into a Base DB Template
- Validate a Base DB Template
- Assign a Base DB Template to a Resource Bundle
- Enable a Base DB Template
- Configure an Oracle Update Chain
- Update a Database
- Managing Organizations
- IP Whitelists
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Database Lifecycle
- Requirements for Creating Databases
- Database Creation
- Using Tags
- Managing the Organization Catalog
- Batch Operations and Scheduled Tasks
- Updating Databases
- Database Administration
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Backup Strategies
- Backup Types
- Backup Template Settings
- Preconfigured Backup Templates
- Select a Database Backup Template
- Schedule Regular Database Backups
- Recover a Database
- Import Backups
- Use VMware Data Recovery to Back Up Data Director
- Database End of Life and Backups
- Perform Point-in-time Recovery of Management Server Database
- Add Pre-Action and Post-Action Scripts to the DBVM for Selected Agents
- Monitoring the Data Director Environment
- Managing Licenses
- IP Pool Management
- VMware vCloud Director Integration
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Reconfigure the Database Access Network Used by a Database Group
- Modify IP Pool Settings
- Managing SSL Keys and Certificates
- Regenerate Management Server Key and Certificate
- Import Management Server Key and Certificate
- Edit Management Server Certificate
- Regenerate DB Name Server Key and Certificate
- Import DB Name Server Key and Certificate
- Edit DB Name Server Certificate
- Regenerate DBVM Key and Certificate
- Import DBVM Key and Certificate
- Edit DBVM Certificate
- Data Director Troubleshooting
- Index
View Database Entities
You can view database groups and databases in your organization, and the entities and objects of running
databases.
Prerequisites
Verify that you have Organization management privileges, or View properties permissions to view databases
in the organization.
Procedure
1 Log in to Data Director.
2 If you have Organization management privileges, click the Manage and Monitor tab to view your
database groups and databases.
If you do not have Organization management privileges, a list of database groups is displayed in the right
pane.
3 Expand a database group in the left pane.
4 Double-click a database in the middle pane
5 Click the Console tab.
If it is an Oracle database, the Oracle Enterprise Manager (OEM) opens in a new browser window. If it is
a Postgres database, the database opens in a new tab next to your organization tab.
6 If prompted, log in to the database
7 Expand entity icons in the left pane and select them to view details.
The object appears in the middle pane, and you can perform management tasks.
What to do next
Manage database entities.
Vacuum Analyze a Database
You can use Vacuum Analyze to discover and reclaim storage occupied by dead tuples. Tuples you delete or
that are made obsolete when you update the database, remain in their table until you perform a Vaccum action.
You should use Vaccum periodically, particularly on frequently updated tables, to keep the database
performing well. Analyze collects statistics about the contents of tables and stores the results. The query planner
helps you determine the most efficient execution plan for queries. You can perform Vacuum and Analyze on
a database or a table.
Prerequisites
Verify that a database exists.
Log in to Data Director as a user with database privileges.
Procedure
1 Click the Manage and Monitor tab.
2 Click your database group.
3 Double-click your database to select it.
4 Click Console to open the database in a new tab.
5 Right-click your database in the left pane and select Vacuum Analyze Database.
VMware vFabric Data Director Administrator and User Guide
122 VMware, Inc.