18 Temmuz 2017 Salı

Oracle 12c Lab 3 : Clone PDB From Remote CDB

STEP 1: XML and DBF ->  Target OS 

scp -r * oracle@192.168.4.61:/disk2/setup_files/datafiles 



STEP 2: Check Database Status 

SQL> select pdb_name, status from CDB_PDBS;

PDB_NAME           STATUS 
PDB$SEED                     NORMAL 
PDB01                             NORMAL 
PDB05                             NORMAL 


STEP 3: Create PDB

create pluggable database PDBCDR using '/disk2/setup_files/ pdborcl.xml' source_file_name_convert (‘……, ……') nocopy tempfile reuse; 

STEP 4: Check PDB Status

SQL> select pdb_name, status from CDB_PDBS; 
PDB_NAME        STATUS 
PDB$SEED                 NORMAL 
PDBTST1                    NORMAL 
PDBCDR                     UNPLUG 

SQL> select name, open_mode from V$PDBS; 
NAME                OPEN_MODE 
PDB$SEED               READ ONLY 
PDBCDR                   MOUNTED 
PDBTST1                  READ WRITE




Hiç yorum yok:

Yorum Gönder