Re: Simpana Commvault V10 - large database restores

Hi John,

Sorry for not responding sooner, but I've been busy. What do you mean by "thrashing SQL server"? Is it running out of memory, CPU power, disk IO, or something else? How old is your backup? If you managed to restore the control file, all of the parts should be there. Regards

On Thu, 20 Jul 2017 12:05:08 +0100
John Hallas <john.hallas_at_morrisonsplc.co.uk> wrote:

> 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
>

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l