1) How snap id of AWR moved from production to test?
2) Split brain syndrom in RAC?
3) Mount point crashed, how will you recover database?
4) How parallel is used in Dataguard for MRP process?
5) What is Sync and Async & Affirm and Noaffirm in DG?
6) Can be it possible to take RMAN backup when DB in begin backup?
7) Can be audit SYS schema?
8) How to recover datafile in RMAN?
9) Expdp running from Node1 and huge insert running on node2, what is impact?
10) How to configure RMAN backup in RAC?
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 RMAN backups?
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?
4) How you do performance tuning for RMAN backups?
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