GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 34 of 42    Print  
Recovery Catalog
What is recovery catalog? Why do you need this?


  
Total Answers and Comments: 6 Last Update: August 12, 2008     Asked by: shanthiavari 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 26, 2008 07:34:44   #1  
amanx Member Since: January 2008   Contribution: 1    

RE: Recovery Catalog
Using a recovery catalog preserves RMAN repository information if the control file is lost making it much easier to restore and recover following the loss of the control file.

It stores much more extensive history of your backups than the control file due to limits on the number of control file records.

 
Is this answer useful? Yes | No
June 27, 2008 05:46:48   #2  
sunil_jkb Member Since: June 2008   Contribution: 1    

RE: Recovery Catalog
By using Recovery catalog you will get some additional features which you will not find when using control file e.g
To save the scripts etc

 
Is this answer useful? Yes | No
July 01, 2008 19:51:46   #3  
ravi53db Member Since: July 2008   Contribution: 1    

RE: Recovery Catalog
we can start the target database in the event of loss of controlfile using recovery catalog. Also The repository information is not saved in the controlfile when we make backup of control file.
 
Is this answer useful? Yes | No
July 22, 2008 05:36:11   #4  
g.mrunalini Member Since: February 2008   Contribution: 8    

RE: Recovery Catalog
Recovery catalog is a repository of metadata that is available in the control file of the target database. Whenver we take backups using RMAN the copy of the backup is placed in the control file in the form of reusable records and as well as in the recovery catalog in the form of tables. So that while taking recovery also these table info is useful to apply the backup data.
 
Is this answer useful? Yes | No
July 27, 2008 07:25:25   #5  
jkrish.sharma Member Since: July 2008   Contribution: 3    

RE: Recovery Catalog
Recovery catalog contains metadata of control file of target database whenever we take backup by RMAN it contains information and location of backup.

 
Is this answer useful? Yes | No
August 12, 2008 04:35:30   #6  
mkguduru Member Since: August 2008   Contribution: 2    

RE: Recovery Catalog
When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata.
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape