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
Managing Database Entities 11
Managing database entities includes managing schemas and tables, and performing SQL management tasks.
To manage database entities, you need view database permissions on the database. Your organization
administrator can create a role that has the necessary permissions, and the administrator can grant that role to
you.
Permissions that you have on the organization apply to all database groups and databases in the organization.
Permissions on a database group apply to all databases in the database group.
Data Director supports the following types of management tasks.
Database Entity
Management
Database entity management includes creating, replacing, updating, and
deleting database entities. These database entities include schemas, tables,
views, indexes, functions, sequences, triggers, constraints, and users.
SQL Management
SQL management tasks include SQL profiling, query plan analysis, running
ad-hoc queries or SQL scripts.
This chapter includes the following topics:
n
“Database Entity Management,” on page 121
n
“SQL Management,” on page 126
Database Entity Management
Administrators perform database entity management tasks to ensure the effective and efficient operation of
databases.
You can manage database entities from the Database tab. Managing database entities includes vacuuming and
analyzing databases, and creating, altering, dropping, and browsing database entities such as the following.
n
Schemas
n
Tables
n
Views
n
Columns
n
Indexes
n
Sequences
n
Constraints (primary, foreign, and unique key)
n
Users and roles
Data Director lists schema objects in the left pane. You manage individual objects from the middle pane.
VMware, Inc.
121