EXPDP/IMPDP backup information

Adityanath Dewoolkar

Dear Experts,

Oracle should collect backup information for every data pump job started on the database.

We always say datapump is server side process as it will always make use of directories on server side. So I guess this is possible & helpful for DBA's to find out all datapump backup details in single query.

We can have following views.

EXPDP_JOB_DETAILS

IMPDP_JOB_DETAILS

Each of which will have following columns:

1. Owner:  Name of DB user who initiated this job

2. Directory: Name of the directory

3. Dumpfile: Name of the dumpfile

4. Logfile: Name of the logfile

4. Status: Status of job => Completed, Failed, Completed with errors, Completed with warnings, Running, Killed, Resumable_wait

5. Start_time: Start time of the job

6. End_time: End time of the job

7. Degree: Parallel degree used

7. Clause: This can contain expdp/impdp command details. (FULL, SCHEMAS, Tables etc)

This will help a lot in database systems with lot of datapump operations on daily basis. Also DBA's can query these views to get status of the job instead of going through every logfile.

Please comment!

Regards,

Adi

Mike Kutz

The information of "what backups have been done" is already being recorded in the RMAN Catalog (or Control Files)

"DataPump" files are NOT backups and do not need this level of recording.

IMHO: adding "A  Pre-Process and Post-Process steps for DataPump" to achieve your goal would be a more suitable method.

My $0.02

MK