Create a physical standby library with Oracle 11g new features

Preparatory work:

1. Main Library Enable archiving
   

2. Install Oralce 11g software on all systems

3. Repository to create the necessary directories

4. Create a listener, configure the Tnsname file

The first step:

A copy of the password file from the master library to the standby repository

Step Two:

Parameter file modification of the main standby library:

Main library parameter files such as:

matrix.__db_cache_size=83886080

matrix.__java_pool_size=4194304

matrix.__large_pool_size=4194304

Matrix.__oracle_base= '/u2/oracle ' #ORACLE_BASE set from environment

matrix.__pga_aggregate_target=176160768

matrix.__sga_target=243269632

Matrix.__shared_io_pool_size=0

matrix.__shared_pool_size=138412032

Matrix.__streams_pool_size=0

*.audit_file_dest= '/u2/oracle/admin/matrix/adump '

*.audit_trail= ' DB '

*.compatible= ' 11.2.0.0.0 '

*.control_files= '/oradata/matrix/control01.ctl ', '/u2/oracle/fast_recovery_area/matrix/control02.ctl '

*.db_block_size=8192

*.db_domain= "

*.db_name= ' Matrix '

*.db_recovery_file_dest= '/u2/oracle/fast_recovery_area '

*.db_recovery_file_dest_size=4322230272

*.diagnostic_dest= '/u2/oracle '

*.dispatchers= ' (protocol=tcp) (SERVICE=MATRIXXDB) '

*.memory_target=419430400

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile= ' EXCLUSIVE '

*.undo_tablespace= ' UNDOTBS1 '

*.db_unique_name= ' Matrix '

*.log_archive_config= ' dg_config= (MATRIX,MATRIXDG) '

*.log_archive_dest_1= ' Location=/oradata/arch/matrix '

*.log_archive_dest_2= ' service=matrixdg lgwr async valid_for= (online_logfiles,primary_role) DB_UNIQUE_NAME=MATRIXDG ‘

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.standby_file_management= ' Auto '

*.fal_server= ' MATRIXDG '

*.fal_client= ' Matrix '

*.db_file_name_convert= '/oradata/matrixdg ', '/oradata/matrix '

*.log_file_name_convert= '/oradata/arch/matrixdg ', '/oradata/matrix '

~

Repository parameter files such as:

*.audit_file_dest= '/u2/oracle/admin/matrixdg/adump '

*.audit_trail= ' DB '

*.compatible= ' 11.2.0.0.0 '

*.control_files= '/oradata/matrixdg/control01.ctl ', '/u2/oracle/fast_recovery_area/matrixdg/control02.ctl '

*.db_block_size=8192

*.db_domain= "

*.db_name= ' Matrix '

*.db_recovery_file_dest= '/u2/oracle/fast_recovery_area '

*.db_recovery_file_dest_size=4322230272

*.diagnostic_dest= '/u2/oracle '

*.dispatchers= ' (protocol=tcp) (SERVICE=MATRIXXDB) '

*.memory_target=419430400

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile= ' EXCLUSIVE '

*.undo_tablespace= ' UNDOTBS1 '

*.db_unique_name= ' MATRIXDG '

*.log_archive_config= ' dg_config= (MATRIX,MATRIXDG) '

*.log_archive_dest_1= ' LOCATION=/ORADATA/ARCH/MATRIXDG '

*.log_archive_dest_2= ' Service=matrix lgwr async valid_for= (online_logfiles,primary_role) Db_unique_name=matrix '

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.standby_file_management= ' manual '

*.fal_server= ' Matrix '

*.fal_client= ' MATRIXDG '

*.db_file_name_convert= '/oradata/matrix ', '/ORADATA/MATRIXDG '

*.log_file_name_convert= '/oradata/arch/matrix ', '/ORADATA/ARCH/ATRIXDG '

Fourth Step:

Booting the standby to the Nomount state

Sql> Startup Nomount

Fifth Step:

Rman>connect target Sys/[email protected];

Rman>connect target Sys/[email protected];

Rman>duplicate target database for standby from active database;

Sixth step:

Create standby Redo logfile in the

Sql>alter database Add standby logfile ' <PATH> ' size 50M;

Seventh Step:

Ready to start the log app

Sql>alter database recover managed standby database using current logfile disconnect;

Create a physical standby library with Oracle 11g new features