Reply from rjngh2005 on Dec 29 at 11:12 AM The RMAN catalog does not have the capability to list the level of backup. If you are only using level 0 -- this is not an issue I guess. To list the backups you can use the following commands: list backup of database summary completed after 'sysdate -15'; list backup of database summary completed between 'sysdate-15' and 'sysdate-10'; remove the word summary in case you want detailed listing of the above backups. Do you need more info, or does this help?
| | | ---------------Original Message--------------- From: srini balaji Sent: Wednesday, December 28, 2011 11:56 PM Subject: Oracle RMAN Backup Details from RMAN Catalog Database Thanks for your reply, The above strategy is in place, but need help in effectively using the catalog database. As all the database is registered in catalog, is it possible to get information of all database which does not have level0 backup for more than 7 days.(assuming that the level 0 backup is scheduled at least once in a week. Suggestions please. | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment