alter pluggable database orclpdb save state;selectcon_name,instance_name,statefromdba_pdb_saved_states;//在open状态下设置save state才能查询出来 如果是保存所有pdb的状态就alter pluggable database all save state;如果是保存多个就是alter pluggable database orclpdb1,orclpdb2 save state;discard同理 ,如...
NAME OPEN MODE RESTRICTED --- --- --- --- 2 PDB$SEED READ ONLY NO 3 PDBX READ WRITE NO 4 PDBY READ WRITE NO 5 PDBZ READ WRITE NO SYS@cdbp1> alter pluggable database all save state; Pluggable database altered. pdbx中创建表空间、表和准备数据 SYS@cdbp1> alter session set ...
alter pluggable database all open; 设置pdb随cdb启动,在pdb是open情况下执行 alter pluggable database oraclpdb save state; 设置所有pdb随着cdb启动 alter pluggable database all save state; 数据库启动时,启动CDB时,pdb会自动启动 以sqlplus / as sysdba方式直接登录pdb export ORACLE_PDB_SID=orclpdb sqlplus...
命令"alter pluggable database ... save state",可以让CDB重启后,pdb维持其关机前的状态。 取消设置使用"alter pluggable database ... discard state"。 SQL>selectname,open_modefromv$pdbs; NAME OPEN_MODE--- ---PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL>alter pluggable database pdb1 ...
ALTER PLUGGABLE DATABASE <新PDB数据库名> OPEN; ALTER PLUGGABLE DATABASE <新PDB数据库名> SAVE STATE; COLUMN CON_ID FORMAT A10 COLUMN PDB_NAME FORMAT A20 COLUMN STATUS FORMAT A20 COLUMN FILE_NAME FOR A40 SET LINESIZE 100 SELECT CON_ID, PDB_NAME, STATUS FROM CDB_PDBS; ...
alter pluggable database all save state; 1. 三、搭建ADG 1 主备CDB搭建ADG 备库执行: dbca -silent -createDuplicateDB \ -gdbName cdb19c \ -sid cdb19c \ -sysPassword oracle \ -primaryDBConnectionString 10.211.55.100:1521/cdb19c \
alterpluggabledatabaseallsavestate;
alterpluggabledatabaseallsavestate; 三、搭建ADG 1 主备CDB搭建ADG 备库执行: dbca -silent -createDuplicateDB\-gdbName cdb19c\-sid cdb19c\-sysPassword oracle\-primaryDBConnectionString10.211.55.100:1521/cdb19c\-nodelist orcl_stby\-databaseConfigType SINGLE\-createAsStandby -dbUniqueName cdb19c_...
SQL> ALTER DATABASE FORCE LOGGING; SQL> ALTER SYSTEM SWITCH LOGFILE; SQL> ALTER SYSTEM set enable_goldengate_replication=true; SQL> ALTER PLUGGABLE DATABASE PDB1 OPEN; SQL> ALTER SESSION SET CONTAINER=CDB$ROOT; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; SQL> ALTER SESSION SET CONTAINER=...
OMS 支持的 Oracle 数据库版本为 10G/11G/12C/18C/19C,12C 及之后版本包含数据库容器(Container Database,CDB)和可插拔数据库(Pluggable Database,PDB)。 OMS 仅支持迁移普通表和视图。 OMS 仅支持迁移库名、表名和列名为 ASCII 码且不包含特殊字符(包括 .|"'`()=;/& 和换行)的对象。