Step 5. Specify Oracle Settings
At this step of the wizard, specify the location to which you want to restore the database.
- Select Restore to the original location to publish the database to the original location.
- Select Restore to a different location to publish the database to a custom location.
- In the Oracle home field, specify the Oracle home directory. To locate the Oracle home directory, click Browse and select the folder you want to use.
- In the Global database name field, specify the global database name as DB_NAME.DB_DOMAIN, where:
- DB_NAME is the database name. Oracle limits the length of the database name to 8 characters. If the database name you specify exceeds this limit, Veeam Explorer for Oracle will automatically shorten the database name, and hence the global database name, during the publishing process.
The value you specify is also used for the unique database name (DB_UNIQUE_NAME) of the published database. The unique database name can contain up to 30 characters.
- DB_DOMAIN is the domain name of the database. It does not count towards any character limits and Veeam Explorer for Oracle does not shorten it during the publishing process.
For example, if you specify the global database name as orcl_published.tech.local, Veeam Explorer for Oracle will shorten it to orcl_pub.tech.local. The database name of the published database will be orcl_pub, while the unique database name of the published database will be orcl_published.
- In the Oracle SID field, specify the database system identifier. The Oracle SID field is automatically filled with the value entered in the Global database name field, but you can also assign a different value.
The maximum length of the Oracle SID is 12 characters and it can only contain alphanumeric characters (a-z, A-Z and 0-9).
After you complete this step, a new Published databases node appears at the top of the navigation pane in Veeam Explorer for Oracle. Under this node you can find the databases that have been published during the current session.
If the account specified in Specify Target Oracle Server is not the Oracle home user, you will be asked to provide a password to access the target Oracle home. Applicable to Oracle 12c and later versions.