ENVIRONMENT:
############
(1) PRIMARY CONTAINER: CDB1
PRIMARY PDB: PDB4
(2) SECONDARY CONTAINER: CDB2
SECONDARY PDB: PDB4RO
CREATING REFRESHABLE PLUGGABLE DATABASE IN CDB2
###############################################
CREATE PLUGGABLE DATABASE PDB4RO
FROM PDB4@cdb1_lnk
FILE_NAME_CONVERT = ('/u01/Oracle/oradata/CDB1/PDB4/', '/u01/Oracle/oradata/CDB2/PDB4RO/')
REFRESH MODE MANUAL;
ADDING A TABLESPACE IN PRIMARY PDB4
####################################
CREATE TABLESPACE test
DATAFILE '/u01/Oracle/oradata/CDB1/PDB4/test01.dbf'
SIZE 100M
AUTOEXTEND ON
NEXT 10M
MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
REFRESHING PDB4RO
##################
conn sys/syspwd@//192.168.1.24:1521/PDB4RO as sysdba
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
alter session set db_file_name_convert='/u01/Oracle/oradata/CDB1/PDB4/', '/u01/Oracle/oradata/CDB2/PDB4RO/';
SQL> show parameter db_file_name_convert;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string /u01/Oracle/oradata/CDB1/PDB4/
, /u01/Oracle/oradata/CDB2/PDB
4RO/
pdb_file_name_convert string
SQL> ALTER PLUGGABLE DATABASE REFRESH;
ALTER PLUGGABLE DATABASE REFRESH
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01274: cannot add data file that was originally created as '/u01/Oracle/oradata/CDB1/PDB4/sagar01.dbf'
Whats missing? i cant set any parameter that require db restart?? I can only use session level parameter?? Any suggestions ??