- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Newbie queries on Multi Tenant
Hi, I have a list of newbie questions on Multi Tenant Architecture at 12c -
Q1.The Oracle WP on MTA suggests you should not consider a database for being a PDB if it already holds schema consolidation. Is this true - what happens if a database already has schema consolidation ? Can it not be converted to a PDB ?
Q2. My PDB will have a SYSTEM user, however does it also have the internal SYS connection ?
Q3. Can you have a CDB and a non CDB/PDB database running from the same 12c ORACLE_HOME on a Database Server or should they have their own separate ORACLE_HOMEs
Q4. If you unplug a PDB from a CDB at 12.1.1 and plug it into a CDB at 12.1.2, is the PDB automatically upgraded to that patchset or do you still have to run some of the patchset scripts against the PDB ?
Q5. Similarly to Q2, What is the situation if you are re-plugging a PDB into a CDB with a completely different release eg from 12.1 to 12.2
Q6. I believe RMAN is used only at the CDB level but can still do PITR at the PDB level? Is this correct ?
Q7. How does RAC fit into the model ? I presume it is only at the CDB level since only that provides the instance ? So if you had some databases that were to be RAC and some that were not, you would need more than 1 CDB i.e. a RAC deployed one and a non RAC deployed one ?
Q8. If my CDB is a 3 node RAC does that effectively make every PDB of that CDB, also a 3 node RAC database ?
Q9. If I have a 5 node database and want to convert it to a PDB but my CDB is a 3 node RAC does that mean my database ( PDB ) will have to be a 3 node RAC ( unless I increase the nodes of the CDB from 3 to 5 ) ?
Q10. How does Data Guard fit into the model ? Does Data Guard only get implemented at the CDB level and not the PDB level ? I am presuming so, since the Redo Logs are only at the CDB Level ?
Q11. If your Primary is the CDB, do the Standby have to be a CDB on your DR server or can the DR server simply hold a number of Standby Databases that are non CDB/PDB based or does the architecture on the DR side also have to be CDB / PDB ?
Q12. What type of Standby can you have in Multi Tenant i.e. Physical, Logical, Snapshot ? Also what protection modes are allowed ?
Q13. What happens if you want to convert a database into a PDB but that database is already using Data Guard ?
Any help greatly appreciated
thanks - Jim