Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup strategy

RE: Backup strategy

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 21 Nov 2001 07:09:28 -0800
Message-ID: <F001.003CA8CF.20011121061523@fatcity.com>

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 mm

>>> bing.wong_at_IngramMicro.com 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 mm

>>> kimberly.smith_at_gmd.fujitsu.com 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: 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: Ron Rogers
  INET: RROGERS_at_galottery.org

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: Wong, Bing
  INET: bing.wong_at_IngramMicro.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.comi 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: 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: Wong, Bing
  INET: bing.wong_at_IngramMicro.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 Rogers
  INET: RROGERS_at_galottery.org
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 Wed Nov 21 2001 - 09:09:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US