 |
 |
I don't know enough about Oracle, but is it possible to replicate your database to a separate staging area and then back that up? That way you wouldn't have to backup a live service. --Ray On Oct 9, 2007, at 12:42 PM, Javier Ornelas wrote: > We have an Oracle database and are in urgent need of some Oracle > assistance. Can anyone recommend a good Oracle consultant for on- > site help? The help we need is related to backing up our Oracle > database. It is a couple hundred GB in size and we need to do a > hot backup of the database to keep the application up and running > while backup is taking place. > > > One of the backup options that we tried is purchasing Symantec > Backup Exec 11d and its Oracle agent. We set up a server with the > Backup Exec 11d software including the Oracle agent. On the Oracle > server, I installed the Backup Exec Remote Agent. Here’s our > problem when trying to use the Backup Exec product: Our Oracle > database SID and the Oracle database name are not the same. The > Remote Agent when I setup the Oracle portion of it lists the Oracle > local instance name as ORA7. ORA7 is not the database name that we > are using. Since our username of “backup” is not found in the > database called ORA7, we get authentication problems. I cannot > type over the Oracle local instance name of ORA7 with our database > name. The Remote Agent is finding this local instance name from > two things (according to Symantec tech support): services and > registry. We have tried to change items in the registry and this > did not help matters. ORA7 is still the only listed Oracle > instance name found by the Remote Agent. > > > > Symantec has told me that this isn’t their problem and that we need > to fix things on our end. This would mean a total rebuild of the > Oracle database. Needless to say, Symantec isn’t an option that we > are going to pursue any longer. > > > > Any recommendation for an Oracle consultant would be greatly > appreciated. > > Thanks, > > > > Javier Ornelas > > MSU Health Information Technology > > Network Services/Support > > A118K Clinical Center > > East Lansing, MI 48824 > > (517) 355-6531 > > (517) 432-4774 fax > > > >