主库 （下面打井号的不用执行）
alter database force logging;
alter system set db_unique_name='erp' scope=spfile; --我们让主库db_name=db_unique_name
alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile;
alter system set LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' scope=spfile;
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(erp,erpdg)' scope=both;
#alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=erp' scope=both;
alter system set LOG_ARCHIVE_DEST_2='SERVICE=erpdg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=erpdg' scope=both;
#alter system set LOG_ARCHIVE_DEST_2='SERVICE=10.10.1.251:1601/erpdg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=erpdg' scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_2=defer scope=both;
alter system set LOG_ARCHIVE_MAX_PROCESSES=30 scope=both;
重启库
shutdown immediate;
startup mount
开启归档：
alter database archivelog;
alter database open;
将两边库的监听、tns都配好，能互相tnsping通。
监听参考
SID_LIST_dg1= (SID_LIST=(SID_DESC=(SID_NAME=dg)(ORACLE_HOME=/dg1/product/11.2.0))) dg1=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.1.251)(PORT=1800))))
连接串参考：
dg2=(description =(address = (protocol = tcp)(host =10.10.1.251)(port = 1801))(connect_data = (sid = dg)))
创建主库的密码文件，传送到dg库。 [dg1] cp $ORACLE_HOME/dbs/orapw${ORACLE_SID} /tmp [dg1] chmod 777 /tmp/orapw${ORACLE_SID} [dg2] mv /tmp/orapw${ORACLE_SID} $ORACLE_HOME/dbs 或者dg库直接创建密码文件，sys密码与主库一致。 cd $ORACLE_HOME/dbs && orapwd file=orapw$ORACLE_SID password=password force=y
下面是创建备库的参数文件的 [dg2]
cd $ORACLE_HOME/dbs && vi fwy.ora
#
db_name=erp
db_unique_name=erp
db_create_file_dest='/erpdg_bk/dg'
diagnostic_dest='/u01/erp/db/tech_st/11.2.0/admin/erpdg_erpdg'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(erp,erpdg)'
fal_server=erp
fal_client=erpdg db_recovery_file_dest_size=200G db_recovery_file_dest='/erpdg_bk/dg/fra'
#
utl_file_dir='/tmp'
pga_aggregate_target=1073741824 #1G
java_pool_size=157286400 #150m
large_pool_size=157286400 #150m
sga_target=0
shared_pool_size=1073741824 #1G
db_cache_size=1073741824 #1G
parallel_max_servers = 8
_b_tree_bitmap_plans=FALSE
_fast_full_scan_enabled=FALSE
O7_DICTIONARY_ACCESSIBILITY=FALSE
_like_with_bind_as_equality=TRUE
_optimizer_autostats_job=FALSE
_sort_elimination_cost_ratio=5
_system_trig_enabled=TRUE
_trace_files_public=true
plsql_code_type='NATIVE'
plsql_optimize_level=2
compatible=11.2.0
cursor_sharing=EXACT
db_block_checking=false
db_block_checksum=true
db_files=5120
dml_locks=30000
log_checkpoint_interval=100000
log_checkpoint_timeout=1200
log_checkpoints_to_alert=TRUE
nls_territory=america
olap_page_pool_size=4194304
optimizer_secure_view_merging=FALSE
parallel_min_servers=0
sec_case_sensitive_logon=false
undo_management=auto
undo_retention=21600 #6小时
undo_tablespace=APPS_UNDOTS1
remote_login_passwordfile=EXCLUSIVE
query_rewrite_enabled=true
db_block_size=8192
db_file_multiblock_read_count=64
db_writer_processes=10
resource_manager_plan=''
_resource_manage