Let's discuss how Zaffre can take advantage of the Instant Recovery option, which takes the snapshot of the latest backup image with the latest transaction log and restores it to your production oracle database server. The database runs off the Rubrik storage. This makes the recovery operation instantaneous, and the services to your customers can be restored with minimum downtime.
To get started on the Instant Recover operation, first, you need to simulate database instances down by shutting down the database.
Double-click the Putty shortcut on the Desktop. Select ora12c-prod.rubrik.lab as the host and click Open.
On the SSH Window, log in with the following credentials:
Username: oracle
Password: oracle
Launch SQLPLUS by entering:
On the SQL> Prompt, run the following SQL command:
Head back to RSC. Click (...) ellipse, and select Refresh. The database should disappear from the page.
NOTE: It can take a couple of minutes for the database to completely shut down and be available for recovery.
Now you will initiate the instant recovery of your oracle production database. First, navigate to Inventory > All > Oracle Databases.
Navigate to ora12c-prod. From the side panel, select the Relic filter for Status. orcl db will now be available under the ora12c-prod host. Select the most recent day with green checks in the calendar. Move the slider close to the last log time. Click (...) ellipse and select Recover. On the pop-up, select Instantly Recover and then click NEXT. Click RECOVER.
NOTE: If you see the error message like in the image below, then wait for a minute before retrying instant recovery
Click EVENTS from the left middle panel. Verify on the Events page that the Clone operation has been completed.
NOTES:
It takes about a minute for the Events page to show the instant recovery operation.
It takes about five minutes for the instant recovery operation to finish.
Navigate to Live Mounts from the top menu. Select Oracle Database. Ensure that orcl is listed as a live mount.
Navigate back to the SSH terminal for ora12c-prod.
Launch SQLPLUS by entering:
On the SQL> Prompt, run the following SQL command:
Recover the local database by running the move_datafiles.sql file.
You can now verify the location of the copied data is back to your storage.
Rubrik’s Instant Recovery feature extends beyond recovery use cases. The feature enables easy, accelerated secondary environments for running different queries without impacting production.
You now have all the recovery options in your armor to ensure your critical data is always available!
Congratulations on completing the migration of your Oracle database along with MS SQL database to RSC!
