Re: [Veritas-bu] RMAN backup status
2009-01-13 20:29:27
Hi,
R u looking this kind of report of All the RMan's backup status.
Database DBID Latest Backup Level MB HRS MIN SEC Latest
Validate HRS MIN SEC
--------- ---------- ------------------ ----- -------- --- --- ---
------------------ --- --- ---
WWSN 2022953664 13-JAN-09 19:02:02 1 53 0 1 26
13-JAN-09 23:27:12 0 1 56
DSSPROD 1145175061 13-JAN-09 19:05:29 1 706 0 1 44
13-JAN-09 23:32:02 0 3 38
BOPROD 1234888561 13-JAN-09 19:08:38 1 25 0 0 15
13-JAN-09 23:35:36 0 2 17
BOPROD6 228470387 13-JAN-09 19:10:13 1 11 0 0 10
13-JAN-09 23:45:22 0 8 32
NCDREPOS 4195811604 13-JAN-09 19:12:28 1 1,311 0 1 57
13-JAN-09 23:48:54 0 2 21
NCDWHSE 746588727 13-JAN-09 19:20:10 1 709 0 2 30
13-JAN-09 23:52:39 0 2 38
CATDB 2208510188 13-JAN-09 19:21:43 1 27 0 0 10
13-JAN-09 23:54:02 0 0 7
TSPROD 1524914503 13-JAN-09 19:29:15 1 115 0 6 19
13-JAN-09 23:59:19 0 4 9
SMKTPROD 3566943480 13-JAN-09 19:31:48 1 20 0 0 8
14-JAN-09 00:00:53 0 0 24
NBRX 3650092111 13-JAN-09 20:19:37 0 4,016 0 19 25
13-JAN-09 23:04:30 0 4 19
ACWW 435147010 13-JAN-09 20:30:44 1 27 0 0 24
13-JAN-09 23:19:09 0 18 44
NCLA 994469313 13-JAN-09 20:45:47 1 66 0 0 34
13-JAN-09 23:04:17 0 3 57
About this report:
=================================
1. Extracted from rman.rc_rman_status in catdb database
2. Scheduled to be sent daily from ctlsgbiz04.ctl.creaf.com server using
catdb rman_bkp_status.sh cron job
3. Level 0 means full backup; level 1 means incremental backup
4. Please check Latest Backup time stamp for each database to confirm
backup successfully run for each database
=================================
Please let me know
With Warm Regards
=-=-=-=-=-=-=-=-=-=-=-=-=-
Harpreet Singh Chana
Phone : (O) 6895 - 4326
Fax : (O) 6895 - 4991
=-=-=-=-=-=-=-=-=-=-=-=-=-
Notice
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying or distribution of the message, or
any action taken by you in reliance on it, is prohibited and may be
unlawful. If you have received this message in error, please delete it
and contact the sender immediately. Thank you.
nbujohnson
<netbackup-forum@
backupcentral.com To
> VERITAS-BU AT mailman.eng.auburn DOT edu
Sent by: cc
veritas-bu-bounce
s AT mailman.eng DOT aub
Subject
urn.edu [Veritas-bu] RMAN backup status
01/14/2009 02:49
AM
Please respond to
VERITAS-BU@mailma
n.eng.auburn.edu
Thanks for the script Carl, but this is also a client based script which i
have to schedule on each db client .what i am looking here is a script
which i can scedule on my matser & which report all the rman failures
only,basically i need a single report which can be easily checked for all
the rman failures.
Thanks,
John
+----------------------------------------------------------------------
|This was sent by nbujohnson AT googlemail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
ForwardSourceID:NT000B6BD2
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|