Sunday, May 3, 2020

How to Register or Catalog Backups, Archive logs, data file copy, FRA...etc

When you backup using RMAN all backups  will be registered with catalog. If you have taken backup without catalog and you can also register manually.

Backup pieces copied manually to different location to catalog backup piece run below command.
RMAN> CATALOG BACKUPPIECE /oracle/backup/DB1_1978087_6446005710.bkp' ;

In case if you have taken backup using o/s command and to catalog a datafile copy use below command.
RMAN> CATALOG DATAFILECOPY '/oracle/backup/employee01.bak' LEVEL 0;

In case, archive log location full and you have moved backups to different location using o/s command then you can register the archive logs using below command

RMAN> CATALOG ARCHIVELOG ‘/oracle/backup2/db1_arch_99089_0876589.arc'
If you are using Flash recovery area and want to catalog all files in the FRA use below command.
RMAN> CATALOG recovery area;

This command will prompt to confirm that you want the found files to be cataloged. If you do not want to prompt use “noprompt” clause.
RMAN> CATALOG recovery area noprompt;

If you want to catalog only files Start with specific name or belongs to specific SID (db1) use below command
RMAN> CATALOG START WITH '/oracle/backup/db1'

If you run CROSSCHECK, it will go through the files that match criteria and will be marked as available, and files not found will be marked as EXPIRED.

RMAN> CROSSCHECK BACKUP ;
If you want to DELETE EXPIRED backups you can use below command, note that EXPIRED copy will no longer appear in RMAN. You have to be extra cautious to delete backups.

RMAN> DELETE EXPIRED BACKUP ;

If you find extra copies and want to delete those extra copies use DELETE BACKUPPIECE command:
RMAN> DELETE BACKUPPIECE 4555;
Hope this helps managing your backups taken outside of RMAN recovery catalog .

Thanks & Regards 
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com



