Install SQL Server, Dbvisit Software, Create Dynamic Groups and Policies

Install SQL Server on both machines

Follow this guide to install SQL Server on Linux: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver16

Install Dbvisit Software

To install Dbvisit Software, please follow this guide: https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3242000447/Installing+Standby+Multiplatform

The most important part for disaster recovery in OCI FSDR environment for SQL Server is a working Command Line Interface, which is available from version 11.7.

Create Dynamic Groups and Add Policies

In order FSDR could start shell and other scripts on OCI machines, we need to create a dynamic group and grant policies to that group to be able to do so. Follow this guide to properly setup Dynamic Groups and Policies: https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3674832901/3.+Create+Dynamic+Group+and+Add+Policies

Create Prerequisite Objects

Before we create DR groups, we need to prepare following objects for further use:

• create a bucket for FSDR log storage

• create a volume group to allow storage synchronization between regions/availability domains

https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3734011918/Create+Prerequisite+Objects