#停快速故障轉(zhuǎn)移功能
DGMGRL>?stop observer
DGMGRL>?disable fast_start failover;
#主庫停止日志傳到從庫
SQL>?ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;
or
DGMGRL>?edit configuration set protection mode as MaxPerformance;
DGMGRL>?edit database?'DG125'?set property LogXptMode ='ASYNC';
DGMGRL>?edit database 'DG126'?set property LogXptMode ='ASYNC';
DGMGRL>?edit database 'DG125'?set state='TRANSPORT-OFF';
SQL>?alter system switch logfile;? #(主庫切換日誌否則??TRANSPORT-OFF 不會立即生效）
#drop pdb
#備庫暖释、主庫都close pdb
SQL>alter pluggable database PDB3 close;
#主庫drop pdb
SQL>drop pluggable database PDB3 including datafiles;
#主庫 create pdb
#作廢 alter system set db_create_file_dest='/u01/app/oracle/oradata/DG/';
create pluggable database PDB2 admin user xag2 identified by 123456
file_name_convert=('/u01/app/oracle/oradata/DG/pdbseed','/u01/app/oracle/oradata/DG/PDB2');
SYS@XAGDB>alter session set container=PDB2;
SYS@XAGDB> startup;
--sys login pdb2
select tablespace_name,file_name,bytes/1024/1024 mb from dba_temp_files;
create tablespace PDB2_UD datafile
'/u01/app/oracle/oradata/DG/PDB2/PDB2_UD_1.dbf' size 16M AUTOEXTEND ON NEXT 8M MAXSIZE UNLIMITED,
'/u01/app/oracle/oradata/DG/PDB2/PDB2_UD_2.dbf' size 16M AUTOEXTEND ON NEXT 8M MAXSIZE UNLIMITED
default storage (initial 128K next 2M pctincrease 0);
Create tablespace I_PDB2_UD datafile
'/u01/app/oracle/oradata/DG/PDB2/I_PDB2_UD_1.dbf' size 16M AUTOEXTEND ON NEXT 8M MAXSIZE UNLIMITED,
'/u01/app/oracle/oradata/DG/PDB2/I_PDB2_UD_2.dbf' size 16M AUTOEXTEND ON NEXT 8M MAXSIZE UNLIMITED?
default storage (initial 128K next 2M pctincrease 0);
--------------------------------------------------------------
CREATE SMALLFILE TEMPORARY TABLESPACE PDB2_TD1 TEMPFILE
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_1.dbf' SIZE 32M,
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_2.dbf' SIZE 32M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
or
create temporary tablespace PDB2_TD1 tempfile
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_1.dbf' size 32M REUSE AUTOEXTEND ON NEXT 32M? MAXSIZE 1024M,
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_2.dbf' size 32M REUSE AUTOEXTEND ON NEXT 32M? MAXSIZE 1024M extent management local;
-----------------------------------------------------------
ALTER TABLESPACE PDB2_TD1 TABLESPACE GROUP PDB2_GROUP;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PDB2_GROUP;
select * from dba_tablespace_groups
ALTER DATABASE DEFAULT TABLESPACE PDB2_UD;
drop? tablespace TEMP including contents and datafiles cascade constraints;
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/DG/PDB2/undotbs01.dbf' RESIZE 110M;
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/DG/PDB2/undotbs01.dbf' AUTOEXTEND ON NEXT 32M;
GRANT DBA to xag2;
SQL> grant connect,resource,unlimited tablespace to xag2;
SQL> grant create any directory to xag2;
SQL> grant drop any directory to xag2;
#異機不同存放位置插入PDB（PDB8來源其他機器）
copy 源機器的PDB8目錄下文件 到?
主機及備機 的 /u01/app/oracle/oradata/DG/PDB8;??
SQL>?create pluggable database PDB8 using '/u01/tmp/pdb8.xml' SOURCE_FILE_NAME_CONVERT =('/u02/app/oracle/oradata/DG/PDB8/', '/u01/app/oracle/oradata/DG/PDB8/') nocopy storage (maxsize 2G) tempfile reuse;
這里xml文件中指示數(shù)據(jù)文件在/u02/app/oracle/oradata/DG/PDB8/中携狭，
最終我們要將數(shù)據(jù)文件放在/u01/app/oracle/oradata/DG/PDB8/中
SQL> show pdbs;
2 PDB$SEED ? READ ONLY? NO
3 PDB1 ? READ WRITE NO
4 PDB8 ? MOUNTED
SQL> alter pluggable database PDB8 open;
SQL> show pdbs;
2 PDB$SEED ? READ ONLY? NO
3 PDB1 ? READ WRITE NO
4 PDB8 ? READ WRITE NO
#主庫啟動日志傳到從庫
SQL>?ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
or
DGMGRL>?edit database?'DG125'?set state='TRANSPORT-ON';
DGMGRL>?edit database?'DG125'?set property LogXptMode ='SYNC';
DGMGRL>?edit database?'DG126'?set property LogXptMode ='SYNC';
DGMGRL>?edit configuration set protection mode as MaxAvailability;
主庫啟動日志傳到從庫后，備庫也open pdb2
alter pluggable database PDB2 open;
alter pluggable database PDB8 open;
#備庫添加臨時表空間文件
ALTER TABLESPACE PDB2_TD1 ADD TEMPFILE
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_1.dbf'
SIZE 32M? REUSE AUTOEXTEND ON NEXT 32M? MAXSIZE 1024M;? --32767M
ALTER TABLESPACE PDB2_TD1 ADD TEMPFILE
'/u01/app/oracle/oradata/DG/PDB2/PDB2_TD1_2.dbf'
SIZE 32M? REUSE AUTOEXTEND ON NEXT 32M? MAXSIZE 1024M;
#啟動快速故障轉(zhuǎn)移功能
DGMGRL>?enable fast_start failover;
DGMGRL>?start observer
參考：
https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686
