Oracle Secondary Reporting Environment with Clone

After Live Mount, let's discuss how Zaffre can take advantage of the Clone option, which creates a secondary Oracle environment for running other jobs, such as reporting jobs, without affecting your production environment.

Clone

To get started on the restore operation, first, navigate to Inventory > All > Oracle Databases.

Access Oracle Databases

• Navigate to ora12c-prod > orcl. Select the most recent day with green checks in the calendar.

• Move the slider close to the last log time. Go to the latest backup for the day, click (...) ellipse and select Recover.

• On the pop-up, select Clone and then click NEXT.

• Choose ora12c-dev as the compatible host and click NEXT.

• Leave everything as default and click Clone.

Clone

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 clone operation.

2. It takes about five minutes for the clone operation to finish.

Events page

Verify Clone

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> select name from v$datafile;

Prod Output

Repeat the same steps for ora12c-dev.rubrik.com.

Dev Output

The output on the secondary host ora12c-dev indicates data files are identical to the production database.

Rubrik’s Clone feature extends beyond recovery use cases. The feature enables easy, accelerated secondary environments for running different queries without impacting production.