Oba Marcio obrigado pelo os artigos eu consegui fazer o standby , a unica
coisa que não aproveitei foi os parametros dg mas fez eu entender a logica
do db_unique_name com o tns.
Obrigado
Em 20/12/07, Marcio Portes <[EMAIL PROTECTED]> escreveu:
>
> Veja uma receitinha de bolo em Portugues
>
> http://mportes.blogspot.com/2007/06/montar-dataguard-no-10g-com-broker.html
>
> http://mportes.blogspot.com/2007/06/broker-dataguard-e-real-time-apply-10g.html
>
> O primeiro link, monta o Dataguard e o segundo faz o Real Time Apply.
>
> On Dec 20, 2007 5: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: Archivel