'ORA-39246: cannot locate master table within provided dump files' error restoring an RSA Identity Governance & Lifecycle oracle database
Originally Published: 2019-11-26
Last Modified: 2023-11-30
Article Number
000043618
Applies To
RSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: All

 
Issue
When restoring an RSA Identity Governance & Lifecycle oracle database, the following errors occur and the restoration of the database fails:
  
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
Cause
When a database export occurs, the first table created at the startup of the export process is a master table which maintains the location of database objects inside the dump file. This error occurs when the import cannot find this file either because the exported database dump file is corrupt or because not all the exported dump files were supplied at the time of the import, specifically the one containing the master table.

 
Resolution
If this is a non RSA-supplied database, please check with your oracle DBA.

If this is an RSA-supplied database, check the export log file (/home/oracle/AveksaExportImportDir/Export_AVDB_avuser-YYYY-MM-DD-##-##) that was generated during the database export for a list of dump files created. If multiple dump files were created, make sure all of the exported files are copied to  /home/oracle/AveksaExportImportDir for import.

If that does not resolve the issue or if there is only one dump file, then your backup is corrupt and another backup needs to be used for import.

For more information on exporting and importing an RSA Identity Governance & Lifecycle oracle database, please see RSA Knowledge Base Article 000038174 -- How to backup (export) and restore (import) an RSA Identity Governance & Lifecycle oracle database.

Related Articles

Trending Articles

Don't see what you're looking for?