备机大地院系项目dataguard archived_log及standby

备机大地院系项目dataguard archived_log及standby_log

阅读量：7056 次

发布时间：2019-06-28

本文共 2773 字，大约阅读时间需要 9 分钟。

主库archivelog及standbylog

仅仅是测试4天的数据,项目并未正式上线

/data/dddb/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/archivelog

/data/dddb/DBSoftware/app/oracle/standbylog

备库archivedlog及standbylog

主库spfile

主库"listener.ora"

主库tnsnames.ora

备库spfile

备库tnsnames.ora

/data/dddb/DBSoftware/app/oracle/product/11.2.0/dbhome_1/network/admin

备库"listener.ora"

主库spfile,listener.ora,tnsnames.ora

LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = priydb.cc)(PORT = 1521))    )  )SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = dg1.priydb.cc)      (ORACLE_HOME = /data/dddb/DBSoftware/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME = dg)    )  )ADR_BASE_LISTENER = /data/dddb/DBSoftware/app/oracle

listener.ora

dg1 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = priydb.cc)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = dg1.priydb.cc)    )  )dg2 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = stadby.cc)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = dg2.stadby.cc)    )  )for_db = (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.252.32.183)(PORT = 1521))

"tnsnames.ora"

dg.__db_cache_size=423624704dg.__java_pool_size=4194304dg.__large_pool_size=4194304dg.__oracle_base='/data/dddb/DBSoftware/app/oracle'#ORACLE_BASE set from environmentdg.__pga_aggregate_target=432013312dg.__sga_target=641728512dg.__shared_io_pool_size=0dg.__shared_pool_size=197132288dg.__streams_pool_size=0*.audit_file_dest='/data/dddb/DBSoftware/app/oracle/admin/dg/adump'*.audit_trail='db'*.compatible='11.2.0.0.0'*.control_files='/data/dddb/DBData/oradata/dg/control01.ctl','/data/dddb/DBSoftware/app/oracle/flash_recovery_area/dg/control02.ctl'*.db_block_size=8192*.db_domain='priydb.cc'*.db_name='dg'*.db_recovery_file_dest='/data/dddb/DBSoftware/app/oracle/flash_recovery_area'*.db_recovery_file_dest_size=4070572032*.db_unique_name='dg1'*.diagnostic_dest='/data/dddb/DBSoftware/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=dgXDB)'*.fal_client='dg1'*.fal_server='dg2'*.local_listener='for_db'*.log_archive_config='DG_CONFIG=(dg1,dg2)'*.log_archive_dest_1='LOCATION=/data/dddb/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/archivelog valid_for=(all_logfiles,primary_role) db_unique_name=dg1'*.log_archive_dest_2='SERVICE=dg2 lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=dg2'*.log_archive_dest_3='LOCATION=/data/dddb/DBSoftware/app/oracle/standbylog valid_for=(standby_logfile,standby_role) db_unique_name=dg1'*.memory_target=1073741824*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.standby_file_management='AUTO'*.undo_tablespace='UNDOTBS1'

/initdg.ora"

转载地址：http://kygol.baihongyu.com/

你可能感兴趣的文章

lab2:完成一个简单的时间片轮转多道程序内核代码

查看>>

javaweb--json--ajax--mysql实现省市区三级联动（附三级联动数据库）

查看>>

Windows Server的一些相关设置

查看>>

Csharp学习笔记_kita (第二天）interface

查看>>

Percona XtraDB Cluster 的一些使用限制(PXC 5.7)