Thanks Oscar, we are running 9i.
-----Original Message-----
From: MSU Network Administrators Group [mailto:[log in to unmask]] On
Behalf Of Oscar Castaneda
Sent: Tuesday, October 09, 2007 2:37 PM
To: [log in to unmask]
Subject: Re: [MSUNAG] Oracle assistance
I work my oracle backups exactly as Dennis is suggesting. I have a few
scripts that dump my data to text or csv files, or ORACLE export files
and then i backup those files.
Has been working perfect for a few years now. I would happy to share my
scripts with you. They are very simple.
BTW, what version of ORACLE are you running?
>>
>>
>> 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
>>
>>
>>
>
>
>
--
Oscar Castaneda
Michigan State University
|