Oracle Data Migration options!!

ACFS!!

1. What is ADVM and ACFS?
2. Can I mount ACFS filesystem on server which is not part of RAC cluster nodes?
3. Can we increase or decrease the ACFS filesystem size dynamically? And what is the impact?
4. Is ACFS file system follows the Disk group redundancy? (External, Normal and High)

Performance Tuning!!

Restore Point Vs Guarantee Restore Point

 Restore Point Vs Guarantee Restore Point

1. To create GRP, is Flashback Database must be enabled?
2. To enable Flashback does DB nees to be stopped?
3. How many GRP I can create on DB?
4. How many times I can flashback my DB?
5. After flashback database does latest stats of table will be reverted or still the stats are persistent?
6. After changing compatibility parameter can I flashback database?
7. After opening database with resetlogs, Can I still flashback DB?
8. Can I flashback database on SQL command prompt or RMAN command prompt?
9. What are the differences between flashback logs and archive logs?
10. What is the location of Flashbacks logs?
11. Can set Flashback log location to some custom location?
12. When the flashback logs will be generated?
13. What are the use of flashback logs in database?
14. Can we create Restore point inside PDB?
15. Can we flashback PDB to a restore point in 12cR1?
Can we flashback PDB to a restore point in 12cR2?

Patching!!!

 Patching!!!

1. What is the difference between opatch apply Vs opatchauto?
2. What is the difference between opatch apply Vs opatch napply?
3. Can we patch standby DB first or primary DB first? Or patch both together? Which best practice?
4. Can we patch GI home first or DB home first? Or patch both together? Which best practice?
5. What happens to standby if we patch Primary and don't patch standby?
6. What is Rolling, Non-Rolling and Hybrid Patching RAC?
7. What is conflict check in patching?
8. What is central Inventory and Local Inventory?
9. How to find locations of central Inventory and Local Inventory?
10. If we loose or deleted these Central and Local Inventory then what is the impact?
11. What is .patch_storage under $ORACLE_HOME? And Why we need this?
12. If we delete this .patch_storage what is the impact on my database?
13. If .patch_stirage got deleted the how to restore the same.

RMAN!!!

 RMAN!!!

1. What are RMAN backup pieces, backup sets and image copies?
2. PROS n CONS of backup sets and image copies
3. Can we run RMAN backup in noarchive log mode?
4. Can we run RMAN backup in mount mode?
5. Can we run RMAN backup standby database?
6. What is BCT in RMAN and why we need that?
7. Can we enable BCT in standby database?
8. What is RMAN target database Vs RMAN auxiliary database?
9. What is RMAN channel VS RMAN Auxiliary channel?
10. Can I take a RMAN backup from Standby Database?
11. Can I use RMAN Backup taken on standby to restore and recover my Primary Database?
12. Can I enable BCT in Standby Database?
13. What is RMAN channel Vs auxiliary channel?
14. What is difference between "rman target /" and "rman auxiliary /"
15. What is RMAN active database duplicate?
16. What are pros and cons of RMAN active database duplicate Vs RMAN duplicate from backup?
17. What are the RMAN optimization parameters?
18. How you will improve your RMAN backup performance?
19. What happens to running RMAN backup when you add new datafile or create new tablespace?
20. What happens to running RMAN backup when you drop a datafile or a Tablespace?
21. What happens to running RMAN backup when you move or rename a datafile?

Also,

1. Will RMAN backup TEMP and UNDO datafile?
2. Will RMAN backup offline datafile?
3. Will RMAN backup offline PDB's datafile while backing up from CDB?
4. What happens if we add datafiles while RMAN backup is running?
5. Can we clone PDB alone using RMAN duplicate into another CDB?
6. What is control file autobackup on? What all files are blacked up as part of this autobackup?

7. Can I use my L0 backup without archive log backup for restore / clone using RMAN duplicate?
8. Can I use my L0 backup without controlfile backup for restore / clone using RMAN duplicate?
9. What is the best practices to take control file backup before the DB backup or after the DB backup?

Database Upgrades!!!

 Database Upgrades!!!

1. What is database upgrade?
2. What is autoupgrade?
3. Is autoupgrade resumeble?
4. What is dbau?
5. Ie dbua resumeble?
6. What is GRP (guarantee restore point)?
7. Does GRP needs flashback to be enabled?
8. Does GRP need database to be archivelog mode?
9. What is timezone upgrade and how is this different from Database upgrade?
10. How to estimate database upgrade time? 10TB Vs 20TB database upgrade time.
11. Is GRP generates flashback logs? If yes then where they are located?
12. What happens to upgrade if FRA or archive destination is full?
13. Can we perform database upgrade in noarchivelog mode?
14. More objects on DBA_RECYCLEBIN will impact database upgrade?
15. Will stats of data_dictionary_views and fixed_objects impact my database upgrade?
16. Can I perform database upgrade in online mode?
17. What is out of place upgrade
18. Can we perform inplace database upgrade?
19. What are PROS and CONS of manual Vs dbua Vs autoupgrade?
20. How much time it will take for flashback database to GRP?
21. Can I flashback database to GRP in case it flashback logs are deleted at OS level?

Standby OR DR Database!!!

Datagaurd:

1. What are standby database modes? And explain each of them?
2. What are standby database types? And explain each of them?
3. What are standby redologs?
4. Whrere do we create Standby redologs PROD database or Standby database?
5. What happens if we don't create standby redologs?
6. Your Standby/DR database goes out of sync then How you will make it sync?
7. What is the OPEN MODE status of a PDB in Primary DB and Standby DB?
8. Can we create Standby or DR database at CDB level or PDB level?
9. What are the different ways to clone Production Database to lower environment?
10. What are the different ways to build standby database for Production Database?
11. Can we run RMAN backup standby database?
12. Can we enable BCT in standby database?
13. What happens if the FRA is full on standby Database?
14. What happens to my standby database in case if I open my primary database with resetlogs?
15. What happens to my standby database in case if I patch my primary database with lastest CPU?
16. What happens to my standby database if I upgrade my Primary database?
17. What is Active Dataguard database?
18. What is the difference between Active Dataguard and normal Dataguard database?
19. Do we need any seperate lisence for this Active Dataguard? And what are the advantages of this?
20. What is sync and async in standby database?
21. What is affirm and noaffirm in Standby database?
22. What is redo tranfer in standby database and what is the difference between ARCH and LGWR redo tranfer mode in standby database?
23. What is LNS process used for?
24. What RFS process used for?
25. What is MRP process used for?
26. Why do we need Production database password file on standby side?
27. Can we recreate new password file on standby side with different password than production database?
28. What is LSP process in standby?
29. What is LCR in standby database?
30. Why we need to enable force logging on Production database to build standby database?
31. Is archive log mode mandatory to build standby database?
32. Is switchover and failover supported in snapshot standby database?
33. Is switchover and failover supported in logical standby database?
34. What happens on standby side if I create Restore Point on Primary database?
35. What happens to standby database in case if I flashback production database to Restore Point?
36. What is switch over and failover?