We have three separate databases (RCAT80, RCAT815, and RCAT817) which
reside on a separate, small, UNIX box that we only use for backups. All
the 8.0.4
databases are backed up to the RCAT80 database, 8.1.5 databases to RCAT815,
and 8.1.7 databases to RCAT817. Each of these databases has it's own
ORACLE_HOME.
Then we have a second small unix box which hosts RCAT802, RCAT8152, and
RDAT8172
which all have their own ORACLE_HOME. We backup up RCAT80 to RCAT802,
RCAT815 to
RCAT8152, and RCAT817 to RCAT8172.
We use Sun Solaris 2.6 and we also use Veritas file manager and Netbackup
in conjunction
with RMAN.
Cherie Machler
Oracle DBA
Gelco Information Network
"Jenkins, Michael"
<Michael.Jenkins@N To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
extel.com> cc:
Sent by: Subject: RE: Backups on raw devices
[EMAIL PROTECTED]
06/18/01 10:16 AM
Please respond to
ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
