Hi All,
I am learning about Oracle 12.2 CDB and PDB databases.I read a few oracle documents. Struggeled to change mind from non-cdb to CDB/PDB. Not able to get an OVERVIEW of CDB/PDB.
I have a few doubts about it.
Please anyone clear it.
1, CDB and root db both are same or not?
2, Difference between root and seed?
3, Can we have separate undo table-spaces and temp table-spaces for PDB database's?
4, CDB should have upper limit values for the instance parameters? For Ex : memory_max_size/open_cursor of pdb should less than memory_max_size/open_cursor of cdb?
5, when add non-cdb db to cdb,both have separare parameter file or not? Does PDB Have An SPfile
6, when leave from cdb to non cdb,do we need to prepare new parameter file for non-cdb?
7, After leave from cdb to pdb ( going to attach in another cdb ) or non-cdb, what about old rman backups.Can we use old rman backups or obsolete?
8, Is it possible to recover PDB db if CDB is corrupted ( Just assume there is no CDB rman backup,but we have PDB rman backup )
9, Is there any additional BG process for PDB?
10, Is there any additional BG process for CDB?
11, Is there any any new memory area for PDB?
12, Is there any any new memory area for CDB?
13, If CDB is archive log mode,should all PDB is in archive log mode?
14, Can we have different db block size between CDB and PDB database?
15, If execute alter system checkpoint on CDB,what happens on associate PDB DB's?
16, If execute alter system switch logfile on CDB,what happens on associate PDB DB's?
The above questions are basic,So i didn't post each on separate discussion.
Thanks & Regards,