Complementando *.log_archive_config='DG_CONFIG=(smp,smp_sb)'
No seu caso deve ficar assim *.log_archive_config='DG_CONFIG=(PRD,STANDBY)' *.log_archive_dest_1='LOCATION=C:\oracle\PRD\102\database\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRD' *.log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY' On Dec 21, 2007 7:39 PM, Marcia Caccese <[EMAIL PROTECTED]> wrote: > Osvaldo, > > vc deve configurar o standby dessa forma > > *.log_archive_dest_1='LOCATION=/dbs/arch/smp > VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=smp_sb' > *.log_archive_dest_2='SERVICE=smp > VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=smp' > > > O db_unique_name deve ser diferente embora o banco tenha o mesmo db_name. > > > On Dec 20, 2007 4:04 PM, Osvaldo Antonio Santos > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Boa tarde, > > > > alguem poderia me informar porque está retornando este erro, estou > > preparando um standby da seguinte forma > > 172.16.81.157 Primary > > 172.16.81.130 standby > > > > oracle 10g sendo que eu criei uma base de dados no primary com o nome PRD e > > no standby tambem com o nome PRD > > > > meu initPRD.ini do primary ficou assim : > > > > prd.__db_cache_size=75497472 > > prd.__java_pool_size=4194304 > > prd.__large_pool_size=4194304 > > prd.__shared_pool_size=75497472 > > prd.__streams_pool_size=0 > > *.audit_file_dest='C:\oracle\PRD/admin/PRD/adump' > > *.background_dump_dest='C:\oracle\PRD/admin/PRD/bdump' > > *.compatible='10.2.0.1.0' > > *.control_files='C:\oracle\PRD/oradata/PRD/\control01.ctl','C:\oracle\PRD/oradata/PRD/\control02.ctl','C:\oracle\PRD/oradata/PRD/\control03.ctl' > > *.core_dump_dest='C:\oracle\PRD/admin/PRD/cdump' > > *.db_block_size=8192 > > *.db_domain='' > > *.db_file_multiblock_read_count=16 > > *.db_name='PRD' > > *.db_recovery_file_dest='C:\oracle\PRD/flash_recovery_area' > > *.db_recovery_file_dest_size=2147483648 > > *.dispatchers='(PROTOCOL=TCP) (SERVICE=PRDXDB)' > > *.job_queue_processes=10 > > *.open_cursors=300 > > *.pga_aggregate_target=16777216 > > *.processes=150 > > *.remote_login_passwordfile='EXCLUSIVE' > > *.sga_target=167772160 > > *.undo_management='AUTO' > > *.undo_tablespace='UNDOTBS1' > > *.user_dump_dest='C:\oracle\PRD/admin/PRD/udump' > > *.db_unique_name= 'PRD' > > *.log_archive_config='DG_CONFIG=(PRD,STANDBY)' > > *.log_archive_dest_state_1 = enable > > *.log_archive_dest_state_2 = enable > > *.log_archive_max_processes = 30 > > *.fal_client = 'PRD' > > *.fal_server = 'STANDBY' > > *.standby_archive_dest='\\172.16.81.157\PRD\102\database\archive' > > *.standby_file_management='AUTO' > > *.log_archive_dest_1='LOCATION=C:\oracle\PRD\102\database\archive > > VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRD' > > *.log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC > > VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRD' > > > > o Tnsnames.ora ficou assim : > > > > # tnsnames.ora Network Configuration File: > > C:\oracle\PRD\102\network\admin\tnsnames.ora > > # Generated by Oracle configuration tools. > > > > PRD.WORLD = > > (DESCRIPTION = > > (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = > > ASP2332HOWXP)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = PRD) > > ) > > ) > > > > STANDBY.WORLD = > > (DESCRIPTION = > > (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = > > ASP0761MTWXP)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = PRD) > > ) > > ) > > > > EXTPROC_CONNECTION_DATA = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) > > ) > > (CONNECT_DATA = > > (SID = PLSExtProc) > > (PRESENTATION = RO) > > ) > > ) > > > > e o listener ficou assim : > > > > # listener.ora Network Configuration File: > > C:\oracle\PRD\102\network\admin\listener.ora > > # Generated by Oracle configuration tools. > > > > ################ > > # Filename......: listener.ora > > # Created.......: created by SAP AG, R/3 Rel. >= 4.0A > > # Name..........: > > # Date..........: > > ################ > > > > SID_LIST_LISTENER = > > (SID_LIST = > > (SID_DESC = > > (SDU = 32768) > > (SID_NAME = PRD) > > (ORACLE_HOME = C:\oracle\PRD\102) > > ) > > ) > > > > LISTENER = > > (DESCRIPTION_LIST = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = IPC)(KEY = PRD.WORLD)) > > ) > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = IPC)(KEY = PRD)) > > ) > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = ASP2332HOWXP)(PORT = 1521)) > > ) > > ) > > > > STANDBY = > > (DESCRIPTION_LIST = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = IPC)(KEY = STANDBY.WORLD)) > > ) > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = IPC)(KEY = PRD)) > > ) > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = ASP0761MTWXP)(PORT = 1527)) > > ) > > ) > > > > fiz as allterações necessarias no PRD do standby em termos init e control > > files gerado a partir do primary como manual ele monta o standby legal porem > > na hora em que eu tento forçar a criação de um archive para ver se replica > > com o comando > > > > *ALTER SYSTEM SWITCH LOGFILE* > > Eu verifico se foi replicado porem não foi e no alert.log me aparece essa > > mensagem : > > > > ARC0: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: Data Guard > > configuration identifier mismatch > > -- > > Caso alguem saiba o que esta errado ou alguma manobra para fazer o standby > > com bases de mesmos nome por favor me ajudem.. > > > > Obrigado > > > > Att, > > Osvaldo Antonio dos Santos > > > > [As partes desta mensagem que não continham texto foram removidas] > > > > >
