| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: hottbackup questions
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 <kimberly.smith_at_gmd.fujitsu.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: oracledbam_at_hotmail.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: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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: Seema Singh INET: oracledbam_at_hotmail.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: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.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).Received on Tue Nov 20 2001 - 13:27:13 CST
 |
 |