Migration Prerequisites: Source Steps – Preparing the On-Premises Oracle Database….

Migration prerequisites can be classified into source and target steps.

The high-level source steps are mentioned below,

  • Create SSH keys.
  • Check the database character set.
  • Provision the database instance.

Some migration approaches require the source databases to be down until target database is completely migrated. Several migration methods support different source and destination DB versions. In some migration methods, you need to make sure source and destination character sets are compatible

In order to prepare the source database for migration, these following points should be considered by you,

  • Prepare the database as per your migration approach.
  • Perform a data dump export or back up data on local storage.
  • Transfer the data to Oracle Cloud.

Over OCI, object storage can be used. The Oracle Cloud Infrastructure Object Storage service is an Internet-scale, high-performance durable storage platform that offers reliable and cost-efficient data durability.

The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos.

Data is managed as objects and not as files or blocks. It is not managed via any storage protocol but rather uses standard HTTP methods, such as HTTP GET, HTTP PUT methods.

Moreover, with object Storage, you can safely and securely store or retrieve data directly from the internet or you can do it from within the cloud platform using multiple management interfaces that let you easily manage storage at scale.

One last thing to mention about Object storage is, that object storage is completely independent of the a compute server and is a regional service. So as long as you have the object storage endpoints and relative authorization, you can access the data from anywhere.

In the next post, we shall know about the block volume storage.