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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 : [EMAIL PROTECTED] > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Pat Howe > > 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: Ron Yount > 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: Kimberly Smith > 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). ===== 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: [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).
