Re: sql to check when a last expdp backup was done
- From: Yong Huang <yong321@xxxxxxxxx>
- To: "pramanan@xxxxxxxxx" <pramanan@xxxxxxxxx>
- Date: Thu, 22 Aug 2013 14:58:13 -0700 (PDT)
As Ryan says, "a database export isn't considered a backup". But if you use
RAC, most of the time a data pump job leaves a few lines in alert.log related
to adding and, at the end, deleting a service named like
'SYS$SYS.KUPC$C_1_20130822161301*'. This may be captured in
dba_hist_service_name. It's not reliable and doesn't work on single node
databases. Finding SQLs in dba_hist_sql* and v$active_session_history for SQL
text like '%sys.kup%' may be more reliable.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
