PDB Descriptor file

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Fri, 25 Jun 2021 15:39:00 -0700
Message-ID: <CAHDOOG4UX5t+8d7ObUeAHv5WQag0NoEFY1dg0u=BHYOWS96s0Q_at_mail.gmail.com>

A sample from the file I have is here
<file>

<path>KM_DG/KM/DATAFILE/system.633.1070862625</path>
<afn>9</afn>
<rfn>1</rfn>
<createscnbas>3223178074</createscnbas>
<createscnwrp>2892</createscnwrp>
<status>1</status>
<fileblocks>1210904</fileblocks>
<blocksize>8192</blocksize>
<vsn>318767104</vsn>
<fdbid>1564979399</fdbid>
<fcpsb>3223178074</fcpsb>
<fcpsw>2892</fcpsw>
<frlsb>1920977</frlsb>
<frlsw>0</frlsw>
<frlt>1076099548</frlt>
<autoext>0</autoext>
<maxsize>0</maxsize>
<incsize>0</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
<dfflags>0</dfflags>

    </file>
Question is how are these values populated?

and the reason I am checking this is, I get ORA-65139: Mismatch between XML metadata file and data file errors for all the datafiles (and that is because the pdb plugging in to cdb failed and now the state is such that I cant open non-cdb database because the datafile headers are stamped with cdb database and I cant see this PDB in cdb database because the pdb plugin to cdb failed. To my understanding it is half done. I can modify the xml file if I knew how those values are populated. Some Oracle support notes suggest to go back to non-cdb and create descriptor file; drop the pdb and then retry to plugin. But that does not work for me. Modifying the xml is not supported way but atleast if I can understand how Oracle determines the incompatibilty and throws ORA-65139 that would be useful..

Thank you
Kumar

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jun 26 2021 - 00:39:00 CEST