Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use ORACLE to create a physical standby library". In daily operation, I believe many people have doubts about how to use ORACLE to create a physical standby library. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about how to use ORACLE to create a physical backup library. Next, please follow the editor to study!

Preparatory work:

The main library enables archiving

Install oralce 11g software on all systems

Prepare the library to create the necessary directories

Create snooping and configure tnsname files

Step one:

Cp the password file of the main library into the standby database.

Step 2:

Modify the parameter file of the master / slave 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'

~

Prepare library 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'

Step 4:

Start the slave library to nomount state

SQL > startup nomount

Step 5:

RMAN > connect target sys/oracle@matrix

RMAN > connect target sys/oracle@matrixdg

RMAN > duplicate target database for standby from active database

Step 6:

Create a standby redo logfile in standby

SQL > alter database add standby logfile''size 50m

Step 7:

Launch log application in standby

SQL > alter database recover managed standby database using current logfile disconnect

At this point, the study on "how to use ORACLE to create a physical repository" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.