| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> re BCV / SnapShot / SnapClone and the ALTER SYSTEM SUSPEND --
Mladen,
Is the "ALTER SYSTEM SUSPEND" really necessary.
We've just implemented SnapClone mechanims for three Oracle DBs on
Hitachi and EMC SANs, We've been told that only ALTER TABLESPACE ... BEGIN
BACKUP
is necessary.
What we do is
1. Issue an ALTER TABLESPACE ... BEGIN BACKUP for all the tablespaces
2. "split" the image for the /oradata? filesystems
3. Issue an ALTER SYSTEM ARCHIVELOG CURRENT {and also ALTER DATABASE
BACKUP CONTROLFILE TO ..}
At 07:24 PM 09-01-04 -0800, you wrote:
>Let me explain, because I have a little bit of experience with it.
>a) BCV's are replicated disks which are synchronized using TimeFinder.
> and then separated from the source. The phrase "splitting BCV's" means
> producing an exact disk copy of the original disks, similarly to what
> dd can
> do. It's an ideal way to make a copy of an instance. Last time I
> checked,
> BCV's weren't supported by RMAN (it may have changed now), so the
> tablespaces had to be put into backup mode or (8i and after) the database
> had to be suspended (very litle known trick is "ALTER SYSTEM SUSPEND",
> which abruptly ceases all the I/O in the database, without shutting
> it down).
>b) RMAN is an oracle tool which works in conjunction with Legato (EMC),
>NetBackup(Veritas),
> Tivoli, Alexandria or SyncSort backups. RMAN doesn't know how to
> write to tape and needs
> a 3rd party backup to do so. The part that Veritas, Legato or IBM
> will charge you for is
> called libobk.so and is an interface which enables RMAN to work with
> their particular tool.
> RMAN is a very good tool which can do many things in a very easy way
> and without
> generating a TB of redo archives for the duration of hot backup mode.
> Robert Freeman's
> book is definitely the best source for anything RMAN around.
>
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 05-Jan-04}
-- 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 Fri Jan 09 2004 - 23:09:26 CST
 |
 |