Re: Hot Backup using EMC /BCV splits

1. "begin backup" for all tablespaces in the database
2. you might want to add "alter system suspend" after if it's 8i and above. Then check database_status in v$instance for "SUSPENDED". It allows currently running i/o's to complete and suspends the rest. allows for a more consistent backup.
3. Split the BCV's
4. Sleep 5
5. "alter system resume" to allow queued up i/o's
6. "end backup" for all the tablespaces
7. Mount BCVs on another machine and run them to tape.
   • Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 15, 2002 9:58 AM

> Hello,
>
> We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the
> backups for the database in following sequence to do the Hot backup.
>
> 1. Put all tablespaces in the database in Hot backup mode
> 2. Sleep 5
> 3. Put all the tablespaces back into normal mode
> 4. Split the BCV's
> 5. Mount on another machine and backed up from it.
>
> What I am concerned is with step 4. Split BCV's should be done at step 2
> instead of step 4.
> According to our Unix Admin, EMC takes care of consistency and there is no
> need for any concern. As per him the split is instant split and EMC
> guarantees consistency.
>
> What do you all think. What is the recommended procedure.
>
> TIA,
>
> Nate
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nat
> INET: nat2710_at_hotmail.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: Steve Perry
  INET: sperry_at_sprynet.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).