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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
