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: Tue, 20 Nov 2001 10:21:42 -0800
Message-ID: <F001.003C9A44.20011120101018@fatcity.com>

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

>>> 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).
Received on Tue Nov 20 2001 - 12:21:42 CST

Original text of this message

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