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



33 comments:

  1. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
    data analytics course
    data science course
    big data course
    big data course
    360DigiTMG

    ReplyDelete
  2. 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
  3. 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
  4. Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔ ✔ ✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai

    ReplyDelete
  5. 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
  6. The hectic world, a usual silhouette of wrinkled-faces and lack of time & good people make absolute absence of Love in our lives. Only a smile means to exist in the whole world bringing itself a Comet of Love. So it takes you believe onCall Girls in Aerocity liable to fulfill your lives with real sense of love. Check our other Services...
    Call Girls in Aerocity
    Call Girls in Chanakyapuri
    Call Girls in Chanakyapuri
    Call Girls in Chanakyapuri
    Call Girls in Connaught Place
    Call Girls in Connaught Place
    Call Girls in Dwarka
    Call Girls in Vasant Kunj

    ReplyDelete
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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