Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Duration of Backup
Susja
post Apr 21 2017, 12:08 PM
Post #1


Member
**

Group: Members
Posts: 15
Joined: 20-March 17
Member No.: 51,849



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
Go to the top of the page
 
+Quote Post
mkumar
post Apr 24 2017, 03:46 PM
Post #2


Newbie
*

Group: Members
Posts: 2
Joined: 24-April 17
Member No.: 51,928



QUOTE (Susja @ Apr 21 2017, 01:08 PM) *
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
Go to the top of the page
 
+Quote Post
Susja
post Apr 25 2017, 12:04 PM
Post #3


Member
**

Group: Members
Posts: 15
Joined: 20-March 17
Member No.: 51,849



All set
Thanks
Go to the top of the page
 
+Quote Post
Thrall
post May 4 2017, 12:47 AM
Post #4


Newbie
*

Group: Members
Posts: 1
Joined: 28-April 17
Member No.: 51,943



QUOTE (Susja @ Apr 25 2017, 01:04 PM) *
All set
Thanks


Same here thanks.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 16th August 2017 - 08:21 AM