Instant Recovery

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.

Shutdown database

Double-click the Putty shortcut on the Desktop. Select ora12c-prod.rubrik.lab as the host and click Open.

Putty

On the SSH Window, log in with the following credentials:

• Username: oracle

• Password: oracle

Launch SQLPLUS by entering:

# export ORACLE_SID=orcl

# sqlplus / as sysdba

On the SQL> Prompt, run the following SQL command:

SQL> @/home/oracle/move_datafiles.sql
SQL> shutdown immediate;
SQL> startup mount exclusive restrict
SQL> drop database;
SQL> exit

Head back to RSC. Click (...) ellipse, and select Refresh.

NOTE: It can take a couple of minutes for the database to completely shut down and be available for recovery.

Refresh the page after a couple of minutes. You should see Relic next to Snapshots.

Instant Recovery

Now you will initiate the instant recovery of your oracle production database. First, navigate to Inventory > All > Oracle Databases.

Access 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.

Instant Recovery

NOTE: If you see the error message like in the image below, then wait for a minute before retrying instant recovery

Caution message

Click EVENTS from the left middle panel. Verify on the Events page that the Clone operation has been completed.

NOTES:

1. It takes about a minute for the Events page to show the instant recovery operation.

2. 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.

Verify Live Mount

Verify Instant Recovery

Navigate back to the SSH terminal for ora12c-prod.

Launch SQLPLUS by entering:

# export ORACLE_SID=orcl

# sqlplus / as sysdba

On the SQL> Prompt, run the following SQL command:

SQL> select name from v$datafile;

Data on Rubrik!

Recover the local database by running the move_datafiles.sql file.

SQL> @/home/oracle/move_datafiles_back.sql

Move data

You can now verify the location of the copied data is back to your storage.

SQL> select name from v$datafile;

Data on Prod!

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!