Re: sql to check when a last expdp backup was done

From: Ryan January <rjjanuary_at_multiservice.com>
Date: Wed, 21 Aug 2013 15:42:32 -0500
Message-ID: <52152638.4030405_at_multiservice.com>

In a strict sense, a database export isn't considered a backup. As far as I'm aware, there is no method of directly determining when the last export was taken and exactly what schemas/objects were included within it.

If you were looking to persist this data, one option would be to audit based. You may take a look at "Configuring a Unified Audit Policy for Oracle Data Pump" to see if it will meet your needs.

http://docs.oracle.com/cd/E16655_01/network.121/e17607/audit_config.htm#CHDFDCFC

On 08/21/2013 01:43 PM, Praveen Ramanan wrote:
> This is my first post in Oracle-l Freelists group. I have been following
> this list for quite some time and have learnt a lot about
> how dba's handle their day to day tasks. Thank You !!
> I have a simple dashboard which lists all the backups taken (for the
> various instances we have), their type and when a successful backup has
> been completed.
> This is reasonably straighforward to get rman backup details. However for
> few instances i also run a full expdp backup and i would like to check when
> a last expdp was taken.
>
> This is what i currently have
> select opname,target_desc,start_time,elapsed_seconds,message from
> v$session_longops
> where OPNAME='NAME OF JOB' order by start_time desc
> (this expdp backup is scheduled through db control)
>
> While this gives me the right results most times, sometimes it does not. is
> there another way to get this information?
>
> The database version is Oracle 11gR2 .
>
> Thanks.
>

-- 


------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email..
------------------------------------------------------------------

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 21 2013 - 22:42:32 CEST