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
|