Hello Kimberly,
RMAN doesn't put *anything* into hot backup mode
(read-only or not) during a "hot" backup, so a
readonly tspace can be backed up as per any other
tablespace.
Because has access to the SGA, rman can take advantage
of being able to get a consistent image of a block
without worrying about backup modes et al..
hth
connor
- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote: >
How can RMAN backup a read only tablespace? I mean
> if you forget
> to tell it to ignore read only tablespaces. I know
> it could do
> it in cold but in hot you cannot put a read only
> tablespace into
> backup mode. Maybe it does not use the same method
> as a hot backup????
> Just curiosity getting the best of me. Its amazing
> what will
> bug me as I wait for supper.
>
> -----Original Message-----
> Sent: Friday, January 04, 2002 7:02 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Unless you explicitly tell RMAN to skip read-only
> tablespaces, it will back
> them up the first time around, once that is done, it
> will not back them up
> again unless you alter the tablespace from read-only
> to writeable.... then
> RMAN is intelligent to know that its original backup
> copy may no longer be
> valid, so it grabs another.
>
> There is an inherent caveat to this.... if you back
> up to tape, retain tapes
> on-site for two months, then have the tablespace
> become corrupt after 3
> months... you will not be able to restore without
> bring the tape back
> on-site... so you may want to "trick" rman
> periodically (hopefully at least
> as often as your tapes are taken off-site) by
> issuing a command to put it in
> "read/write" mode then switch it right back to
> "read-only" to force a new
> copy on you backup set.
>
> HTH,
> -Ron-
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On
> Behalf Of Pat Howe
> > Sent: Friday, January 04, 2002 3:21 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RMAN ReadOnly Tablespace Question
> >
> >
> > With "RMAN Incremental backups" will a Level 0
> backup always backup "ALL"
> > tablespaces including previously backed up
> READONLY tablespaces ?
> > Or is RMAN smart enough to realize that it has a
> current backup of all the
> > READONLY tablespace and only backup the READ/WRITE
> tablespaces ?
> >
> > Thanks in Advance
> >
> > _________________________
> > Patrick J. Howe
> > Oracle DBA
> > Illuminet Inc. (Carrier Division of Verisign)
> > 4501 Intelco Loop SE
> > Olympia, WA 98507
> > Phone : 360.493.6284
> > Email : phowe_at_illuminet.com
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Pat Howe
> > INET: phowe_at_Illuminet.com
> >
> > 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: ListGuru_at_fatcity.com (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: Ron Yount
> INET: ronwy_at_swbell.net
>
> 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: ListGuru_at_fatcity.com (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: Kimberly Smith
> INET: ksmith2_at_myfirstlink.net
>
> 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: ListGuru_at_fatcity.com (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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Sat Jan 05 2002 - 04:29:19 CST
