tag:blogger.com,1999:blog-4096575.post4996103411455801109..comments2024-03-19T03:20:26.726-04:00Comments on The Arup Nanda Blog: Tool to Present a Consolidated View of the Status of RMAN BackupsArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger52125tag:blogger.com,1999:blog-4096575.post-12464940850202450592013-05-23T02:49:49.039-04:002013-05-23T02:49:49.039-04:00Manish,
From mgmt$ha_backup or from other reposit...Manish,<br /><br />From mgmt$ha_backup or from other repository views , are you able to get the incremental level say 0 or 1 of the backup taken?<br /><br />baskar.l<br />Baskarhttps://www.blogger.com/profile/15416034348562107938noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-4489287670987048432013-04-17T11:34:12.926-04:002013-04-17T11:34:12.926-04:00I had two combinations , full and incremental back...I had two combinations , full and incremental backups , can you pls help in modifying the script Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-45451661778071248672012-11-15T05:29:15.140-05:002012-11-15T05:29:15.140-05:00Hi Manish,
sure, it's similar but in this case...Hi Manish,<br />sure, it's similar but in this case I have some limitations:<br />1) Can you see only the last backup full or archive but not all the history.<br />2) You don't have a repository where you can see all your backups for servers.<br />thanks.<br />Ciao<br />Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-63850258076393084272012-11-14T11:50:09.876-05:002012-11-14T11:50:09.876-05:00If you are using OEM to manage the backups follo. ...If you are using OEM to manage the backups follo. query will provide the similar output as Arunp's report does.<br /><br />select DATABASE_NAME, host, status, to_char(start_time,'dd-MON-yyyy hh24:mi') start_time,<br /> to_char(end_time,'dd-MON-yyyy hh24:mi') end_time, input_type, output_device_type<br />from mgmt$ha_backup<br />where END_TIME between trunc(SYSDATE) -1 and SYSDATE<br />order by host, database_nameManish Shahnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-16412187904072490282012-10-25T02:43:44.346-04:002012-10-25T02:43:44.346-04:00Hi sangeeth,
can you post some examples, please?
C...Hi sangeeth,<br />can you post some examples, please?<br />Ciao<br />AlbertoAlbertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-4336407654285519412012-10-24T16:04:12.108-04:002012-10-24T16:04:12.108-04:00Arup
I see some mismatch between the data in ...Arup<br /><br />I see some mismatch between the data in V$rman views in the database and the data in rman catalog table/views.What would be the reason for this behaviour.<br /><br />Regards<br />sangeethAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-30000625613143764422012-06-19T11:58:35.456-04:002012-06-19T11:58:35.456-04:00@Anita - Ok, send me a mail so I can send you the ...@Anita - Ok, send me a mail so I can send you the scripts.Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-58808787509885447422012-06-19T11:56:30.927-04:002012-06-19T11:56:30.927-04:00Its not working when I change it to 3,4 or 5.. I g...Its not working when I change it to 3,4 or 5.. I guess something's wrongAnitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-49538749758458012032012-06-19T11:50:08.006-04:002012-06-19T11:50:08.006-04:00@Anita - now I've shared my mail account in gm...@Anita - now I've shared my mail account in gmail.<br />My question is how many days back your second script works?<br />If you change 7 to 6 or 5 days work?Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-2458414404509925372012-06-19T11:28:30.250-04:002012-06-19T11:28:30.250-04:00I didnt understand about the question about script...I didnt understand about the question about scripts.<br /><br />I have only a gmail account. I searched for your email in profile, but I didnt get.<br /><br />Can you share your email idAnitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-83442709369409403442012-06-19T10:09:41.896-04:002012-06-19T10:09:41.896-04:00@Anita - How many days ago you 2nd script works?
y...@Anita - How many days ago you 2nd script works?<br />yes, if you want, can you send me a mail so i send the scripts modified?<br />Do you have a linkedin account or twitter?Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-34687532358952805492012-06-19T09:45:27.250-04:002012-06-19T09:45:27.250-04:00Glad to hear.
Yes the output of second script is ...Glad to hear.<br /><br />Yes the output of second script is blank<br /><br />Can you give that modified script?Anitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-977569091402798512012-06-19T09:16:13.224-04:002012-06-19T09:16:13.224-04:00@Anita - sure, you're using the right settings...@Anita - sure, you're using the right settings, you have modified from 1 day to 7 days this parameter, that's right, is the output of 2nd script blank?<br />Sure, it's possible have the type of backup, I've modified a little bit the Arup's script.Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-36421927436858500602012-06-19T08:53:29.260-04:002012-06-19T08:53:29.260-04:00Below are the queries and their respective output
...Below are the queries and their respective output<br /><br />Report for the backup that ran in the past 24 hours<br /><br />I used the same PL/SQL query which Arup had posted in the blog<br /><br />DB Name Start Time End Time Status Time Tak Output S Type<br />-------- ------------------ ------------------ -------- -------- -------- --------<br />AAAAAA 2012-06-17 13:06:1 2012-06-17 13:06:3 COMPLETE 00:00:13 656.62 DISK<br />AAAAAA 2012-06-17 22:02:5 2012-06-17 22:09:4 COMPLETE 00:06:56 15.24 DISK<br /><br />2nd Report for full backups that didnt run for past 7 days<br /><br />In the same query I just changed<br /><br />end_time > sysdate - p_days<br /><br />to<br />end_time - sysdate=7<br /><br />I am not sure if these are right. Also is there any way I can get whether they are Full,incremental or archive backups?Anitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-33581904044462838382012-06-18T09:24:55.954-04:002012-06-18T09:24:55.954-04:00Last 3 days:
DB Name Start Time End ...Last 3 days:<br /><br />DB Name Start Time End Time Status Time Tak Output Size Type BackupType<br />------------ ------------------ ------------------ -------- -------- -------- -------- ----------<br />AAA 15-06-2012 16:00 15-06-2012 16:39 COMPLETE 00:39:26 XXXXXXX DISK DB FULL <br />AAA 15-06-2012 18:00 15-06-2012 18:01 COMPLETE 00:00:37 XXXXXXX DISK ARCHIVELOG<br />AAA 15-06-2012 22:00 15-06-2012 22:01 COMPLETE 00:01:13 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 02:00 16-06-2012 02:01 COMPLETE 00:00:52 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 06:00 16-06-2012 06:01 COMPLETE 00:00:56 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 06:00 16-06-2012 06:39 COMPLETE 00:38:37 XXXXXXX DISK DB FULL <br />AAA 16-06-2012 10:00 16-06-2012 10:01 COMPLETE 00:00:39 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 14:00 16-06-2012 14:01 COMPLETE 00:00:37 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 16:00 16-06-2012 16:38 COMPLETE 00:38:24 XXXXXXX DISK DB FULL <br />AAA 16-06-2012 18:00 16-06-2012 18:00 COMPLETE 00:00:24 XXXXXXX DISK ARCHIVELOG<br />AAA 16-06-2012 22:00 16-06-2012 22:01 COMPLETE 00:00:42 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 02:00 17-06-2012 02:01 COMPLETE 00:00:47 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 06:00 17-06-2012 06:00 COMPLETE 00:00:23 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 10:00 17-06-2012 10:00 COMPLETE 00:00:31 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 14:00 17-06-2012 14:01 COMPLETE 00:00:26 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 16:00 17-06-2012 16:36 COMPLETE 00:36:32 XXXXXXX DISK DB FULL <br />AAA 17-06-2012 18:00 17-06-2012 18:00 COMPLETE 00:00:21 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 22:00 17-06-2012 22:00 COMPLETE 00:00:30 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 02:00 18-06-2012 02:01 COMPLETE 00:00:38 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 06:00 18-06-2012 06:00 COMPLETE 00:00:33 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 14:00 18-06-2012 14:02 COMPLETE 00:01:35 XXXXXXX DISK ARCHIVELOG<br /><br />I have the same output in the last 3 days in these 2 scripts , how do you get the 2nd list of databases didn't run? <br />Which script you tried to change?<br />the views or the final?Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-61591690012352055942012-06-18T09:24:37.105-04:002012-06-18T09:24:37.105-04:00@Anita - I use the same script, it's egual or ...@Anita - I use the same script, it's egual or more similiar and reproduce this output in my case:<br /><br />Last 1 day:<br /><br />DB Name Start Time End Time Status Time Tak Output Size Type BackupType<br />------------ ------------------ ------------------ -------- -------- -------- -------- ----------<br />AAA 17-06-2012 16:00 17-06-2012 16:36 COMPLETE 00:36:32 XXXXXXX DISK DB FULL <br />AAA 17-06-2012 18:00 17-06-2012 18:00 COMPLETE 00:00:21 XXXXXXX DISK ARCHIVELOG<br />AAA 17-06-2012 22:00 17-06-2012 22:00 COMPLETE 00:00:30 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 02:00 18-06-2012 02:01 COMPLETE 00:00:38 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 06:00 18-06-2012 06:00 COMPLETE 00:00:33 XXXXXXX DISK ARCHIVELOG<br />AAA 18-06-2012 14:00 18-06-2012 14:02 COMPLETE 00:01:35 XXXXXXX DISK ARCHIVELOG<br /><br />....Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-85002720461420605172012-06-18T06:40:13.094-04:002012-06-18T06:40:13.094-04:00@Alberto:
I used the same script given in this bl...@Alberto:<br /><br />I used the same script given in this blog. Tried modifying it. But ended up in getting it messed. Can you help with thisAnitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-47064510016800337152012-06-18T03:53:51.507-04:002012-06-18T03:53:51.507-04:00@Anita - I now understand the issue, doesn't m...@Anita - I now understand the issue, doesn't matter the schedule or something else.<br />Very strange...can you post script 1 or 2 or both for small example ?could be help.Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-44282780527899669412012-06-15T21:52:29.000-04:002012-06-15T21:52:29.000-04:00@Alberto: The backups are scheduled from TSM.
But...@Alberto: The backups are scheduled from TSM.<br /><br />But I think it doesn't matter.<br /><br />Let me try to put it in another way<br /><br />1st script contains a list of database backups that ran in the past 24 hours<br /><br />2nd list contains the list of database backups that didnt run for the past 7 days. This second list looks more like 1st list. But only thing is the difference between the time since last backup and sysdate should be more than 7Anitanoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-542842889948311542012-06-13T03:19:21.667-04:002012-06-13T03:19:21.667-04:00@Anita - check your policy retention in RMAN also ...@Anita - check your policy retention in RMAN also and verify crosscheck command also.Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-91236708433162188802012-06-13T03:09:40.238-04:002012-06-13T03:09:40.238-04:00@Anita - Ok these scripts check the recovery catal...@Anita - Ok these scripts check the recovery catalog backup status, could be completed or with errors, but the backup was always started .Backup missed could be a backup which doesn't run for other errors, but always scheduled.<br />In this case this script is not usefull at all, I think, because the reasons are not in RMAN, for example crontab in you're in Unix or Linux enviroment or schedule task if you're in Windows.<br />Which schedule are you using to schedule backups ?If you are using Oracle Scheduler could be usefull check other views to verify these operations.Albertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-4335073801462402252012-06-12T21:54:54.011-04:002012-06-12T21:54:54.011-04:00@Alberto:
I'll explain.
In our environment, ...@Alberto:<br /><br />I'll explain.<br /><br />In our environment, there are 783 databases in 115 servers. Full backup is scheduled for the databases on different days of the week. The full backup of a database runs once a week. It so happens that backup could get missed for a particular database. It might be difficult to know that, hence we decided that we might need 2 reports:<br />1) backups that ran yesterday<br />2) backups that were missed for a week<br /><br />I didnt get the script yet. I just tried modifying Arup's script. But couldn't get the desired output.<br /><br />-AnitaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-54995638838131598342012-06-12T02:55:13.920-04:002012-06-12T02:55:13.920-04:00@Anita Can you post your 2nd script?I don't kn...@Anita Can you post your 2nd script?I don't know what you mean for missing backup, do you have read Arup's answer for Keerthi's question? Could be usefull to understand.<br />CiaoAlbertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-82557185629951061072012-06-11T15:41:15.211-04:002012-06-11T15:41:15.211-04:00forgot to add that the 2nd report contains list of...forgot to add that the 2nd report contains list of databases that missed backup in the last week<br /><br />Thanks,<br />AnitaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-17633293427886705002012-06-11T15:26:23.334-04:002012-06-11T15:26:23.334-04:00I used your query. But when I tried to modify it, ...I used your query. But when I tried to modify it, I messed it up.<br /><br />I was trying to generate 2 reports from a single PL/SQL<br /><br />1st report should contain the list of backups completed in the last 12 hours<br /><br />2nd report should contain the list of databases missed for backups.<br /><br /><br />Both the reports should have the same columns:<br /><br />DB_NAME, Backup_type, START_TIME END_TIME, Size of backup<br /><br />Can you help me with this.<br /><br />Regards,<br />AnitaAnonymousnoreply@blogger.com