Jump to content
Susja

Duration of Backup

Recommended Posts

Hello,

My system is running Full Backup and incremental backup to external disc.

I want to setup another Backup process and I don't want to overlap.

My goal is to check when current Backup starts and ends.

I ran this query:

select * from v$rman_backup_job_details;

or this one:

select * from v$rman_backup_subjob_details;

The problem is that it does not tell me when it starts / ends in timestamp format, it states like this: START_TIME and END_TIME 18-APR-17.

My question: how could I get start and end time of backup process in hours or minutes?

 

Thanks

Share this post


Link to post
Share on other sites
Hello,

My system is running Full Backup and incremental backup to external disc.

I want to setup another Backup process and I don't want to overlap.

My goal is to check when current Backup starts and ends.

I ran this query:

select * from v$rman_backup_job_details;

or this one:

select * from v$rman_backup_subjob_details;

The problem is that it does not tell me when it starts / ends in timestamp format, it states like this: START_TIME and END_TIME 18-APR-17.

My question: how could I get start and end time of backup process in hours or minutes?

 

Thanks

 

either set nls_date_format = 'DD-MON-YYYY HH24:MI:SS' as session level or while doing select, do to_char(START_TIME,'DD-MON-YYYY HH24:MI:SS') START_TIME, to_char(END_TIME,'DD-MON-YYYY HH24:MI:SS') END_TIME

Share this post


Link to post
Share on other sites
On 4/25/2017 at 1:47 AM, mkumar said:

 

either set nls_date_format = 'DD-MON-YYYY HH24:MI:SS' as session level or while doing select, do to_char(START_TIME,'DD-MON-YYYY HH24:MI:SS') START_TIME, to_char(END_TIME,'DD-MON-YYYY HH24:MI:SS') END_TIME Hello,

My system is running Full Backup and incremental backup to external disc.

I want to setup another Backup process and I don't want to overlap.

My goal is to check when current Backup starts and ends.

I ran this query:

select * from v$rman_backup_job_details;

or this one:

select * from v$rman_backup_subjob_details;

The problem is that it does not tell me when it starts / ends in timestamp format, it states like this: START_TIME and END_TIME 18-APR-17.

My question: how could I get phen375 discount and start and end time of backup process in hours or minutes?

 

7

Thank you so much for the query. My problem is also solved.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×