INSPIRED ORACLE DATABASE RMAN RESTORE SHELL SCRIPT FOR MONITORING THE ETA

This script is written after we failed to report an approximate progress of restore to customer after a database failure. This challenge inspired me to write this script. I am not a programmer but i used to write scripts for my personal use. So this magic script would give an approximate progress of the database restore and report you in equal intervals with real time statistics of restore on the putty screen. Use it at your own risk because of loops used. Test before you use it and modify the script according to your needs.Hope this script is useful!

Customer was asking an ETA after database failure

  • Database failed time – 05:00 AM UTC
  • Database restore ETA – ??? (Use the script below)

Sample output of the script which shows realtime statistics of the rman restore

Sample output of the restore after completion !

Follow the below link to get the magic script

https://github.com/kishan0426/Rman-restore-prorgess-magic-script-oracle

Hit like if you like it!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s