Re: adpreclone on PDB

Posted by ErmanArslansOracleBlog on Jan 12, 2023; 12:49pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adpreclone-on-PDB-tp11441p11446.html

If you need the casual reason for that; check the v$datafile from both CDB and PDB instances.. There you will see..

That is the validation is meaningless ; see the following example:

SQL> set head on
SQL> select a.FileName, b.Name
  2  from (
  3    select FileName
  4    from (
  5      select substr(NAME,instr(NAME,'/',-1)+1,length(NAME)) FileName
  6      from v$datafile
  7      order by 1
  8      )
  9    group by FileName
10    having count(FileName) > 1
11    ) a,
12    v$datafile b
13  where b.Name like '%'||a.FileName;

 
FILENAME             NAME
-------------------- --------------------------------------------------
undotbs01.dbf        /u01/dbebs/EBSDEV/data/EBSDEV/undotbs01.dbf
undotbs01.dbf        /u01/dbebs/EBSDEV/data/EBSDEV/pdbseed/undotbs01.dbf
system01.dbf         /u01/dbebs/EBSDEV/data/EBSDEV/system01.dbf
system01.dbf         /u01/dbebs/EBSDEV/data/EBSDEV/pdbseed/system01.dbf
system01.dbf         /u01/dbebs/PROD/data/system01.dbf
sysaux01.dbf         /u01/dbebs/EBSDEV/data/EBSDEV/sysaux01.dbf
sysaux01.dbf         /u01/dbebs/EBSDEV/data/EBSDEV/pdbseed/sysaux01.dbf
sysaux01.dbf         /u01/dbebs/PROD/data/sysaux01.dbf