standy物理备库自己会产生日志吗？

显示全部楼层 · 2015-9-21 09:46:16

我从主库拷贝过来的日志文件，存放在oradata/change/onlinelog/下，备库的unique name为dg_change。结果启动备库后，产生oradata下存在/change和/dg_change，两个目录，配置dataguard过程中，发现启动备库后，备库自己产生一个目录，存在自己的日志文件。物理备库应该自己不产生日志文件的，疑问？

千问 · 2015-9-21 09:46:16

oracle为11gR2

千问 · 2015-9-21 09:46:16

正常生成的也是主库的~就是主库切换时他也切换
他自己应该是没有的
你怎么配的大概说下吧？信息太少

千问 · 2015-9-21 09:46:16

备库的initchange信息
*.db_domain=''
*.db_name='change'
*.db_recovery_file_dest='/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=20971520000
*.DB_UNIQUE_NAME='dg_change'
*.diagnostic_dest='/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=changeXDB)'
*.FAL_CLIENT='dg_change'
*.FAL_SERVER='change'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(change,dg_change)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/app/oracle/oradata/archive
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg_change'
*.LOG_ARCHIVE_DEST_2='SERVICE=change ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=change'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=407896064
*.processes=150
*.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
*.sga_target=1223688192
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_tablespace='UNDOTBS1'

千问 · 2015-9-21 09:46:16

主库的initchange.ora
*.audit_file_dest='/app/oracle/admin/change/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/app/oracle/oradata/CHANGE/controlfile/o1_mf_68xp96xh_.ctl','/app/oracle/flash_recovery_area/CHANGE/controlfile/o1_mf_68xp97b2_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/app/oracle/oradata'
*.db_domain=''
*.db_name='change'
*.db_recovery_file_dest='/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=20971520000
*.DB_UNIQUE_NAME='change'
*.diagnostic_dest='/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=changeXDB)'
*.FAL_CLIENT='change'
*.FAL_SERVER='dg_change'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(change,dg_change)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/app/oracle/oradata/archive
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=change'
*.LOG_ARCHIVE_DEST_2='SERVICE=dg_change ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=dg_change'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=407896064
*.processes=150
*.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
*.sga_target=1223688192
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_tablespace='UNDOTBS1'

千问 · 2015-9-21 09:46:16

主库中的数据文件，日志文件和admin目录，都拷贝过来的。我疑问的是，怎么在物理备库上产生一个dg_change的目录呢？下面存放的是日志文件
oracle@chang1:/app/oracle/oradata/DG_CHANGE/onlinelog> ll
total 153612
-rw-r----- 1 oracle dba 52429312 2011-01-11 16:57 o1_mf_1_6lr6wjc0_.log
-rw-r----- 1 oracle dba 52429312 2011-01-11 16:57 o1_mf_2_6lr6wlq0_.log
-rw-r----- 1 oracle dba 52429312 2011-01-11 16:57 o1_mf_3_6lr6wo87_.log

千问 · 2015-9-21 09:46:16

google一下log_file_name_convert这个参数的用法
可能会帮到你呵呵