 |
 |
On Oct 9, 2007, at 1:30 PM, Vasquez, Timo wrote: > Ray brings up a great point, making a cluster/setting up replication. > Not sure how Oracle works in that sense but can you do log shipping > and > move copies of containers to a second oracle server? Is you > environment > 24hr? Can you have back up times that are when no one is in the > production environment? If not look into moving copies to you > offline > server. Antidotally, we use a combination of what Ray suggested and what Dennis suggested for MySQL. We use MySQL's replication facility to replicate a read-only instance to another box (in another building), and we then dump the database in the form of SQL statements and back *that* up. That way, we have a slave server, ready at all times to flip to the master in the case of failure (manual fail-over), as well as a simple backup/restore procedure. ./mk > -----Original Message----- > From: MSU Network Administrators Group [mailto:[log in to unmask]] On > Behalf Of Ray Hernandez > Sent: Tuesday, October 09, 2007 1:24 PM > To: [log in to unmask] > Subject: Re: [MSUNAG] Oracle assistance > > 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 >> >> >> >> > -- Matt Kolb <[log in to unmask]> Academic Computing & Network Services Michigan State University