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