Cisco Prime not Restoring

[ChikeBrown7363]

Please I need your help Guys. We had an issue with my company prime infrastructure hosted on a VM so I did NCS cleanup and NCS run reset db. We also have a remote FTP for backup but whenever I try to do a restore from the remote ftp, it stops at 7 of 9 with error recovering and restoring backup despite having numerous backups on the Remote FTP server. Can anyone help me with a solution to the issue?

[balaji.bandi]

are you restoring the saved version of PI the backup took place? where is your FTP in the same location or far away, never seen this before as per my experience,

Can you post the exact error of the screenshot?  how about download and doing from Local Computer connected to Prime back to back connection with direct cable?

I am sure the prime back is big large as i see last time it was for one of the environments to go to 90GB.

[ChikeBrown7363]

Hi Balaji,

This is the log output below:

wccp01/admin# show restore log
Started at : Tue Mar 16 22:18:53 2021
Initiating restore. Please wait...
Restore Started at 03/16/21 22:18:53
Stage 1 of 9: Transferring backup file ...
-- completed at 03/16/21 22:28:03
Stage 2 of 9: Decrypting backup file ...
-- completed at 03/16/21 22:39:35
Stage 3 of 9: Unpacking backup file ...
-- completed at 03/16/21 22:39:39
Stopping PI server ...
Stage 4 of 9: Decompressing backup ...
-- completed at 03/16/21 22:40:53
Stage 5 of 9: Restoring Support Files ...
-- completed at 03/16/21 22:41:02
Stage 6 of 9: Restoring Database Files ...
-- completed at 03/16/21 22:41:36
Stage 7 of 9: Recovering Database ...
Error while restoring and recovering database. Please retry restore with anoth
er backup.
If the restore continues to fail, please open a Case with TAC.

And below is the Backups:

wccp01/admin# show repository CiscoFTP
cdp-3.500.187.xar
PI-Upgrade-3.0.X_to_3.1.0.0.132.tar.gz
PI_3_1_3-1.0.16.ubf
Test_20200506
totallogs-180528-1419.tar.gz
wccp01-210117-1703__VER3.3.0.303.107_BKSZ215G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK1
352365678.tar.gpg
wccp01-210124-1703__VER3.3.0.303.107_BKSZ216G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK1
420479782.tar.gpg
wccp01-210131-1703__VER3.3.0.303.107_BKSZ215G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK1
011069844.tar.gpg
wccp01-210207-1703__VER3.3.0.303.107_BKSZ216G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK7
97248104.tar.gpg
wccp01-210221-1703__VER3.3.0.303.107_BKSZ215G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK3
907540884.tar.gpg
wccp01-210228-1703__VER3.3.0.303.107_BKSZ214G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK2
438170984.tar.gpg
wccp01-210307-1703__VER3.3.0.303.107_BKSZ214G_CPU8_MEM16G_RAM62G_SWAP15G_APP_CK3
947438994.tar.gpg

Is there anything you can advise me to do?

Thanks for your support.

[balaji.bandi]

You have different backups, try different one older date and see is there any difference , if you see same issues all of them, then Looks like you may be hitting with Bug here : (if you have contract raise a TAC Case please )

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvv79100/?rfs=iqvred

[joyaljp]

Did you restart the PI before doing a restore, sometimes a restart resolves the DB restoration errors?

If this also doesn't resolve your issues your DB must have been corrupted. You will have to reimage your PI and then restore the backup.