| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Backup strategy
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?
-- 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-LReceived on Tue Nov 20 2001 - 11:02:52 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |