28.4.1 Parameter Configuration and Execution

Set the required configuration file parameters in the default configuration file $FIORANO_HOME/fmq/profiles/recovery.properties or in the user defined file (absolute path of the configuration file should be explicitly mentioned as parameter –propertiesFile <path of the file> while running the tool).
Execute the DB Recovery tool by running the recover-database.bat/ recover-database.sh which can be found under $FIORANO_HOME/fmq/bin with the necessary parameters.

Example: Using Unix/Linux:
$ ./recover-database.sh RunExtractor -profile FioranoMQ_XA -dbPath $FIORANO_HOME/fmq/profiles/Fiorano_XA/run

3. Now the user can verify the results of the DB analysis through the log files which will get generated in $FIORANO_HOME/fmq/bin.

Example:
Consider the analysis has been done for PTP DB.
$FIORANO_HOME/fmq/bin/ptpResults.log
$FIORANO_HOME/fmq/bin/ptpUnableToRecoverData.log

28.4.2 DBRecovery

On setting the RECOVER_DB property to true i.e. RECOVER_DB=true (in fmq/profiles/recovery.properties file ) will not only analyze the DB but also recover the DB if found corrupted.
The recovered DB entry/table files will be generated in a new directory which will be created by adding suffix .New to the default name, that is, PTP.New, if the value of RENAME_DIRECTORY property is set to false (in fmq/profiles/recovery.properties file ). Then the user has to manually rename the original DB directory with suffix .Old i.e.PTP to PTP.Old and the newly recovered DB directory by removing the suffix .New to default i.e. PTP.New to PTP.
If the RENAME_DIRECTORY property is set to true then by default, the corrupted DB will be renamed with suffix .Old i.e. PTP to PTP.Old and also renames the recovered database to default by removing the suffix .New i.e. PTP.New to PTP .No manual renaming is required.
If the user set the RECOVER_DB property to false i.e. RECOVER_DB=false (in fmq/profiles/recovery.properties file) then only the analysis of DB will be performed and the results will be logged.