Re: RMAN

  • From: Jost, Jörg <Joerg.Jost@xxxxxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Sun, 28 Aug 2011 16:34:13 +0200

Hi,

if it was a Job, there is an entry in dba_scheduler_job_log.

Bye

Joerg

Am 26.08.2011 um 11:31 schrieb "Niall Litchfield" <niall.litchfield@xxxxxxxxx>:

> If it really happened at 12:00 am then it was almost certainly scheduled by a 
> human via a scheduling tool. Most of these will have log files (the difficult 
> bit will be working out whether it was cron, dba_scheduler, etc etc.) The 
> listener.log should tell you what program was used to connect at that time as 
> well. 
> 
> On Fri, Aug 26, 2011 at 10:20 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> 
> wrote:
> The issue happened 23 of August at 12:00 am. dba_datapump_jobs returns no 
> rows.
> 
> 
> On Fri, Aug 26, 2011 at 11:19 AM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> 
> wrote:
> Hi,
> 
> If the datapump job is still running you can attach to it using expdp or 
> impdp (depending what is happening).
> 
> The dba_datapump_jobs view will give you the information needed to connect.
> 
> Regards,
> 
> 
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ---
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
> Behalf Of mek s
> Sent: vrijdag 26 augustus 2011 11:11
> To: Niall Litchfield
> Cc: ORACLE-L
> Subject: Re: RMAN
> 
> when datapump starts I can see DM processes in alert log file, like this:
> 
> DM00 started with pid=53, OS id=18616, .....
> 
> How can I know at which time these processes finish? I cannot see something 
> like DM00  finished ....
> 
> I want to know when datapump started and finished...
> On Fri, Aug 26, 2011 at 11:08 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> 
> wrote:
> No they are not in use,
> Thank you
> 
> On Fri, Aug 26, 2011 at 11:07 AM, Niall Litchfield 
> <niall.litchfield@xxxxxxxxx> wrote:
> are transportable tablespaces in use IIRC they use data pump. 
> 
> On Fri, Aug 26, 2011 at 9:10 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> wrote:
> I know That RMAN must access to V$ and GV$ views to extract some information 
> useful for backup process BUT, is RMAN using Data Pump Workers for that?
> Thank you,
> S
> 
> 
> 
> 
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> 
> 
> 
> 
> -- 
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
  • Follow-Ups:

Other related posts: