Q78. How do you configure a CDB for local undo mode?

0 Shares

Lượt xem: 123.528

A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATBASE LOCAL UNDO ON, and then restart the CDB instance.
B. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATBASE LOCAL UNDO ON, and then change the CDB to read/write mode.
C. 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.
D. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and restart the CDB instance.
E. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, create UNDO tablespace in each PDB, then restart CDB instance