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