Just follow your regularly scheduled backup plan. Personally I use the second one you use. Its a little different to recover a read-only tablespace though depending on which control file you use and what state your tablespace was in compared to you control file when failure occurred. There are times when you recover read-only tablespaces and you need to take the tablespace offline first.
The Backup and Recovery Guide should have that info but I use the Oracle Press Backup & Recover Handbook cause its kickass. -----Original Message----- Sent: Tuesday, November 20, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Smith You are talking about backup of conrol file by alter database backup controlfile to trace; or alter database backup controlfile to '/u07/oradata/bckcorp.ctl' reuse; Let me know please Thanks -Seema >From: Kimberly Smith <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: hottbackup questions >Date: Tue, 20 Nov 2001 09:50:49 -0800 > >You cannot take a hotbackup of a read only tablespace. However, >you can copy it somewhere and back it up there. Just make sure >you backup your controlfile though as it reflects that change. > > >-----Original Message----- >Sent: Tuesday, November 20, 2001 9:25 AM >To: Multiple recipients of list ORACLE-L > > >Hi >How to take hotbackup of read only tablespace? >In case of media failure how to restore it? >Thanks >-Seema > >_________________________________________________________________ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seema Singh > 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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
