DBVisit is a software which can be used to implement a replication of database with low cost .No Other Software are needed.
As for Oracle Stranded Edition and Enterprise Edition having different licensing cost which you could have to pay much more money value for Oracle Enterprise Edition Licensing.As a solution provider you could suggest more cheaper method for customers to enhance the IT solution.From customer's perspective they will try to reduce the cost .In Oracle Enterprise Edition it will provide Data guard as a feature where customers will have to pay much more money.
So to full fill this Database Replication concept (Data guard concept) in Production Environment we can provide solution.
The DbVisit will carry out 3 things mainly.
1. Extraction
2. Transport
3. Log Apply
Oracle Standard Edition with DbVisit.
Prerequisites
You need to have Primary Server and a Stand by Server.Both Servers must have installed Oracle Binary and created database. Both databases should be in Archivelog mode.
Dbvisit must be installed with the same user account that is running the oracle database software.
This user should be in oracle dba group.
**Now you can install dbvisitstandby.exe**
After Installing you need create Dbvisit Database Configuration (DDC) file. I have created the DDC using Command Line --DDC can be created with GUI --
To create a Dbvisit Database Configuration (DDC) file from the command line you need to run the “dbvisit_setup” command.Go to Place where you installed dbvisitstandby
My Case C:\ProgrameFiles\dbvisit\Standby\
and run dbvisit_setup.exe
There you could ask whether your db environment status.ex : Single Instance Database or RAC environment database. As my database is standalone I pressed 1 and moved on.
Then
This will ask for common details for Primary Server make sure you give the correct details and fill almost all every thing.
After this configuration it will show the summary of values for primary server which you entered.
After that you need to configure the standby database. you can do this by pressing 7. Enter the correct values for asked questions.
This step will do the replica of the the primary db.This will send datafiles ,spfile,pfile and other files to the standby database.
There you need to license the dbvisit software even you installing the trial version.
dbvisit.exe -lic ORCL License_Key
Now you are done with configuring DbVisitStandby.
There you could see some manual things you could do.
Manually send from primary server
dbvisit ORCL
Manually apply to standby server
dbvisit ORCL
Manually resend logs from primary server
dbvisit -R ORCL
Apply manually to Stand by server
dbvisit ORCL
Check the log gap report // this is on primary server
dbvisit -i ORCL
Perform Graceful switchover // this has to be performed on both primary and standby servers.
dbv_oraStartStop switchover ORCL 123 // here 123 is a unique number // this ha to be applyied on both side.
Source:https://dbvisit.atlassian.net/wiki/display/UGDS7/Introduction
As for Oracle Stranded Edition and Enterprise Edition having different licensing cost which you could have to pay much more money value for Oracle Enterprise Edition Licensing.As a solution provider you could suggest more cheaper method for customers to enhance the IT solution.From customer's perspective they will try to reduce the cost .In Oracle Enterprise Edition it will provide Data guard as a feature where customers will have to pay much more money.
So to full fill this Database Replication concept (Data guard concept) in Production Environment we can provide solution.
The DbVisit will carry out 3 things mainly.
1. Extraction
2. Transport
3. Log Apply
Oracle Standard Edition with DbVisit.
Prerequisites
You need to have Primary Server and a Stand by Server.Both Servers must have installed Oracle Binary and created database. Both databases should be in Archivelog mode.
Dbvisit must be installed with the same user account that is running the oracle database software.
This user should be in oracle dba group.
**Now you can install dbvisitstandby.exe**
After Installing you need create Dbvisit Database Configuration (DDC) file. I have created the DDC using Command Line --DDC can be created with GUI --
To create a Dbvisit Database Configuration (DDC) file from the command line you need to run the “dbvisit_setup” command.Go to Place where you installed dbvisitstandby
My Case C:\ProgrameFiles\dbvisit\Standby\
and run dbvisit_setup.exe
There you could ask whether your db environment status.ex : Single Instance Database or RAC environment database. As my database is standalone I pressed 1 and moved on.
Then
This will ask for common details for Primary Server make sure you give the correct details and fill almost all every thing.
After this configuration it will show the summary of values for primary server which you entered.
After that you need to configure the standby database. you can do this by pressing 7. Enter the correct values for asked questions.
This step will do the replica of the the primary db.This will send datafiles ,spfile,pfile and other files to the standby database.
There you need to license the dbvisit software even you installing the trial version.
dbvisit.exe -lic ORCL License_Key
Now you are done with configuring DbVisitStandby.
There you could see some manual things you could do.
Manually send from primary server
dbvisit ORCL
Manually apply to standby server
dbvisit ORCL
Manually resend logs from primary server
dbvisit -R ORCL
Apply manually to Stand by server
dbvisit ORCL
Check the log gap report // this is on primary server
dbvisit -i ORCL
Perform Graceful switchover // this has to be performed on both primary and standby servers.
dbv_oraStartStop switchover ORCL 123 // here 123 is a unique number // this ha to be applyied on both side.
Source:https://dbvisit.atlassian.net/wiki/display/UGDS7/Introduction
well done mchn.. keep up the good work...!
ReplyDelete