Page Comparison

...

impdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN

Import will fail to create Materialized view. You need to follow these steps to fix it.

DROP table FD.VAPPLICATIONSTATISTICS;

-- find CREATE MATERIALIZED VIEW FD.VAPPLICATIONSTATISTICS from FDOracleGenerateProcedures.sql and execute it.
-- now grant permissions

grant SELECT on FD.VAPPLICATIONSTATISTICS to FD_ADMIN;

• At this point, the Test FlexDeploy database should be copy of Production database.
• Copy artifacts zip file to Test FlexDeploy server and extract it in the artifact repository folder. You can determine Artifact Repository folder by looking at flexagon.fd.repository.root system property on server command line. Make sure to run this on Test environment only.
  
  • cd /flexdeploy/artifacts
  • tar -czvf /app/backup/flexdeploy_artifacts_test.tar.gz *
  • rm -rf *
  • tar -xzvf /app/backup/flexdeploy_artifacts_prod.tar.gz
• Now FlexDeploy artifact repository is also copied.

...