Oracle Database Administrator Interview Questions on RMAN

RMAN INTERVIEW QUESTIONS
========================


1.What is the difference between recovery catalog and Nocatalog backup in RMAN?


NoCatalog Backup:


ByDefault RMAN connects to the target database in Nocatalog Mode.
In Nocatalog Mode, Backup Information and Metadata related to RMAN is stored in target database controlfile.


Catalog Backup:


A recovery catalog is a schema created in a separate database that contains metadata obtained from the target control file.
In recovery catalog we can store rman scripts.


We can store metadata about multiple incarnations of a single target database in the catalog.
Recovery catalog is central and can have information of many databases.
If the control file is lost and must be restored from backup, the backup configuration information is available when the database is not mounted.


2.What are the differences between crosscheck and validate commands?


Validate command is to examine a backup set and report whether it can be restored. RMAN scans all of the backup pieces in the specified backup sets and looks at the checksum to verify that the contents are intact so that backup can be successfully restored if necessary.


Crosscheck command is to verify the status of backups and copies recorded in the RMAN repository against media such as disk or tape. The crosscheck command only processes files created on the same device type as the channel running crosscheck.


3.What is obsolete backup & expired backup?


A status of “expired” means that the backup piece or backup set is not found in the backup destination.


A status of “obsolete” means the backup piece is still available, but it is no longer needed. The backup piece is no longer needed since RMAN has been configured to no longer need this piece after so many days have elapsed, or so many backups have been performed.


4.What is the difference between hot backup & RMAN backup?


We need to put the database in Backup mode for Hot  Backup. RMAN Backup does not need the database to be in Backup mode.


5. Which Tables are have information required for RMAN list & report commands ?
 V$BACKUP_FILES and recovery catalog views e.g.,  RC_DATAFILE_COPY or RC_ARCHIVED_LOG.


Below tables contain RMAN Catalog information:


RC_DATABASE_INCARNATION 
RC_BACKUP_COPY_DETAILS
RC_BACKUP_CORRUPTION
RC_BACKUP-DATAFILE_SUMMARY

54 thoughts on “Oracle Database Administrator Interview Questions on RMAN”

  3. Fantastic blog! Do you have any tips for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you suggest starting with a free platform like WordPress or go for a paid option? http://www.kayswell.com There are so many options out there that I’m totally confused .. Any ideas?

    Reply

  9. Everyday consumption of weight reduction capsules can offer a number of physical benefits, consisting of enhanced cravings guideline and improved metabolic activity. http://www.kayswell.com These effects might add to a lot more efficient fat oxidation and continual energy throughout the day. In addition, some formulas support immune health and wellness and supply antioxidant benefits, which can be valuable during weight decrease efforts,

    Reply

  27. This is the right webpage for anybody who wishes to understand this topic. You realize so much its almost tough to argue with you (not that I really will need to…HaHa). You certainly put a fresh spin on a topic which has been discussed for ages. Excellent stuff, just wonderful! http://www.hairstylesvip.com

    Reply

  28. First off I would like to say superb blog! I had a quick question which I’d like to ask if you don’t mind. I was interested to find out how you center yourself and clear your thoughts before writing. http://www.kayswell.com I have had a difficult time clearing my mind in getting my ideas out there.I truly do take pleasure in writing but it just seems like the first 10 to 15 minutes are

    Reply

  35. Based on my observation, after a foreclosed home is offered at a sale, it is common for your borrower to be able to still have some sort ofthat remaining unpaid debt on the loan. There are many loan companies who attempt to have all expenses and liens paid off by the following buyer. Nonetheless, depending on specific programs, restrictions, and state laws and regulations there may be a number of loans that are not easily solved through the switch of loans. Therefore, the obligation still remains on the borrower that has received his or her property in foreclosure. Thank you for sharing your opinions on this blog.

    Reply

  36. When I initially commented I clicked the -Notify me when new feedback are added- checkbox and now every time a comment is added I get four emails with the identical comment. Is there any approach you’ll be able to remove me from that service? Thanks!

    Reply

  41. Hey! This is kind of off topic but I need some help from an established blog. Is it tough to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about making my own but I’m not sure where to begin. Do you have any points or suggestions? Thanks

    Reply

  44. Greate article. Keep posting such kind of info on your site. Im really impressed by your site. Hi there, You have done an excellent job. I’ll definitely digg it and individually suggest to my friends. I am sure they will be benefited from this web site.

    Reply

  45. Pretty great post. I just stumbled upon your weblog and wanted to say that I have really loved browsing your weblog posts. After all I’ll be subscribing on your feed and I hope you write once more very soon!

    Reply

  46. I do agree with all of the ideas you’ve presented in your post. They’re really convincing and will certainly work. Still, the posts are too short for beginners. Could you please extend them a little from next time? Thanks for the post.

    Reply

  48. A formidable share, I simply given this onto a colleague who was doing slightly analysis on this. And he actually purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love reading extra on this topic. If attainable, as you develop into expertise, would you mind updating your weblog with more details? It’s extremely useful for me. Big thumb up for this blog publish!

    Reply

  51. You’re so interesting! I don’t suppose I have read something like this before. So nice to discover another person with a few genuine thoughts on this subject. Seriously.. many thanks for starting this up. This web site is something that’s needed on the web, someone with a little originality!

    Reply

  53. I feel this is one of the such a lot important information for me. And i’m satisfied reading your article. But should observation on some normal issues, The site style is perfect, the articles is actually nice :

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *