...
Following example illustrates the method of using standby database as target. The standby database can be created using RMAN or by using Dbvisit Standby. This example explains the method step by step after standby database is created using following environment.
Server/Database | Name |
---|---|
Source database | reptest1 |
Source server | dbvldemo101 (Linux) |
Standby/Target database | reptest2 |
Target server | dbvldemo102(Linux) |
TNS alias for source database | reptest1 |
TNS alias for target database | reptest2 |
1. Create the standby database using RMAN or by using Dbvisit Standby
...
No Format | ||
---|---|---|
| ||
SQL> recover standby database until change 1094745 ORA-00279: change 1094505 generated at 06/21/2013 17:37:11 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/oraarch/reptest2/1_38_818678256.dbf ORA-00280: change 1094505 for thread 1 is in sequence #38 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} /u01/app/oracle/oraarch/reptest2/o1_mf_1_38_8w7spsss_.arc Log applied. Media recovery complete. SQL> alter database activate standby database; Database altered. SQL> alter database open; Database altered. |
4. Now, you can configure Dbvisit Replicate by running setup wizard normally on the source server. Select 'resetlogs' as data instantiation method in step 2 of setup wizard.
...