Bing, Please explain your reasoning for backing up the archivelogs when you backup the readonly tablespaces. One reason you change a tablespace to read only is to reduce the backup needed. After a tablespace is in read only mode no changes are made to the data and you only need to back it up once and store the tape. If restoral is needed du to a disk failure then the backed up read only tablespace can be restored successfully. If you change the tablespace to read write at a future time then you need to perform a backup of the tablespace to reflect the change that is noted in the controlfile. If you "backup controlfile to trace" with a tablespace in read only and then with the tablespace in read write you will see the differences that the controlfile tracks. ROR mª¿ªm
>>> [EMAIL PROTECTED] 11/20/01 02:25PM >>> When you backup the read-only tablespace, you must backup the archive logs (if any) as well. -----Original Message----- Sent: Tuesday, November 20, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Ya but you don't normally backup a read-only tablespace. The whole reason I make them read-only is to ensure that I finish the backup this century. -----Original Message----- Sent: Tuesday, November 20, 2001 11:01 AM To: Multiple recipients of list ORACLE-L My hot backup is to put one tablespace in backup mode one at a time and copy that data file to disk and alter it back online. No problem Bing -----Original Message----- Sent: Tuesday, November 20, 2001 10:28 AM To: Multiple recipients of list ORACLE-L My fault, I should have said copy. Climbing night last night so I am dead tired. Thanks for the input. -----Original Message----- Sent: Tuesday, November 20, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Kimberly, You can change a tablespace to read only with no problems and you should take a backup to capture the change. Your last paragraph stated you wanted to "move the datafile to the disk that the tape backup picks" That will cause you problems if you move the datafile. You should copy the datafile because the Oracle knows that it is located at disk-1 not disk-2. Your users can still select from the tablespace as usual and if I remember correctly they can truncate if they have the priviledge but not delete from. I use the same method every 6 months. Archive older data to a read only tablespace that contains my archive tables. Remember, all of the tablespaces in the datafile have to be read only. ROR mª¿ªm >>> [EMAIL PROTECTED] 11/20/01 11:40AM >>> Just throwing something out cause I am not sure if I am thinking correctly. I have a database that is not using partitioning so we split each month out into seperate tables/indexes by month and store them in their own tablespaces. These are kinda big so we occasionally put a tablespace into read-only mode, shutdown the database, perform a cold backup right to tape. Problem is, we are putting this database into ServiceGuard. Its kind of a big pain in the butt to shutdown a database that is running in ServiceGuard yet still have the disks available. So I will now have to start handling this will the hot backup. NOTE: not using RMAN and really don't want to. Its not that I don't trust it, just not worth it in this environment. I am thinking that everything will be ok if I put the tablespace into read-only, move the datafile to the disk that the tape backup picks up during the OS backup along with a backup control file. I should then be able to recover this with no issues. Sound logical? ________________________________________ Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing 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] I am thinking that everything 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: Wong, Bing 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 Rogers 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).
