Oracle DB restore to another server script

[Alien]

Hello, we will need restore Oracle DB to another server every day. I created PS script, but I have a proble with one error code. User ct\OracleHome has admin permisson on target server and Oracle services run under this account. Manualy restore from a console works fine.

Code: Select all

asnp veeampssnapin
Connect-VBRServer -server veeam-oracle.ct.czech-tv.cz
$pvproDB = Get-VBRApplicationRestorePoint -Oracle -Name "vmo10.ct.czech-tv.cz" | Sort-Object CreationTime -Descending | Select -First 1
$locations = Get-VBROracleDatabase -ApplicationRestorePoint $pvproDB -Name "PV2PRO"
$guestcreds = Get-VBRCredentials -Name "ct\OracleHome"
Start-VBROracleDatabaseRestore -Database $locations -ServerName "vmo09.ct.czech-tv.cz" -GuestCredentials $guestcreds -OracleCredentials $guestcreds

Error code is

Code: Select all

Start-VBROracleDatabaseRestore : Specify credentials for the Oracle service account CT\OracleHome
At line:1 char:1
+ Start-VBROracleDatabaseRestore -Database $locations -ServerName "vmo0 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Start-VBROracleDatabaseRestore], Exception
    + FullyQualifiedErrorId : System.Exception,Veeam.Backup.PowerShell.Cmdlets.StartVBROracleDatabaseRestore

[tdewin]

Not sure of course, but I think you need to supply credentials to login into oracle itself like for example sys (sysdba). So not OS credentials but Oracle authentication

Have you tried restoring via the GUI with the same credentials to see if that works

[Alien]

Hello, script is function. Problem was in account credential. Script is case sensitive and error was in account "ct\OracleHome" where must be "CT\OracleHome". It is a crazy, uffff.