SUMMARY

Creating a normal (binary) database backup with nhSaveDb, or restoring a normal backup with nhLoadDb, is a time consuming process that gives little indication of whether the process is running or in a hung state. Standard output to screen does not update until the process has completed or has failed, which can legitimately take several hours. Customers would like a way to determine progress on a backup or restore process.

INSTRUCTIONS

1. While a normal backup or restore is in progress, open a new command line interface window.
   
   
2. Start sqlplus
   
   In Windows:  sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%
   In Solaris/Linux:  sqlplus $NH_USER/[email protected]$NH_DB_CONNECT_STRING
   
   
3. Enter the following query to check progress of the backup or restore.
   
   

   SELECT sid, serial#, context, sofar, totalwork,
   round(sofar/totalwork*100,2) “% Complete”
   FROM v$session_longops
   WHERE totalwork 0
   and upper(opname) like ‘%RMAN%’
   and sofar totalwork;

 The table below shows an example of the output the query might display.

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: