Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND
Some of my databases will be migrating to a SAN.
Currently, I run hot backups to disk using the
ALTER TABLESPACE <tbs> BEGIN BACKUP ;
host cp <file> <target>;
ALTER TABLESPACE <tbs> END BACKUP
On a SAN, where the vendor promises server-less backups
using Snapshots, I guess I would have to issue the
commands :
ALTER TABLESPACE <tbs1> BEGIN BACKUP
..
..
ALTER TABLESPACE <tbsN> BEGIN BACKUP
ALTER SYSTEM SUSPEND
....> take a "snapshot"
ALTER SYSTEM RESUME
ALTER TABLESPACE <tbs1> END BACKUP
..
..
ALTER TABLESPACE <tbsN> END BACKUP
Would that be right ? What are real-world experiences [bugs / time required for the SUSPEND/RESUME, actually flushing all I/O to the disks] ?
The SAN will be a Hitachi 9970 sold by Sun. The databases will be 8.1.7 32-bit / 64-bit on Solaris 8.
Hemant K Chitale
http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: hkchital_at_singnet.com.sg Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Mar 25 2003 - 22:48:36 CST
![]() |
![]() |