This post is more than 5 years old
23 Posts
0
1550
July 4th, 2008 04:00
Mirrorview and Oracle
HI,
i have to replicate one oracle database from a CX500 to a CX700 using mirroview/A.
With the dba we want to do a manual sincronization of the luns, and during this actiity put the database in begin/backup mode.
But, now i have a doubt about this, can i perform the manual sincronization without use the begin/backup mode with the creation of the consistency groups?
Thank's
i have to replicate one oracle database from a CX500 to a CX700 using mirroview/A.
With the dba we want to do a manual sincronization of the luns, and during this actiity put the database in begin/backup mode.
But, now i have a doubt about this, can i perform the manual sincronization without use the begin/backup mode with the creation of the consistency groups?
Thank's
No Events found!
RRR
6 Operator
•
5.7K Posts
0
July 4th, 2008 04:00
Consider this: it's the point in time from when the primary and secundary are not containing the same data anymore that matters.
So whith Snapview or Clones, the point where you start it is the point where you'd want the database to be consistent (backup mode).
With MirrorView it's the point in time when you decide to stop the replication that counts. So at that time the db needs to be consistent.
aettorre
23 Posts
0
July 4th, 2008 05:00
I can create the consinstency group and do the mirror of this online?
Also if the customer want to perform manual sincronitazion using script?
And I can do the sincronitazion with the database in open state?
But if i break the mirror in this time i have to put th db in begin/backup mode to have the second copy in consistent state?
RRR
6 Operator
•
5.7K Posts
1
July 4th, 2008 06:00
Array based replications, whether it is snapshotting, cloning or replication using MirrorView is done withing the array (or 2 arrays). Hosts don't know what's going on. But if you want a usable copy, you need to break the mirror with the db in a consistent state.
You could script that the db goes into some sort of hot/backup mode and then you do the mirrorview commands. The consistency group should be created before you begin to mirror everything in the first place. After the mv commands, the db can continue as needed.
calle2
133 Posts
1
July 4th, 2008 07:00
RRR
6 Operator
•
5.7K Posts
0
July 4th, 2008 08:00
calle2
133 Posts
0
July 4th, 2008 12:00
You can provide pre- and postreplication scripts to perform any specific tasks before and after the replica is created; however, if you to choose to specify pre- and postreplication scripts, the prereplication script must invoke the Oracle Online Backup mode and the postreplication script must release the database from Online Backup mode. If you do not provide pre- and postreplication scripts,
Replication Manager performs these tasks for you...
aettorre
23 Posts
0
July 5th, 2008 06:00
to summarize all my idea.
i can set up the consintency groups and the mirror of them with the db in open state.
I will choice, as customer want, the manual sincronization.
When I have to perform the manual sincronization of the two consintency groups i can have the database online.
But when i will fracture the mirror before to do this i have to put the db into some sort of hot/backup mode.
Is it correct?
aettorre
23 Posts
0
July 5th, 2008 06:00
to summarize all my idea.
i can set up the consintency groups and the mirror of them with the db in open state.
I will choice, as customer want, the manual sincronization.
When I have to perform the manual sincronization of the two consintency groups i can have the database online.
But when i will fracture the mirror before to do this i have to put the db into some sort of hot/backup mode.
Is it correct?
aettorre
23 Posts
0
July 7th, 2008 01:00
RRR
6 Operator
•
5.7K Posts
0
July 7th, 2008 01:00
At that point the copy of the data on the mirror needs to be a restartable database and for that it needs to be either down or in hot backup mode.
RRR
6 Operator
•
5.7K Posts
0
July 7th, 2008 04:00
could you mark the question that helped you most as "correct" and 2 helpful ones as "helpful" ? This will direct visitors of this forum from your question straight to the answers, which speeds things up if a thread is very long.