Re: sql to check when a last expdp backup was done
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 22 Aug 2013 14:58:13 -0700 (PDT)
Message-ID: <1377208693.82222.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
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.
Date: Thu, 22 Aug 2013 14:58:13 -0700 (PDT)
Message-ID: <1377208693.82222.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 22 2013 - 23:58:13 CEST