Script to monitor RMAN progress

select  sid,  start_time,  totalwork
  sofar,  (sofar/totalwork) * 100 pct_done
from    gv$session_longops where
   totalwork > sofar AND    opname NOT LIKE '%aggregate%'
AND    opname like 'RMAN%';

Comments

Post a Comment

Popular posts from this blog

Bare Metal Restore Procedure for Compute Nodes on an Exadata Environment

Remove the Failed Database Server from the Cluster 1. Disable the listener that runs on the failed database server: [oragrid@surviving ~]$ srvctl disable listener -n dm01db01 [oragrid@surviving ~]$ srvctl stop listener -n dm01db01 PRCC-1017 : LISTENER was already stopped on dm01db01 PRCR-1005 : Resource ora.LISTENER.lsnr is already stopped [oragrid@surviving ~]$ 2. Delete the Inactive Instance using DBCA via ( Instance management ) and Oracle Home from the Oracle inventory: [oracle@surviving ~]$ dbca ( vncserver ) [oracle@surviving ~]$ cd $ORACLE_HOME/oui/bin [oracle@surviving bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1 "CLUSTER_NODES=dm01db02" Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB.   Actual 23984 MB    Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /u01/app/oraInventory 'UpdateNodeList' was successful. [or...
Read more

How to Downgrade 19C Grid Infrastructure to 12.1.0.2

ENVIRONMENT DETAILS: 2 NODES – ambeth01 and ambeth02 Grid owner – oragrid 19C ORACLE_HOME(current) – > /u01/app/19.0.0.0/grid 12C ORACLE_HOME (old) -> /u01/app/12.1.0.2/grid/bin Check the current grid version:( check on both the nodes) [oragrid@ambeth01 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [oragrid@ambeth01 ~]$ crsctl query crs softwareversion -all Oracle Clusterware version on node [ambeth01] is [19.0.0.0.0] Oracle Clusterware version on node [ambeth02] is [19.0.0.0.0] [oragrid@ambeth01 ~]$ 1. As the first step for downgrade, remove the MGMTDB. Move the MGMTDB database on node1, if its running on node2. [oragrid@ambeth01 ~]$ ps -ef|grep pmon oragrid    952 21344  0 19:38 pts/0    00:00:00 grep --color=auto pmon oragrid   8102     1  0 14:32 ?        00:00:02 asm_pmon_+ASM1 oragrid   8609   ...
Read more