Can not restore data on oracle server

[Firstsun]

My company use Veritas Backup Exec 9.1 and oracle remote agent. I tried to backup database oracle agent. I found that I could backup successful. but when I tried to restore, I could not restore it. It return error a000fe29: Authentication failed on connection to the server. On the job log and item about Error it show me that

Restore - acle_pchit/ICTTS
Access is denied to remote agent

Why oracle database agent is "acle_pchit/ICTTS". It should be "oracle_pchit/ICTTS"?

and this is some error from SGMON.log

--------------------------------------------------------

bengine: 9bc 6/30/2004 17:47:13: SQL2_FindDrives - checking named instance BKUPEXEC.

bengine: 9bc 6/30/2004 17:47:13: SQL2_FindDrives - Sorry, SQL 2000 Agent not autherized.

bengine: 9bc 6/30/2004 17:47:13: Utility Partition/Partition's found on this system.

bengine: 9bc 6/30/2004 17:47:13: ENGSCRPT: ConvertDeviceName osId = 0X2a

bengine: 9bc 6/30/2004 17:47:13: ENGSCRPT: IN - oldDeviceName = ORACLE_PCHIT/ICTTS

bengine: 9bc 6/30/2004 17:47:13: ENGSCRPT: OUT - newName = ORACLE_PCHIT/ICTTS

beserver: 0x0dc8 -1-0630:174713:Client requested key.

beserver: 0x0e10 -1-0630:174713:Client 'FGTSRV01' connected('','NT AUTHORITY\SYSTEM'): 0x2b54b20

beserver: 0x0e10 -1-0630:174713:Client 'FGTSRV01' Disconnected:0x2b54b20

bengine: f68 6/30/2004 17:47:13: DeviceManager: incoming event fired

bengine: f68 6/30/2004 17:47:13: DeviceManager: processing pending requests

bengine: f68 6/30/2004 17:47:13: DeviceManager: query cache miss

bengine: f68 6/30/2004 17:47:13: DeviceManager: query result = 0x00000000



.

.

.



bengine: 9bc 6/30/2004 17:48:27: Job::Mount: media mounted

bengine: 9bc 6/30/2004 17:48:27: Media Label: FOREMOST837

bengine: 9bc 6/30/2004 17:48:27: Media GUID: {F5D3F17B-0328-4043-BFDC-C2BE08326466}

bengine: 9bc 6/30/2004 17:48:27: Overwrite Protected Until: 1/1/1900 12:00:00 AM

bengine: 9bc 6/30/2004 17:48:27: Appendable Until: 12/31/9999 12:00:00 AM

bengine: 9bc 6/30/2004 17:48:27: Block size: 65536

bengine: 9bc 6/30/2004 17:48:27: Buffer size: 65536

bengine: 9bc 6/30/2004 17:48:27: Num buffers: 10

bengine: 9bc 6/30/2004 17:48:27: High water: 7

bengine: 9bc 6/30/2004 17:48:27: TAPEALERT: Get TapeAlert Flags Return Code = 0X0

bengine: 9bc 6/30/2004 17:48:27: TAPEALERT: TapeAlert Device Flag = 0X0

bengine: 9bc 6/30/2004 17:48:27: TAPEALERT: TapeAlert Changer Flag = 0X0

bengine: 9bc 6/30/2004 17:48:27: TAPEALERT: Get TapeAlert Flags Return Code = 0X0

bengine: 9bc 6/30/2004 17:48:27: TAPEALERT: Get TapeAlert Flags Return Code = 0X0

bengine: 9bc 6/30/2004 17:48:27: ERROR: unknown host: ACLE_PCHIT/ICTTS, err=11001

bengine: 9bc 6/30/2004 17:48:27: SetupNDMPConnection: ndmpConnect failed on server ACLE_PCHIT/ICTTS, port: 10000.

bengine: 9bc 6/30/2004 17:48:27: NDMPEngine::Run(): SetupNDMPConnection() returned -472, falling back to local RANT to perform operation.

bengine: 9bc 6/30/2004 17:48:27: NDMP version 3 connection CONNECTED

bengine: 9bc 6/30/2004 17:48:27: NDMPEngine::SetupNDMPConnection(): no authentication method specified, using System Login Account

beserver: 0x0dc8 -1-0630:174827:Client requested key.

beserver: 0x0e10 -1-0630:174827:Client 'FGTSRV01' connected('','NT AUTHORITY\SYSTEM'): 0x2b84ce0

beserver: 0x0dc8 -1-0630:174827:Error(4/4): -1610579488:No records were found on database request.

bengine: 9bc 6/30/2004 17:48:27: NDMPEngine::SetupNDMPConnection(): Failed to retrieve System Login Account from BESERVER, error = -1610579488. Returning NDMP_NOT_AUTHORIZED_ERR

beserver: 0x0e10 -1-0630:174827:Client 'FGTSRV01' Disconnected:0x2b84ce0

------------------------------------------------------

ANY ADVICE?

 

[justin2000]

Firstsun

Try this, not sure if it will work, but does work for files, then the servername is being truncated in the restore job for some reason.

Select what you want to restore, then on the Redirect tab, enter to re-direct and put in just the servername.

See if this works for you.

 

[tech2004]

Did this fix the problem? Or is there another fix? I am having the same problem not being able to restore the oracle database. I have used the system account and created an account called backup within oracle according to veritas' documentation and given it the required rights but still can not restore.

 

[tech2004]

justin2000, thanks for the info. That fixed our problem. I can restore the oracle database now. I had called Veritas support and got no where. Have had this problem for over a month now. They told me that I didnt have to use the re-direct option. I will make them aware of how to get Oracle to restore. Thanks again.

 

[tech2004]

I am able to restore the database files when I use file redirection but it renames the database files with the path name included in the name. It does not overwrite the database even though overwrite files is checked. Is there not a way to get the database to restore without using file redirection? That is the only way I can get it to restore.

 

[LawnBoy]

Yes there's a way out.
1. Have Oracle create it's own backups. Archive these with BE.
2. Unarchive with BE. Have Oracle restore it's own backups.

I've been seriously burned by the MSSQL agent for BE, and no longer trust any 3rd party agent on my databases.