creating a logical standby database

Step-by-step instructions for creating a logical standby database.

——————————————————————————————–
1. Create a Physiacl standby database.
2.Stop Redo Apply
3.Prepare the primary database to support a logical Standby Database.
4.Transition to a logical standby Database
5.Open the Logical Standby database.
6.verify the logical standby database is performing properly.
———————————————————————————————

Step 1:Create a Physiacl standby database.

It asssume that physical standby database is alredy created.

Step 2:Stop Redo Apply
=====on standby DB
Sql> Alter database recover managed standby database cancel;

Step 3: Prepare the primary database to support a logical Standby Database
=====On primary
sql>alter system set log_archive_dest_3=’location=’C:\oracle\product\10.2.0\admin\TEST\arc2′ valid_for=(standby_logfiles,standby_role) db_unique_name=test’

=====Assume our primary database name is “test”

log_archive_dest_state_3=enable

Build a Ditionary in the redo data

Sql> execute dbms_logstdby.build;

step 4: Transition to logical standby database

===== on standby
sql>alter database recover to logical standby db_name;
— create a new password file for logical standby

c:>

sql>shutdown immediate
sql>startup mount
sql>alter system set log_archive_dest_3=’location=C:\oracle\admin\stest\arc2 valid_for=(standby_logfiles,standby_role) db_unique_name=stest’;

step 5: open logical standby database

sql> alter database open resetlogs;
=====applying redo data to the logical standby database
sql>alter database start logical standby apply immediate;

=====verify logical standby database perform properly
sql> select sequence#,applied from archive_log;