QUOTE (Susja @ Apr 21 2017, 01:08 PM)
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?
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