oracle 91c 相关

 

删除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