6.1

Table Of Contents
Requirements for Using Oracle Server with Site Recovery Manager
When you create an Oracle Server database, you must configure it correctly to support
Site Recovery Manager.
You create and configure an Oracle Server database for Site Recovery Manager by using the tools that
Oracle Server provides.
This information provides the general steps that you must perform to configure an Oracle Server database
for Site Recovery Manager. For instructions about how to perform the relevant steps, see the Oracle
documentation.
n
When creating the database instance, specify UTF-8 encoding.
n
Grant the Site Recovery Manager database user account the connect, resource, create session privileges
and permissions.
For information about database sizing, see the Sizing calculator for vCenter Site Recovery Manager databases -
Oracle at http://www.vmware.com/products/site-recovery-manager/resource.html.
Back Up and Restore the Embedded vPostgres Database
If you select the option to use an embedded database for Site Recovery Manager, the Site Recovery Manager
installer creates a vPostgres database during the installation process. You can back up and restore the
embedded vPostgres database by using PostgreSQL commands.
Always back up the Site Recovery Manager database before updating or upgrading Site Recovery Manager.
You also might need to back up and restore the embedded vPostgres database if you need to uninstall then
reinstall Site Recovery Manager and retain data from the previous installation, migrate
Site Recovery Manager Server to another host machine, or revert the database to a clean state in the event
that it becomes corrupted.
Prerequisites
For information about the commands that you use to back up and restore the embedded vPostgres database,
see the pg_dump and pg_restore commands in the PostgreSQL documentation at
http://www.postgresql.org/docs/9.3/static/index.html.
Procedure
1 Log into the system on which you installed Site Recovery Manager Server.
2 Stop the Site Recovery Manager service.
3 Navigate to the folder that contains the vPostgres commands.
If you installed Site Recovery Manager Server in the default location, you find the vPostgres commands
in C:\Program Files\VMware\VMware vCenter Site Recovery Manager Embedded Database\bin.
4 Create a backup of the embedded vPostgres database by using the pg_dump command.
pg_dump -Fc --host 127.0.0.1 --port port_number --username=db_username srm_db >
srm_backup_name
You set the port number, username, and password for the embedded vPostgres database when you
installed Site Recovery Manager. The default port number is 5678. The database name is srm_db and
cannot be changed.
5 Perform the actions that necessitate the backup of the embedded vPostgres database.
For example, update or upgrade Site Recovery Manager, uninstall and reinstall Site Recovery Manager,
or migrate Site Recovery Manager Server.
Chapter 3 Creating the Site Recovery Manager Database
VMware, Inc. 19