A.
Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
B.
Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
C.
Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
D.
Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
E.
Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
A correct
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5
A correct, here is the 19C Documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5
A correct. Per doc and test. Note, the UNDO tablespace auto created when the pluggable is opened. Excerpt from alert log below.
HR_ROOT(4):CREATE SMALLFILE UNDO TABLESPACE undo_1 DATAFILE SIZE 146800640 AUTOEXTEND ON NEXT 5242880 MAXSIZE 34359721984 ONLINE
2023-04-29T20:51:25.691737-03:00
HR_ROOT(4):[24824] Successfully onlined Undo Tablespace 4.
HR_ROOT(4):Completed: CREATE SMALLFILE UNDO TABLESPACE undo_1 DATAFILE SIZE 146800640 AUTOEXTEND ON NEXT 5242880 MAXSIZE 34359721984 ONLINE
A
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5
upvoted 4 times
Agree, A correct. Tested couple of minutes ago in practice. It was not possible to change undo mode on the PDB level:
SQL> alter database local undo OFF;
alter database local undo OFF
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 2 years, 9 months agorodriguesJC
2 years, 3 months ago_gio_
Most Recent 7 months agoScottL
9 months, 1 week agovkra
11 months, 1 week agohilaire
1 year, 1 month agosmartvan
2 years, 3 months agoObserverPL
2 years, 8 months ago