Hi,
While your EMC Standard volumes and BCVs are in synchronized mode (not split), both
Standard and BCV will be updated at the same time. So is better you split instantly
before you end backup your tablespaces. This will ensure your data files in BCV are
backup mode data files before you
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
Nate,
We are looking at the same process. Your Unix Admin is incorrect.
The split needs to happen at STEP 2. Otherwise, what is the point of putting
the tablespaces in hot backup mode? The split is not instant, in fact we are
assuming it will take up to 5 minutes to complete. The only way
Nat,
We have a similar backup strategy using a homegrown split procedure on
Compaq Tru64. We split while all tablespaces are in backup mode as our's is
a controller based split and takes 5-6 minutes. After all, if the split is
going to take place after the tablespaces are taken out of backup
rofl! it should be 1, 4, 5, 2.
[EMAIL PROTECTED] 08/15/02 10:58AM
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
Nate,
We are doing this as well on Solaris w/ Veritas. Our series is:
1) Put everything in hot backup mode
2) Split all volumes EXCEPT archive
3) Take everything out of hot backup mode
4) Log switch
5) Split Archive
We use this for cloning on a nightly basis and haven't had any
issues.
I'm not familiar with BCV but if you are talking about splitting mirrored
disks then this should be done while the Tablespaces are in backup mode.
If the UNIX admin wants to do it this way then why bother doing step 1,2,3.
I've seen this kind of statements EMC will take care ot this but things
You are right that the BCV split should occur at step 2.
Ask him what's the point for step 1 - 3 if he split BCV at step 4.
Is he also splitting the BCV for control file and online redo logs?
Richard
-Original Message-
Sent: Thursday, August 15, 2002 10:59 AM
To: Multiple recipients of
Can you tell us what is the size of the database that is using EMC/BCV or
other Hardware vendor splits mechanism?
Thanks.
Bing Wong
Open Systems Database Administrator
x25721
-Original Message-
Sent: Thursday, August 15, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L
Nat,
We
You are correct.
If EMC was taking care of consistency in *this* case, what is your UNIX
Admin achieving in steps 1,2 and 3? He/She simply do not know how Oracle
works.
There are white papers at emc.com to support you.
- Kirti
-Original Message-
Sent: Thursday, August 15, 2002 9:59
We perform a similar process; but for Read-Only databases. There are some
gotcha's you have to watch out for. Otherwise it works well.
-Original Message-
Sent: Thursday, August 15, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
Nate,
We are doing this as well on Solaris w/
Yes, BCV is also split for control file and online redo logs.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 11:58 AM
You are right that the BCV split should occur at step 2.
Ask him what's the point for step 1 - 3 if
Bing,
Ours is ~630Gb across 19 mountpoints using (Compaq) controller based split
[for both backup reporting instance creation].
Mike
-Original Message-
Sent: Thursday, August 15, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L
Can you tell us what is the size of the database
Maybe my knowledge on EMC/BCV is outdated. But as I remember, for Hotbackup
you don't split BCV for control files and online redo logs as
they are not useable.
Richard
-Original Message-
Sent: Thursday, August 15, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Yes, BCV is also
-- Ji, Richard [EMAIL PROTECTED]
Maybe my knowledge on EMC/BCV is outdated. But as I remember, for
Hotbackup you don't split BCV for control files and online redo logs as
they are not useable.
You have to use the live system's redo's. Because they are
opened read+write (this was a bug in
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.
Ave !
Why there is that step 2 (sleep 5)? I assume,
that the backup script (or whatever) runs straight forward
without spawning any simultaneous running subprocesses
of course.
Just curious.
Br.
Jorma
-Original Message-
Sent: 15 August, 2002 18:39
To: Multiple recipients of list
17 matches
Mail list logo