Oracle-L: RE: split mirror backups and alter system suspend

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Thu, 09 Jan 2003 14:44:05 -0800
Message-ID: <F001.0052BD3C.20030109144405@fatcity.com>

1/2. Not necessarily. You only need to suspend database if your hardware won't let you split the mirror without

suspending IO. I worked on EMC which doesn't require that. So all you need to do is put tablespaces into

backup mode, split the mirror and end backup mode. 3. Application doesn't need to be brought down just as if you are doing a hot backup.

Richard Ji

-----Original Message-----
Sent: Thursday, January 09, 2003 5:00 PM To: Multiple recipients of list ORACLE-L

Hi,
We're getting ready to implement split mirror backups for the first time and wanted to check on what others are doing. The thought was to put the tablespaces in backup mode, split the mirror, backup the mirror, and then resynch the drives. The split mirror would be backed up using an OmniBack filesystem backup.

I believe that an additional step of putting the database in suspend is required prior to the split. Is this correct?
Is this a hardware vendor specific requirement? (we are using HP hardware all the way through)
Do applications using Oracle, such as SAP, need to be brought down during any part of this?

Any experiences or recommendations are welcome.

Thanks,
Russ

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Richard Ji
INET: richard.ji_at_mobilespring.com

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 Thu Jan 09 2003 - 16:44:05 CST