Home » RDBMS Server » Backup & Recovery » RMAN job completed with warnings (10.2.0.3)
RMAN job completed with warnings [message #315084] Fri, 18 April 2008 22:35 Go to next message
cmerry
Messages: 109
Registered: November 2005
Location: Idaho
Senior Member
When querying V$RMAN_BACKUP_JOB_DETAILS, the status column is returning "COMPLETED WITH WARNINGS". Is there any way to view these warnings in 10.2.0.3? For example:
COL STATUS FORMAT a9
COL hrs    FORMAT 999.99
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
----------- ------------- --------- -------------- -------------- -------
       6080 DB FULL       COMPLETED 04/08/08 23:29 04/08/08 23:37     .14
                           WITH WAR
                          NINGS

Thanks!
Re: RMAN job completed with warnings [message #315098 is a reply to message #315084] Sat, 19 April 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
V$RMAN_OUTPUT if your job is not too old as the view only contains the last 32768 lines of all RMAN job outputs.

Regards
Michel
Re: RMAN job completed with warnings [message #315135 is a reply to message #315084] Sat, 19 April 2008 07:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
For future backups, you should consider generating a shell script log or an RMAN log each time your RMAN job runs.
Re: RMAN job completed with warnings [message #315170 is a reply to message #315135] Sat, 19 April 2008 11:24 Go to previous message
cmerry
Messages: 109
Registered: November 2005
Location: Idaho
Senior Member
ebrian wrote on Sat, 19 April 2008 05:05
For future backups, you should consider generating a shell script log or an RMAN log each time your RMAN job runs.

That's a terrific idea, great minds think alike I suppose. I currently have a shell script log, but I am in the process of incorporating an email notification, generated in PL/SQL, that includes the details of the backup. Rather than messing with the OS file, I just wanted to use V$ views to gather the information. I knew there was a view, I just missed V$RMAN_OUTPUT...it seems so obvious. Thanks for the help.
Previous Topic: Shut down immediate is taking too much time
Next Topic: RMAN-06556: datafile 1 must be restored from backup older than scn
Goto Forum:
  


Current Time: Tue Dec 06 10:28:27 CST 2016

Total time taken to generate the page: 0.13658 seconds