Hi Jon,
Are you doing a manual restore or are you using the GUI? Also, what are the
manifestations on your Commserve?
Regards
On Thu, 20 Jul 2017 13:19:42 +0100
John Hallas <john.hallas@xxxxxxxxxxxxxxxxxx> wrote:
We don't get an error, RMAN sends a request to the MML and CV interrogates
the SQL Server database to find all the pieces and that interrogation never
completes. It takes about 4 minutes on a 2Tb size database but never
finishes for us -we have run it for 24+ hours and it all it does is cause
problems for other CV backups that are running.
Note this is only on the restore - the backup works fine
On 20 July 2017 at 12:20, <rogel@xxxxxx> wrote:
what's the ORA-error you get ?
*Gesendet:* Donnerstag, 20. Juli 2017 um 13:05 Uhr
*Von:* "John Hallas" <john.hallas@xxxxxxxxxxxxxxxxxx>
*An:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*Betreff:* Simpana Commvault V10 - large database restores
We have an 80TB database which we back up successfully to Commvault V10.
However we cannot perform a restore now it has grown to this size.
We did manage to restore at about 40Tb but are struggling now.
It ends up thrashing the CV SQL server database looking for all the
pieces.
We are working with Simpana but we have not had much back, in particular
re whether we have hit any database size limitations within CV
The SQL code behind the restore:
EXEC CV_ExecuteSP 'archFileByName', N'
N''9579374_XXXYYY2A_4fs7uujn_29_1'',0,0,5853,0,1,0,0',
'00010012000000000000', 0, 0, 78644, 'DBLog', 'Instance001', 'cvd.exe'
EXEC CV_ExecuteSP 'archFileByName', N'
N''9579374_XXXYYYA_4as7uuj2_114_1'',0,0,5853,0,1,0,0',
'00010012000000000000', 0, 0, 78644, 'DBLog', 'Instance001', 'cvd.exe'
John
------------------------------
