Manually Recovering a Database after V2P
Datasets / Getting Started / Provisioning and Managing Virtual Databases / Virtual to Physical / Manually Recovering a Database after V2P

This topic describes how to manually recover a database after the V2P process. 

For Oracle database, while running V2P you can set recoverDatabase=false and openDatabase=false. If you set recoverDatabase=false, you need to run recover-vdb.sh, followed by open-vdb.sh. But if you perform V2P with recoverDatabase=true and openDatabase=false, you will need to run open-vdb.sh.

Procedure

  1. In the V2P target environment, navigate to the scripts directory for your exported database instance.
    You can find the scripts in a sub-directory named for that specific database instance. For Oracle databases, the path is<target_directory>/<db_unique_name>/script/<instance name>. For SQL Server databases, the path is<target_directory>\<db_name>\scripts.
  2. For Oracle databases, locate the scripts recover-vdb.sh and open-vdb.sh. Run them in that order.
    For SQL Server databases, locate the script Provision.ps1 and run it.
  3. For SQL Server databases, when the script completes, Refresh the target environment for it to discover the recovered database.
    For Oracle databases, add the recovered database to /etc/oratab and Refresh the target environment for it to discover the recovered database.

Related Topics