How to use ORACLE to create physical backup Library
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!
