4 Creating a Logical Standby Database
4.1 Prerequisite Conditions for Creating a Logical Standby Database
4.1.1 Determine Support for Data Types and Storage Attributes for Tables
4.1.2 Ensure Table Rows in the Primary Database Can Be Uniquely Identified
4.2 Step-by-Step Instructions for Creating a Logical Standby Database
4.2.1 Create a Physical Standby Database
4.2.2 Stop Redo Apply on the Physical Standby Database
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
4.2.3 Prepare the Primary Database to Support a Logical Standby Database
4.2.3.1 Prepare the Primary Database for Role Transitions
log_archive_dest_3='LOCATION=/u01/ora10g/stdby_arch VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=ora10g1'
mkdir /u01/ora10g/stdby_arch
SQL> alter system set log_archive_dest_3='LOCATION=/u01/ora10g/stdby_arch VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=ora10g1';
4.2.3.2 Build a Dictionary in the Redo Data
SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

4.2.4 Transition to a Logical Standby Database
4.2.4.1 Convert to a Logical Standby Database
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY ora10g2;
4.2.4.2 Create a New Password File
orapwd file=./orapwora10g1_standby password=oracle force=y
4.2.4.3 Adjust Initialization Parameters for the Logical Standby Database
SQL> SHUTDOWN;
SQL> STARTUP MOUNT;

LOG_ARCHIVE_DEST_1=
'LOCATION=/arch1/boston/
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_2=
'SERVICE=chicago LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_3=
'LOCATION=/arch2/boston/
VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)
DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_3=ENABLE

alter system set log_archive_dest_1='LOCATION=/u01/ora10g/archivelog VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orastdb';

4.2.5 Open the Logical Standby Database
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

4.2.6 Verify the Logical Standby Database Is Performing Properly

4.3 Post-Creation Steps

Database DB_UNIQUE_NAME Oracle Net Service Name
Primary chicago chicago
Physical standby boston boston

[@more@]