Moneycontrol Brokerage Recos

Tuesday, September 20, 2011

RMAN Interview Questions


RMAN Interview Questions

1) If one archive deleted before applying on standby and you do not have backup how u resolve this issue?. Database size is in TB so recreating Standby is not good idea.

2) If block change tacking is enabled on production database will it be enabled on cloned database automatically?

3) You have assigned 3-4 channels in RMAN backup how you will identify whether all are utilized or not?

4) How you do performance tuning for RMANbackups?

5) Can we register manual cold backup in RMAN?

6) Can we recreate oracle inventory if we do not have any backup?

7) What is difference between image copy & normal backup in terms of performance?

8) 10K blocks in your database got corrupted how you will resolve this?

9) What is the benefit of Recovery Catalog and would you create one?

10) Can you register multiple target databases in a single RMAN Catalog?

11) When you try to register a target database in RMAN catalog then you get error that Database is already registered? What could be the reason of it and how would you overcome from this situation?

12) How would you take archivelog log backups?

13) What is the benefits of taking RMAN backups over other backup strategies?

No comments:

Post a Comment