Nate,
We are using EMC and BCV's each night to create both backups and a reporting
database. Your SA has it WRONG.
1) Put all tablespaces in hot backup mode
2) sleep 5
3) split the bcv
4) return tablespaces to normal
The reason that this is important has nothing in the world to do with EMC and
everything to do with Oracle. Since switching the database files into and out
of hot backup causes an immediate write to the file headers locking or unlocking
the SCN. Consequently your backups are inconsistent and consequently worthless.
The reason is that when you enter hotbackup mode all of the file SCN's are
frozen giving Oracle a known starting point for recovery's sake. By switching
back to normal mode the RDBMS has no idea of which transactions are in the files
and which are not. It assumes that it is seeing an instance crash and will only
use the on-line redo. Your DB will come up, but don't expect it to stay that
way, ours crashed with "block corruption" 45 minutes later. Believe me, we
tried it due to a misinformed EMC person(that doesn't happen does it?) & failed.
Dick Goulet
____________________Reply Separator____________________
Author: "Nat" <[EMAIL PROTECTED]>
Date: 8/15/2002 6: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:
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).
