The ALL FROM ARCHIVE keywords take the place of the database and/or table names that are normally specified after the DATA, DICTIONARY, JOURNAL, or NO FALLBACK TABLES keywords.
Do not specify any other database or table names to be restored when using ALL FROM ARCHIVE. All databases and tables in the given archive file will be restored, and any existing databases or tables will be overwritten.
CATALOG and Fastpath are not supported while using ALL FROM ARCHIVE. If CATALOG (or Fastpath) is enabled when ALL FROM ARCHIVE is specified, it will be disabled and a warning message will be given.
ALL FROM ARCHIVE cannot be used to restore database DBC, and DBC must be excluded by the user if it is present in the archive being restored.
The EXCLUDE TABLES object option is not allowed when using ALL FROM ARCHIVE.
The ALL FROM ARCHIVE command cannot be used to restore a table that has a join or hash index defined or a database that contains a table that has such indexes defined. See Join and Hash Indexes in Restoring.