Oracle Snapsync Fails Due to exception.oracle.snl.file.index.notfound (KBA11152)
KBA
KBA#11152
Issue
PDB SnapSync is failing due to the following error:
Error Block has invalid file index: 0. Error Code exception.oracle.snl.file.index.notfound Suggested Action Validate backup files with backup utility.
Prerequisites
Source PDB was created as a snapshot copy. This can be verified by checking SNAPSHOT_PARENT_CON_ID value from v$containers.
Important: The PDB must be open, otherwise this field will always be null.
A non-null value indicates that the PDB is a snapshot copy.
SQL> select con_id,name,open_mode,snapshot_parent_con_id from v$containers;
CON_ID NAME OPEN_MODE SNAPSHOT_PARENT_CON_ID
---------- -------------------- ---------- ----------------------
1 CDB$ROOT READ WRITE
2 PDB$SEED READ ONLY
3 PDB1 MOUNTED
4 PDB2 MOUNTED
5 GOLDEN MOUNTED
8 PDB2CLONE READ WRITE 3
6 rows selected.
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
-
Date Release Jun 20, 2024 24.0.0.0 May 22, 2024 23.0.0.0 Apr 17, 2024 | May 8, 2024 22.0.0.0 | 22.0.0.1 Mar 20, 2024 | Apr 2, 2024 21.0.0.0 | 21.0.0.1 Feb 21, 2024 20.0.0.0 Jan 25, 2024 19.0.0.0 Dec 20, 2023 | Jan 10, 2024 18.0.0.0 | 18.0.0.1 Nov 21, 2023 17.0.0.0 Oct 18, 2023 16.0.0.0 Sep 21, 2023 15.0.0.0 Aug 24, 2023 14.0.0.0 Jul 24, 2023 13.0.0.0 Jun 21, 2023 12.0.0.0 May 25, 2023 11.0.0.0 Apr 13, 2023 10.0.0.0 | 10.0.0.1 Mar 13, 2023 | Mar 20, 2023 9.0.0.0 | 9.0.0.1 Feb 13, 2023 8.0.0.0 Jan 12, 2023 7.0.0.0 Releases Prior to 2023 Major Release All Sub Releases 6.0 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0, 6.0.16.0, 6.0.17.0, 6.0.17.1, 6.0.17.2
Resolution
Delphix does not support snapshot copy PDBs as a dSource. The PDB dSource should be linked to the source PDB.
Related Articles
The following articles may provide more information or related information to this article:
- N/A