Home » RDBMS Server » Backup & Recovery » Rman database backup failed (Oracle 11.2.0.3.0,linux 2.6)
Rman database backup failed [message #626783] Sun, 02 November 2014 21:18 Go to next message
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
Regards,

[Updated on: Sun, 02 November 2014 21:21]

Report message to a moderator

Re: Rman database backup failed [message #626794 is a reply to message #626783] Mon, 03 November 2014 00:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check your backup log or V$RMAN_OUTPUT if you didn't restart the database since the backup or RC_RMAN_OUTPUT if you use a RMAN catalog database.
If you have none, you have no information.

Re: Rman database backup failed [message #626795 is a reply to message #626794] Mon, 03 November 2014 00:32 Go to previous message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Thanks Michel
Previous Topic: invalid objects after db restore
Next Topic: OS SNAP for Oracle DB in NOARCHIVE LOG MODE.
Goto Forum:
  


Current Time: Fri Mar 29 09:00:35 CDT 2024