删除cdb
dbca -silent -deleteDatabase -sourceDB cdb2
创建cdb
export DATA_DIR=/oradata
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname cdb2 -sid cdb2 -responseFile NO_VALUE -characterSet AL32UTF8 -sysPassword 123456 -systemPassword 123456 -createAsContainerDatabase true -numberOfPDBs 1 -pdbName pdb2 -pdbAdminPassword 123456 -databaseType MULTIPURPOSE -memoryMgmtType auto_sga -totalMemory 2000 -storageType FS -datafileDestination "${DATA_DIR}" -redoLogFileSize 50 -emConfiguration NONE -ignorePreReqs
cdb/pdb创建正常
创建pdb--------------
file_name_convert=('/opt/altair/oradb/u01/data/ora18c/pdbseed/','/opt/altair/oradb/u01/data/ora18c/salespdb/');
alter pluggable database pdb2 close;
pdb里边一些存储过程丢失,不确定原因
drop PLUGGABLE database pdb2 including datafiles;
CREATE PLUGGABLE DATABASE pdb2
ADMIN USER cdb2_pdb2 IDENTIFIED BY 123456 DEFAULT TABLESPACE cdb2_pdb2 DATAFILE '/opt/altair/oradb/u02/oradata/CDB2/pdb2/pdb2.dbf' file_name_convert=('/opt/altair/oradb/u02/oradata/CDB2/pdb2/pdbseed','/opt/altair/oradb/u02/oradata/CDB2/pdb2/salespdb');
alter pluggable database pdb2 open;
63:
expdp user/123456 full=Y DIRECTORY=test_dir dumpfile=dbdmp.dmp logfile=dbexport.log
expdp user/123456 full=Y DIRECTORY=test_dirschemas dumpfile=dbdmp.dmp logfile=dbexport.log
CREATE OR REPLACE DIRECTORY test_dir AS '/opt/altair/wurd/20201014';
GRANT READ, WRITE ON DIRECTORY test_dir TO user;
CREATE OR REPLACE DIRECTORY test_dirschemas AS '/opt/altair/wurd/20201014schemas';
GRANT READ, WRITE ON DIRECTORY test_dirschemas TO user;
impdp user/123456@pdb2 DIRECTORY=test_dir dumpfile=dbdmp.dmp table_exists_action=replace remap_tablespace=users:system
impdp user/123456@pdb2 schemas=user DIRECTORY=test_dirschemas dumpfile=dbdmp.dmp logfile=dbimport.log
impdp user/123456@pdb2 full=Y EXCLUDE=STATISTICS DIRECTORY=test_dir dumpfile=dbdmp.dmp logfile=dbimport.log
PDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = locahost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =PDB2)
)
)
----------------
impdp user/123456@pdb2 DIRECTORY=test_dir dumpfile=dbdmp.dmp table_exists_action=replace remap_tablespace=users:system
查看tablespace:
select username,default_tablespace,temporary_tablespace from dba_users
impdp user/123456@pdb2 schemas=hsmdb DIRECTORY=test_dirschemas dumpfile=hsmdbdmp.dmp logfile=dbimport.log
Importing complete database: Login as oracle user and execute below commands:
impdp user/123456@pdb2 full=Y EXCLUDE=STATISTICS DIRECTORY=test_dir dumpfile=dbdmp.dmp logfile=scsdbimport.log