Unsolved
This post is more than 5 years old
14 Posts
0
429
June 29th, 2006 08:00
Replying DB Oracle with Replistor
Hi Guys,
Someone here has experiences working with replication of Oracle_DB on RepliStor
Some times when I try to start an application based Oracle on my contingency site (RepliStor Target Server). I receive errors messages (data base corrupt). And I cannot start application.
Some times I use a tool of oracle (recovery) that repair a Dada base, but some times a oracle recovery can¿t repair de DB..
I Thank, all suggestions.
Someone here has experiences working with replication of Oracle_DB on RepliStor
Some times when I try to start an application based Oracle on my contingency site (RepliStor Target Server). I receive errors messages (data base corrupt). And I cannot start application.
Some times I use a tool of oracle (recovery) that repair a Dada base, but some times a oracle recovery can¿t repair de DB..
I Thank, all suggestions.
No Events found!
midenuma
3 Posts
0
August 3rd, 2006 18:00
I had same symptom.
Environment:
Windows2003+ SP1
RepliStor6.1.2
Oracle10g R2
Step:
Create Specification for :\oracle\product\10.2.0\oradata\orcl
Create Ailias with Name, IP Adress and Services
I used an IP address for a listener.
RepliStor work failover. But, when RepliStor failback by manual, RepliStor break an Oracle database. I have no idea.
Could anyone do a report working correctly ?
Thank you.
yito1
262 Posts
0
August 17th, 2006 19:00
Environment:
SRV1 ---> Source site
SRV2 ---> Target site
SRV3 ---> Alias
Windows2003 SP1
Oracle10g Release2
RepliStor 6.1.2
Procedure
1.Oracle10g is installed in both servers by the same composition.
2.The Oracle Database directory is composed of Specification of RepliStor.
Example:
SRV1 O:\Oracle\product\10.2.0\oradata\orcl ---> SRV2 O:\Oracle\product\10.2.0\oradata\orcl
Specification Option --> Default
Synchronization Option --> Default
3.Add Alias
[Alias Tab]
Alias ---> SRV3
Target System ---> SRV2
Commands:Adding Alias
After:oracle_start.bat
Commands:Removing Alias
Before:oracle_stop.bat
[IP Address tab]
Virtual IP ---> 192.168.0.100 Subnet:255.255.255.0
[Service Tab]
Listener Service
specific active computer name:SRV3
OracleServiceORCL
specific active computer name:SRV3
[Target Tab]
Option is default
The setting is completed by this.
*oracle_start.bat
set oracle_sid=orcl
sqlplus /nolog @c:\start.sql
*start.sql
connect /as sysdba;
startup;
exit
*oracle_stop.bat
set oracle_sid=orcl
sqlplus /nolog @c:\stop.sql
*stop.sql
connect /as sysdba;
shutdown immediate;;
exit
4.Treatment after failover
Please do the following operation when alias moves to the target site.
It right-clicks in alias on the target site. Please execute Set Source.
Operation necessary after failover:
It is necessary to do Set Source by an active alias.
If this operation is not done, the error of Ora-00600, Ora-00312, and Ora-00322 will be output.
And, the data base will not be able to be opened.