sql to check when a last expdp backup was done
From: Praveen Ramanan <pramanan_at_gmail.com>
Date: Wed, 21 Aug 2013 13:43:32 -0500
Message-ID: <CAJXKVHEEvHxhxH=aT_EVwedcsNA4CA10KW24ihCrUTjoufyBdQ_at_mail.gmail.com>
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.
Date: Wed, 21 Aug 2013 13:43:32 -0500
Message-ID: <CAJXKVHEEvHxhxH=aT_EVwedcsNA4CA10KW24ihCrUTjoufyBdQ_at_mail.gmail.com>
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.
-- Teamwork is the fuel that allows common people to produce uncommon results -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 21 2013 - 20:43:32 CEST