Michael, We have about 160 DBs connecting to a central RMAN Repository. All Dev/Test DBs connect to one RMAN repository on a separate UNIX box and all the production DBs connect to another Production Repository. Production RMAN repository is clustered using MC/Service guard for high availability. We take exports of RMAN repositories, also RMAN (Test) repository is backed-up to RMAN (Prod) repository and vice versa! Rama =========== "Jenkins, Michael" wrote: > I've logged a TAR on this one with Oracle. They have verified what I > suspected all along. The SAs here don't understand how Oracle performs a > hot backup. There is no difference between raw and cooked file systems as > far as Oracle is concerned when performing a hot backup. Also, the skipping > of the header is only applicable to certain variants of UNIX. > > One other question here. Does anyone have recommendations on the repository > database required for RMAN? Do we need to keep a separate instance on > another production box? Or the same production box? Does everybody have > all of there repository information for all of their database in one > instance? It seems like you would want a separate instance for each > repository and have them staggered across different machines so that the > odds of losing your database and it's repository at the same time would be > low. Any suggestions? > > Thanks for all the replies so far! > > --Michael > > -----Original Message----- > Sent: Friday, June 15, 2001 9:55 PM > To: Multiple recipients of list ORACLE-L > > Michael, > We use RMAN on RAW with EDM (EMC) backups, without any problem. When using > RMAN, it will take care of all blocks that are being changed while the > backup is > going on. Also as EDM interfaces with the Tape library, RMAN will write > directly > to the Tape . Have this set up on about 15 databases and all of them are > working > fine. But occasionally our backups fail on 8.1.6 databases due to lack of > resources on the Server (and some bugs!). > > Rama > > "Jenkins, Michael" wrote: > > > We have parallel server running on on a Sun Cluster 2.2 and we are looking > > for the easiest way to perform hot backups. Now, I know that you have to > > use the "dd" command and skip the header at the beginning. Everything I > > read on metalink indicates that you can use basically the same paradigm as > a > > hot backup on cooked file systems. But, the sysadmins here tell me that > the > > raw device can't be backed up if there is any write activity on the data > > file that is currently being backed up. Now we all know that contrary to > > popular belief there is write activity on a data file even when the > > tablespace is in backup mode. Is "rman" or some other block-level backup > > utility the only way to get a reliable hot backup on raw devices? Does > > anybody have any experience with hot backups that are made while the > > database still has active users logged in? > > > > I look forward to everyone's thought on this. > > > > Thanks. > > > > Michael L. Jenkins > > Oracle Certified DBA > > Nextel Communications > > Norcross, GA > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jenkins, Michael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jenkins, Michael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Malladi;Rama x-mozilla-html:FALSE org:Toyota Motor Sales (USA);Toyota Production Services adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] title:Production Lead / DBA fn:Rama Malladi (Oracle 8i Certified DBA) end:vcard
