1. How do you configure a CDB for local undo mode（）?
   A、Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace Execute. AI TER DAMBASE LOCAL UNDO ON in each PDB. and then restart the CDB instance
   B、Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.
   C、Open the CDB instance in upgrade mode. In CDB&ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance
   D、Open the CDB in read-only mode. In CDBSROOT, 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.

答案：Chttp://www.cndba.cn/hbhe0316/article/108615http://www.cndba.cn/hbhe0316/article/108615

共享UNDO转化为local undo步骤http://www.cndba.cn/hbhe0316/article/108615

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup   upgrade
ORACLE instance started.

Total System Global Area 2516582400 bytes
Fixed Size                  2927528 bytes
Variable Size             671089752 bytes
Database Buffers         1828716544 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MIGRATE    YES
         3 PDB                            MOUNTED
         4 PDB1                           MOUNTED
         5 PDB2                           MOUNTED
SQL> alter database local undo on;
SQL> shutdown   immediate
SQL> startup

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle