| Rman database backup failed [message #626783] |
Sun, 02 November 2014 21:18  |
 |
oracle11
Messages: 29
Registered: October 2014
Location: India
|
Junior Member |
|
|
Hi,
I am able to find Rman database and archivelog backup status by using the below query.Could you tell me how to find
for what reason the database backup got failed.
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
78531 ARCHIVELOG COMPLETED 11/01/14 09:53 11/01/14 09:58 .08
78536 ARCHIVELOG COMPLETED 11/01/14 13:53 11/01/14 14:02 .15
78541 ARCHIVELOG COMPLETED 11/01/14 17:53 11/01/14 17:58 .07
78546 DB FULL COMPLETED 11/01/14 21:48 11/02/14 01:47 3.99
78548 ARCHIVELOG COMPLETED 11/01/14 21:55 11/01/14 22:01 .10
78556 ARCHIVELOG COMPLETED 11/02/14 01:56 11/02/14 02:06 .16
78561 ARCHIVELOG COMPLETED 11/02/14 05:54 11/02/14 06:00 .09
78566 ARCHIVELOG COMPLETED 11/02/14 09:55 11/02/14 09:59 .07
78571 ARCHIVELOG COMPLETED 11/02/14 13:55 11/02/14 14:00 .08
78576 ARCHIVELOG COMPLETED 11/02/14 17:55 11/02/14 18:00 .08
78581 DB FULL FAILED 11/02/14 21:19 11/03/14 03:17 5.96
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
78583 ARCHIVELOG COMPLETED 11/02/14 21:56 11/02/14 22:03 .12
78588 DB FULL FAILED 11/02/14 22:16 11/03/14 03:35 5.31
78590 ARCHIVELOG COMPLETED 11/03/14 01:58 11/03/14 02:05 .12
[Updated on: Sun, 02 November 2014 21:21] Report message to a moderator |
|
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