65 comments:

  1. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.

    AI Course in malaysia

    ReplyDelete
  2. I was very pleased to find this site.I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.
    data science course in malaysia
    data science certification
    data science course malaysia
    data science malaysia
    data scientist course malaysia

    ReplyDelete
  3. Uncertainty continues to grow about whether the Watch Ryder Cup 2020 Live will be postponed, but do the players think the contest should go ahead?

    ReplyDelete
  4. Kansas City Chiefs vs. Houston Texans Results. The following is a list of all regular season and postseason games played between the Kansas City Chiefs vs Houston Texans Live

    ReplyDelete
  5. A real measuring stick right off the bat playing a team that went to the AFC championship game last season. Not crazy about playing the late Monday night game but hey it will be a national game so the Broncos need to play their best. Titans vs Broncos Live Stream Online

    ReplyDelete
  6. there are two options available for anybody who wants to watch that encounter between the two teams. The first is to watch it through the television. If you have cables in your home or your office, then you would be prepared to Ravens vs Browns Game Live Stream Free watch it through the CBS because they are the official broadcast station of that encounter. This is for those that want to watch through the cables.

    ReplyDelete
  7. How to watch Colts vs. Jaguars: Live stream, TV channel, start time for Sunday's NFL game. By Scout Staff. Nov 17, 2019 at 12:30 pm ET 1 min read ...
    Jacksonville Jaguars vs Indianapolis Colts 2020 Live Stream Free Jacksonville Jaguars - Indianapolis Colts Live Score, video stream and H2H ... Jaguars vs Indianapolis Colts previous results sorted by their H2H matches.

    ReplyDelete
  8. Lions vs. Bears: How to watch online, live stream info, game time, TV channel. By Scout Staff. Nov 28, 2019 at 12:00 pm ET 2 min read ... Chicago Bears vs Detroit Lions 2020 Live Stream Online Bears Vs. Lions Live Stream: Watch NFL Thanksgiving Game Online. by NESN Staff on Thu, Nov 28, 2019 at 9:30AM ...

    ReplyDelete
  9. Khabib vs. Gaethje would be a good way to coronate the concept, though a June date would require a quick turnaround time for Khabib Nurmagomedov vs Justin Gaethje Fight Free.

    ReplyDelete
  10. Where can I watch the UFC fight tonight for free? Watch UFC 253 Online Live Streams from Anywhere for Free, Even if Content Is Restricted. See the ufc 253 Fight Time upcoming ...Watch UFC 253 Live Stream Online Free . UFC 253 Fight Live Online. match between Khabib Nurmagomedov vs Justin Gaethje

    ReplyDelete
  11. The Dolphins–Patriots rivalry is an American football rivalry between the National Football League (NFL)'s Miami Dolphins and New England Patriots. The Dolphins lead the all-time series 56–53.Check out the highlights between the New England Patriots and Miami Dolphins during Week 2. The Miami Dolphins (5-11) have pulled off another miracle New England Patriots vs Miami Dolphins Game Live Stream Free against the New England Patriots (12-4), beating their AFC East rival in Week 17, 27-24. This loss coupled with the Chiefs beating the Chargers at Arrowhead now puts Bill Belichick's squad down to the No. 3 seed and out of contention for a first-round bye.

    ReplyDelete
  12. Detroit Lions (3-7-1) vs. Chicago Bears (5-6). Date: Thursday, November 28. Time: 12:00 p.m. CST Location: Ford Field (Detroit, Michigan) TV: FOX. NBC Sports ...All the Detroit Lions vs Chicago Bears Live Stream Online ways you can watch, listen to and live stream the Bears vs. Lions Week 10 game.11 hours ago - Chicago Bears v Detroit Lions Photo by Rey Del Rio/Getty Images. Week one betting lines in the NFL are always tough to predict, but with the ...

    ReplyDelete
  13. How to watch the Virtual Tour de France – live stream, TV and results ... July 5, 2020: Stage 2 Men & Women - Le Tour de France Live Stream Online 2020
    Watopia Mountain, 29.5km; July ..This is the 2020 Tour de France live dashboard with access to everything you should need for the ... January 19 update: This race is broadcast live each year.2020 Tour de France LIVE stream, Results, Photos, News, Preview, Start List, Route Details, Stage Profiles, Weather and Art

    ReplyDelete
  14. The Redskins lead in all-time series 86–80–6. The Redskins have won five NFL championships including three Super Bowls, while the Eagles have won four NFL championships Washington Redskins vs Philadelphia Eagles Game Live Free including one Super Bowl. ... The rivalry is most notable for the "Body Bag Game", where the Eagles knocked out nine Redskins players in a game in 1990.Philadelphia Eagles vs. Washington Redskins Results. The following is a list of all regular season and postseason games played between the Philadelphia ...

    ReplyDelete
  15. The Cincinnati Bengals faced off against the Los Angeles Chargers in Week 14 of the 2018 NFL season. The following is a list of all regular season and postseason games
    Los Angeles Chargers vs Cincinnati Bengals game Live Stream Free played between the Los Angeles Chargers and Cincinnati Bengals. The two teams have met each other 36 times (including 2 postseason games), with the Los Angeles Chargers winning 21 games and the Cincinnati Bengals winning 15 games.

    ReplyDelete
  16. Aug. 23 is the new day race fans are waiting for. Plans are to hold the Indy 500 at 50% capacity, which would allow for about 175,000 people.
    indy 500 live stream Reddit
    Some of the traditional events surrounding the race are still in the works. For example, tickets are on sale for the IPL 500 Festival Parade on Aug. 22.

    ReplyDelete
  17. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    Sattamatka

    ReplyDelete
  18. If their game against the Seattle Seahawks marked a turning point for the Atlanta Falcons in 2019, they're in luck for the 2020 season. The Falcons will begin this Falcons vs Seahawks Live Stream upcoming season by hosting the Seahawks at Mercedes-Benz Stadium on Sept. 13 at 1 p.m. ET.13 at home at Mercedes-Benz Stadium against the Seattle Seahawks. Other featured matchups on the 2020 Atlanta Falcons schedule include the Chicago Bears, ...

    ReplyDelete
  19. Buffalo Bills 2021 Opponents: The official source of the Buffalo Bills future NFL opponents. Opponents subject to Jets vs Bills Live Stream 2020 change.Sam Darnold and Josh Allen Set to Square Off to Open the 2020 Season. After posting a 7-9 record last season, the Jets will have seven games against 2019 playoff teams and the 2020 schedule strength is

    ReplyDelete
  20. Tickets to the game will sell out quickly, so if you’re interested in attending the NRL Grand Final 2020 Stream Online, make sure to get in early to avoid disappointment.

    ReplyDelete
  21. How to Watch Raiders vs Panthers Live Stream Online | Watch Las Vegas Raiders vs Carolina Panthers Live Stream HD | NFL Panthers vs Raiders Live Stream Online Football Game 2020 TV Channel.Explore www.pronfl-live.net's board "Texans Vs Panthers live stream" on Pinterest. See more ideas about Texans, Panthers, Raiders vs.

    ReplyDelete
  22. Web smoothing out infers the way toward making a site persistently detectable on a web crawler's outcomes page. To explain, a faltering SEO reasoning will put an affiliation's site at the head of the rundown on a Google search page, thusly improving the probability that individuals will visit the site.


    https://5euros.eu/servic[...]413/retoucher-votre-video

    ReplyDelete
  23. OCEANPORT - Authentic held off a late charge from Ny Traffic to win a thrilling edition of the 53rd TVG.com $1 million Haskell Stakes by a nose Saturday at Monmouth Kentucky Derby Race Live Stream Online Park. Trained by Hall of Famer Bob Baffert, Authentic, who was the 3-5 favorite, led wire-to-wire in the 1 1/8 mile race for 3-year-olds and gave Baffert his record-extending ninth Haskell.

    ReplyDelete
  24. I am confident you've got a great enthusiast following there.Small Business ERP Software

    ReplyDelete
  25. That story and another recent POLITICO report detailed that a contingent of Democrats is lobbying against Harris to be chosen as Biden 2020 T Shirts running mate.

    ReplyDelete
  26. In excess of a site, we are building an effective and customized advanced methodology.
    We exhort, we support, we co-pilot ...
    Our job is to acquire an outcome in accordance with your goals.



    creation site internet blois tribu and co


    ReplyDelete
  27. I love your blog.. vdry pleasant hues and topic. Did you make this site ourself or did you recruit somebody to do it for you? Plz answer ass I'm looking also structure my own bpog and would likme to discover where u got this from. much appreciated о



    Situs Judi QQ Online Terpercaya

    ReplyDelete
  28. On Aug. 11, 2015, coach Todd Bowles walked into the New York Jets' press room -- unannounced -- and went directly to the podium. Reporters were summoned for an impromptu news Bills vs Jets Football Game Live Stream conference. This was supposed to be a quiet day in the world of the Jets: a light practice before their first preseason game, followed by routine questions from the media.

    ReplyDelete
  29. Hello there, simply was aware of your blog through Google, and located that it’s really informative. win915

    ReplyDelete
  30. Betting sites favor Watch Roy Jones vs Mike Tyson Online in their boxing match expected to take place on November 28. Iron Mike sure picked a weird time to come out of retirement, but the best online sportsbooks are loving it.

    ReplyDelete
  31. How to watch Vikings vs. Packers: NFL live stream info, TV Packers vs Vikings Football Game Live Stream Free channel, time, game odds. By Scout Staff. Dec 23, 2019 at 7:50 pm ET 2 min read ...

    ReplyDelete
  32. Products seems to be original. I can feel the originality form photos. Lsm99

    ReplyDelete
  33. first-rate knowledge, restructure everybody mind merely reference assign assist to to it Situs IDN Poker

    ReplyDelete
  34. There is no doubt that traditional forms of advertising are slowly being replaced by the Internet. Currently,
    the most important are the company's activities on social media.



    sale online in costa rica

    ReplyDelete
  35. This will open a window containing the HTML source code of the page. Inspect an HTML Element: Right-click on an element basic HTML CODE

    ReplyDelete
  36. I have just found this website while searching over the internet, you have posted valuable information which i like reading. 토토

    ReplyDelete
  37. افضل الخدمات الخاصة باعمال نقل العفش مع الفك والتركيب في الطائف تقدمها افضل شركه نقل عفش بالطائف وهي تعتبر من افضل الشركات المتخصصة في اعمال نقل الاثاث بواسطة فريق عمل مميز ومحترف وسيارات نقل عفش حديثة ومجهزة لأعمال شركات نقل الاثاث بالطائف مقفلة ومبطنة من الداخل وستحصل على افضل خدمات نقل الاثاث بالطائف باحترافية عالية وبالضمان من افضل شركات نقل عفش الطائف المتميزة والمؤهلة

    ReplyDelete
  38. الرياض من اهم مناطق المملكة ولا بد ان تكون خدمات التنظيف ونقل الاثاث في الرياض على مستوى لائق باهل العاصمة ونقدم لكم افضل شركة نقل عفش بالرياض مضمونة وتقدم خدمات رائعة وتستخدم سيارات نقل عفش مخصصة ومبطنة من الداخل وايضا تجد خدمات التنظيف للمنازل والفلل والشقق في ارخص شركة تنظيف فلل بالرياض تمتلك خبرة طويلة في اعمال تنظيف الشقق والفلل والقصور وجلي وتلميع جميع انواع البلاط ونقدم ايضا خدمات تنظيف المنازل بالبخار في الرياض تحت اسم اقوى شركات تنظيف كنب بالرياض آمنة بهدف الحصول على تنظيف منزلي شامل للارضيات والشبابيك والمفروشات كالكنب والمجالس والموكيت والسجاد وقد تحتاج ايضا الى تنظيف خزان المياه خاصتك وذلك بالتعاقد مع افضل شركة تنظيف خزانات بالرياض لخدمات تنظيف وتعقيم وصيانة لخزان الماء خاصتك وعمل تعقيم للخزان الأرضي والعلوي ولا بد ايضا ان تهتم بتنظيف المنزل من الحشرات مع احسن شركة مكافحه حشرات بالرياض مضمونة لتعقيم المنزل او المسجد والتخلص من الحشرات المزعجة كما في شركات مكافحة الحشرات بالرياض التي تقدم خدمات جيدة بالضمان

    ReplyDelete
  39. I have just found this website while searching over the internet, you have posted valuable information which i like reading. Click Here
    Click Here
    Click Here

    ReplyDelete
  40. عزيزي العميل تعتبر “شركة بوابة سوهو ” أفضل شركة تنظيف منازل بجدة وذلك لان شركة تنظيف المنازل فى جده تشتهر بالكفاءة والمهارة العالية في مجال التنظيف المنزلى وتقدم العديد من الأعمال الكثيرة والخدمات المتنوعة مما أعطاها وأكسبها خبرات واسعة في هذا المجال وذلك من شدة ارتباطها بأعمال نظافة منزلية متعددة وذلك من أجل كسب الثقة العملاء والعمل على إرضائهم وراحتهم ولذلك تقدم أرخص الأسعار
    تمتلك شركة تنظيف منازل بجدة أكبر فريق عمل يعمل بشكل احترافي ومتميز كما تتمتع الشركة بالأمانة والإلتزام في المواعيد المحددة مسبقاً ووضع خطة لتنفيذ الأعمال المطلوبة منها على أكمل وجه في أسرع وقت ممكن ولا تتردد بالاتصال بنا على هذا الرقم  0552555759 ✆

    ReplyDelete
  41. Hey! Amazing work. If you are searching for genuine QuickBooks Customer Service dial 1-855-756-1077 for immediate help.

    ReplyDelete
  42. I have just found this website while searching over the internet, you have posted valuable information which i like reading Slotxo

    ReplyDelete
  43. Due to the inconvenience of Covid-19, the 43rd 2020 Ryder cup matches were postponed and but it is rescheduled to take place on 24-26th September 2021 at Whistling Straits, Wisconsin, in the United States. The postponement will now force the subsequent cups to fall in odd years as opposed to the norm. If you are a fan of the biennial match between Europe and America’s best golfers and would like to watch the ryder cup live online free the whole action live, there are several options to choose from.

    ReplyDelete
  44. I have read the title which you have made about self hosted. You have made a great effort in making this post which is appreciable 먹튀검증사이트

    ReplyDelete
  45. I think this is a really good article. You make this information interesting and engaging. You give readers a lot to think about and I appreciate that kind of writing. Status moj whatsApp

    ReplyDelete
  46. Great Information sharing .. I am very happy to read this article .. thanks for giving us go through info.Fantastic nice. I appreciate this post. click here

    ReplyDelete
  47. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! click here

    ReplyDelete
  48. I have been searching to find a comfort or effective procedure to complete this process and I think this is the most suitable way to do it effectively. click here

    ReplyDelete
  49. Nice article.
    Thanks for the info information, I will wait for posts like this and will read them with pleasure.

    Don't forget visit my website: Sports Host

    ReplyDelete
  50. Nice article.
    Thanks for the info information, I will wait for posts like this and will read them with pleasure.
    Don't forget visit my website: NFR 2021 live reddit
    UFC 269 live stream reddit
    Sports Report News
    Joshua vs Usyk Live stream reddit
    NFL Events
    Super Bowl 2022 Live

    ReplyDelete
  51. I'm so happy to finally find a post with what I want. casino You have inspired me a lot. If you are satisfied, please visit my website and leave your feedback.


    ReplyDelete
  52. Nice article.Thanks for sharing information,
    You can check : UFC 270 live stream: Ngannou vs Gane Live is an upcoming mixed martial arts event produced by the Ultimate Fighting Championship UFC 270 live that will take place on January 22, 2022 at the Honda Center in Anaheim, California.

    ReplyDelete
  53. Thank you so much for providing good quality information.I think it would not have been easy to collect this information and organize it in an easy to understand way.igtok

    ReplyDelete
  54. I believe the things you whatever you have enclosed, all the way throughout the post are peaceful striking, good job and great hard work. I found it very striking and enjoyed reading all of it...stay it up, good-looking job. Thanks. andrey belyakov

    ReplyDelete
  55. I trust the belongings you some thing you have got enclosed, all of the way throughout the put up are peaceful hanging, excellent job and excellent tough work. Thank you. Freelancing Park

    ReplyDelete
  56. I trust the belongings you some thing you have got enclosed, all of the way throughout the put up are peaceful hanging. Hydrogeological Assessment Service

    ReplyDelete
  57. Thank you so much for providing good quality information.I think it would not have been easy to collect this information. Physiotherapy Mississauga

    ReplyDelete
  58. I assure this would be beneficial for most of the people.
    This content is simply exciting and creative. Keybord price in bd

    ReplyDelete
  59. We believe in fusion and creativity to produce captivating eBooks that inform, entertain, and inspire. eBook Writing Profs is a team that works with a keen focus on quality, creativity and innovation, adept at delivering content that exceeds expectations, driving reader engagement and achieving desired outcomes. We never compromise on quality and provide the desired outcome.

    ReplyDelete
  60. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.
    I am continually amazed by the amount of information available on this subject. Bike modification bd

    ReplyDelete
  61. I have to see for objectives t shirts
    with fundamental data on given point and offer them to educators our slant and the article.

    ReplyDelete

  62. This substance is essentially energizing and inventive. I have been choosing on a regulation move and this has made a difference me with one aspect.
    vivo t2 pro price in bangladesh

    ReplyDelete
  63. I am glad to find your familiar method of writing the message. Now it makes it easier for me to understand and implement the idea. I am very grateful for. the message. Popular Medicine Corner

    ReplyDelete