Get ready:
Confirm objects and statements can be standby supported
Make sure that the rows of the tables in the primary library can be uniquely identified
Environment:
Operating system: RED HAT LINUX ENTERPRISE 5
oracle:11.2.0.1.0
PRIMARY:
ip:192.168.1.11
Sid:test
Db_unique_name:test
Installation path:/oracle/oracle/product/11.2.0/dbhome_1
Local Archive path:/oracle/oradata/test/archive
Physics STANDBY:
ip:192.168.1.12
Sid:dgtest
Db_unique_name:dgtest
Installation path:/oracle/oracle/product/11.2.0/dbhome_1
Local Archive path:/oracle/oradata/dgtest/dgtest/archive
LOGICAL STANDBY:
ip:192.168.1.15
Sid:logicdg
Db_unique_name:logicdg
Installation path:/oracle/oracle/product/11.2.0/dbhome_1
Local Archive path:/oracle/oradata/logicdg/local-archive
This example tests the use of physical standby logic standby to add a logical standby to an already existing dataguard environment.
The original Dataguard environment can refer to:
http://xin23.blog.51cto.com/1827266/504066
The process of creating a new physical standby can also be referenced in this article. No longer repeat here.
The current environment is:
primary:192.168.1.11
physics:192.168.1.12
Logical:192.168.1.15 (currently a physical standby. Pending conversion)
1. Modify the primary initialization parameter file (only the modified part is listed)
*.log_archive_dest_state_2=defer
*.log_archive_dest_state_3=defer
*.log_archive_config= ' dg_config= (TEST,DGTEST,LOGICDG) '
*.log_archive_dest_2= ' service=test12 arch valid_for= (online_logfiles,primary_role) db_unique_name=dgtest '
*.log_archive_dest_3= ' service=test15 arch valid_for= (online_logfiles,primary_role) DB_UNIQUE_NAME=LOGICDG '
*.fal_server=test11
*.fal_client=test12
*.standby_file_management=auto
*.db_file_name_convert= '/oracle/oradata/test ', '/oracle/oradata/dgtest/dgtest ', '/oracle/oradata/test ', '/
ORACLE/ORADATA/LOGICDG '
*.log_file_name_convert= '/oracle/oradata/test ', '/oracle/oradata/dgtest/dgtest ', '/oracle/oradata/test ', '/
ORACLE/ORADATA/LOGICDG ' 1 2 next page > full text reading tips: Try "←→" button, turn the page more convenient Oh!