Mexi olhei refiz e não funcionou.

Vou colocar as confs pra vocês verificar e ver aonde eu estou errado.

Pfile servidor 1:

PRODUCAO.__db_cache_size=96468992
PRODUCAO.__java_pool_size=4194304
PRODUCAO.__large_pool_size=4194304
PRODUCAO.__shared_pool_size=58720256
PRODUCAO.__streams_pool_size=0
*.audit_file_dest='/u01/prd/admin/PRODUCAO/adump'
*.background_dump_dest='/u01/prd/admin/PRODUCAO/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/PRODUCAO/control01.ctl','/u01/PRODUCAO/control02.ctl','/u01/PRODUCAO/control03.ctl'#Restore
Controlfile
*.core_dump_dest='/u01/prd/admin/PRODUCAO/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PRODUCAO'
db_unique_name=primary

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary, standy)'

LOG_ARCHIVE_DEST_1=
 'LOCATION=/u01/PRODUCAO/archive/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=primary'

LOG_ARCHIVE_DEST_2=
 'SERVICE=standy LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=standy'

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

FAL_SERVER=standy
FAL_CLIENT=primary

DB_FILE_NAME_CONVERT='/u01/PRODUCAO','/u01/PRODUCAO'
LOG_FILE_NAME_CONVERT='/u01/PRODUCAO','/u01/PRODUCAO'

STANDBY_FILE_MANAGEMENT=AUTO

*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODUCAOXDB)'
*.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='/u01/prd/admin/PRODUCAO/udump'

Pfile servidor 2:

*.audit_file_dest='/u01/prd/admin/PRODUCAO/adump'
*.background_dump_dest='/u01/prd/admin/PRODUCAO/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/PRODUCAO/control01.ctl','/u01/PRODUCAO/control02.ctl','/u01/PRODUCAO/control03.ctl'#Restore
Controlfile
*.core_dump_dest='/u01/prd/admin/PRODUCAO/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PRODUCAO'
db_unique_name=standy

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary, standy)'

DB_FILE_NAME_CONVERT='/u01/PRODUCAO','/u01/PRODUCAO'
LOG_FILE_NAME_CONVERT='/u01/PRODUCAO','/u01/PRODUCAO'

LOG_ARCHIVE_DEST_1=
 'LOCATION=/u01/PRODUCAO/archive/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=standy'

LOG_ARCHIVE_DEST_2=
 'SERVICE=primary LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=primary'

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

FAL_SERVER=primary
FAL_CLIENT=standy

STANDBY_FILE_MANAGEMENT=AUTO

*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODUCAOXDB)'
*.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='/u01/prd/admin/PRODUCAO/udump'

Alert log sevidor 1.

LGWR: STARTING ARCH PROCESSES COMPLETE
ARCt started with pid=45, OS id=22108
ARCr started with pid=43, OS id=22104
LNS1 started with pid=46, OS id=22110
Tue Jun  2 15:41:38 2009
Thread 1 advanced to log sequence 19
Tue Jun  2 15:41:39 2009
ARC5: Becoming the 'no FAL' ARCH
ARC5: Becoming the 'no SRL' ARCH
Tue Jun  2 15:41:39 2009
Thread 1 opened at log sequence 19
  Current log# 1 seq# 19 mem# 0: /u01/PRODUCAO/redo01.log
Successful open of redo thread 1
Tue Jun  2 15:41:39 2009
ARCb: Becoming the heartbeat ARCH
Tue Jun  2 15:41:40 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jun  2 15:41:40 2009
SMON: enabling cache recovery
Tue Jun  2 15:41:40 2009
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Tue Jun  2 15:41:55 2009
Error 1034 received logging on to the standby
Tue Jun  2 15:41:55 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_lns1_22110.trc:
ORA-01034: ORACLE not available
LGWR: Error 1034 creating archivelog file 'standy'
LNS: Failed to archive log 1 thread 1 sequence 19 (1034)
Tue Jun  2 15:41:55 2009
Error 1034 received logging on to the standby
Tue Jun  2 15:41:55 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arc0_21987.trc:
ORA-01034: ORACLE not available
FAL[server, ARC0]: Error 1034 creating remote archivelog file 'standy'
FAL[server, ARC0]: FAL archive failed, see trace file.
Tue Jun  2 15:41:56 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arc0_21987.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Tue Jun  2 15:41:56 2009
ORACLE Instance PRODUCAO - Archival Error. Archiver continuing.
Tue Jun  2 15:42:02 2009
Successfully onlined Undo Tablespace 1.
Tue Jun  2 15:42:02 2009
SMON: enabling tx recovery
Tue Jun  2 15:42:04 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster
replication found)
Starting background process QMNC
QMNC started with pid=46, OS id=22177
Tue Jun  2 15:42:43 2009
Completed: alter database open
Tue Jun  2 15:47:41 2009
Error 1034 received logging on to the standby
Tue Jun  2 15:47:41 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arcb_22058.trc:
ORA-01034: ORACLE not available
PING[ARCb]: Heartbeat failed to connect to standby 'standy'. Error is 1034.
Tue Jun  2 15:52:48 2009
Error 1034 received logging on to the standby
Tue Jun  2 15:52:48 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arcb_22058.trc:
ORA-01034: ORACLE not available
PING[ARCb]: Heartbeat failed to connect to standby 'standy'. Error is 1034.
Tue Jun  2 15:52:55 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 2235K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Tue Jun  2 15:57:48 2009
Error 1034 received logging on to the standby
Tue Jun  2 15:57:48 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arcb_22058.trc:
ORA-01034: ORACLE not available
PING[ARCb]: Heartbeat failed to connect to standby 'standy'. Error is 1034.
Tue Jun  2 16:02:49 2009
Error 1034 received logging on to the standby
Tue Jun  2 16:02:49 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/producao_arcb_22058.trc:
ORA-01034: ORACLE not available
PING[ARCb]: Heartbeat failed to connect to standby 'standy'. Error is 1034.

Alert Log servidor 2:

Physical Standby Database mounted.
Completed: ALTER DATABASE   MOUNT
Tue Jun  2 15:52:33 2009
Alter Database Recover Managed Standby Database Disconnect From Session
Tue Jun  2 15:52:33 2009
Attempt to start background Managed Standby Recovery process (STANDY)
MRP0 started with pid=46, OS id=14096
Tue Jun  2 15:52:33 2009
MRP0: Background Managed Standby Recovery process started (STANDY)
Managed Standby Recovery not using Real Time Apply
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
Media Recovery Waiting for thread 1 sequence 9
Fetching gap sequence in thread 1, gap sequence 9-17
Tue Jun  2 15:52:39 2009
Completed: Alter Database Recover Managed Standby Database Disconnect
>From Session
Tue Jun  2 15:53:20 2009
FAL[client, MRP0]: Error 12154 connecting to primary for fetching gap sequence
Tue Jun  2 15:53:20 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/standy_mrp0_14096.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun  2 15:54:30 2009
FAL[client, MRP0]: Error 12154 connecting to primary for fetching gap sequence
Tue Jun  2 15:54:30 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/standy_mrp0_14096.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun  2 15:55:40 2009
FAL[client, MRP0]: Error 12154 connecting to primary for fetching gap sequence
Tue Jun  2 15:55:40 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/standy_mrp0_14096.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun  2 15:56:50 2009
FAL[client, MRP0]: Error 12154 connecting to primary for fetching gap sequence
Tue Jun  2 15:56:50 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/standy_mrp0_14096.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun  2 15:57:59 2009
FAL[client, MRP0]: Error 12154 connecting to primary for fetching gap sequence
Tue Jun  2 15:57:59 2009
Errors in file /u01/prd/admin/PRODUCAO/bdump/standy_mrp0_14096.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun  2 15:58:29 2009
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 9-17
 DBID 3063085327 branch 688384478
FAL[client]: All defined FAL servers have been attempted.

Listener Servidor 1:

# listener.ora Network Configuration File:
/u01/app/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

RMAN =
(ADDRESS_LIST=
        (ADDRESS=
                (PROTOCOL=tcp)
                (HOST=10.0.0.10)
                (PORT=1523)
        )
        (ADDRESS=
                (PROTOCOL=ipc)
                (KEY=extproc)
        )
)

PRODUCAO =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10) (PORT = 1521))
     )
    )
  )

STANDY =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.20)(PORT = 1522))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = STANDY)
      )
    )



SID_LIST_RMAN =
(SID_LIST=
        (SID_DESC=
                (SID_NAME=RMAN)
                (ORACLE_HOME=/u01/app/oracle)
        )
)


INBOUND_CONNECT_TIMEOUT_listener=0

SID_LIST_PRODUCAO =
  (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = primary)
      (ORACLE_HOME = /u01/app/oracle)
      (SID_NAME = PRODUCAO)
    )
  )

SID_LIST_STANDY =
    (SID_LIST =
      (SID_DESC =
        (GLOBAL_DBNAME = standy)
        (ORACLE_HOME = /u01/app/oracle)
        (SID_NAME = STANDY)
    )
   )

tnsname servidor 1:
PRODUCAO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = primary)
      (SERVER = DEDICATED)
    )
  )

STANDY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.20)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = standy)
      (SERVER = DEDICATED)
    )
  )

##################################################################
# Servidor de Backup                                             #
##################################################################
RMAN =
(DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS =
   (PROTOCOL = TCP)
   (HOST = 10.0.0.10)
   (PORT = 1523)
  )
 )
 (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = RMAN)
 )
)

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Listener servidor 2:

PRODUCAO =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10) (PORT = 1521))
     )
    )
  )

STANDY =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.20)(PORT = 1522))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = STANDY)
      )
    )


INBOUND_CONNECT_TIMEOUT_listener=0

SID_LIST_PRODUCAO =
  (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = primary)
      (ORACLE_HOME = /u01/app/oracle)
      (SID_NAME = PRODUCAO)
    )
  )

SID_LIST_STANDY =
    (SID_LIST =
      (SID_DESC =
        (GLOBAL_DBNAME = standy)
        (ORACLE_HOME = /u01/app/oracle)
        (SID_NAME = standy)
     )
     )


tnsnames servidor 2:


PRODUCAO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = producao)
      (SERVER = DEDICATED)
    )
  )

STANDY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.20)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = standy)
      (SERVER = DEDICATED)
    )
  )

##################################################################
# Servidor de Backup                                             #
##################################################################
RMAN =
(DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS =
   (PROTOCOL = TCP)
   (HOST = 10.0.0.10)
   (PORT = 1523)
  )
 )
 (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = RMAN)
 )
)

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )



Desde já agradeço a ajuda de todos.

Att.
Marcelo Procksch

2009/6/10 Caio Spadafora <[email protected]>:
>
>
> Marcelo,
>
> Você consegue nos passar os erros que estão ocorrendo para o Redo Shipping
> não estar ocorrendo?
>
> Sugiro você analisar o alert e a visão V$DATAGUARD_STATUS. Analisando por um
> tempo essas duas fontes é possível identificar o que pode estar ocorrendo,
> lógico assumindo que os parâmetros estão corretamente configurados.
>
> Somente para salientar você está trabalhando em um cenário sem suporte,
> tanto no que diz respeito a sistema operacional quanto ao seu ambiente
> virtual.
>
> Fico no aguardo,
> Atenciosamente,
> Caio Spadafora.
> http://0011brothers.blogspot.com/
>
> --- Em qua, 10/6/09, Marcelo Procksch <[email protected]> escreveu:
>
> De: Marcelo Procksch <[email protected]>
> Assunto: Re: [oracle_br] Ajuda com Dataguard
> Para: [email protected]
> Data: Quarta-feira, 10 de Junho de 2009, 9:16
>
> Obrigado Marcos e Anderson pelas respostas.
>
> Fiz o standby controlfile e subi a base, mas ainda não está
>
> replicando, vou rever os passos com o link que o Anderson mandou e
>
> qualquer novidade enviou novamente.
>
> mais uma vez obrigado!
>
> Att.
>
> Marcelo Procksch
>
> 2009/6/9 Anderson Santiago <anderson_santiago@ yahoo.com. br>:
>
>>
>
>>
>
>> Marcelo,
>
>>
>
>> acho que pode ter faltado algum detalhes, fiz um tutorial sobre como criar
>> o
>
>> standby(dataguard) passo a passo e tudo testado, se seguir os passos
>> levando
>
>> em consideração o sistema operacional, nao tem erro, segue o link.
>
>>
>
>> www.ruevers. webs.standby. html
>
>>
>
>> Att.
>
>>
>
>> Anderson
>
>> DBA Sênior
>
>> www.ruevers. webs.com
>
>>
>
>> ____________ _________ _________ __
>
>> De: Marcelo Procksch <marceloprocksch@ gmail.com>
>
>> Para: oracle...@yahoogrup os.com.br
>
>> Enviadas: Terça-feira, 9 de Junho de 2009 13:40:00
>
>> Assunto: [oracle_br] Ajuda com Dataguard
>
>>
>
>> Amigos
>
>>
>
>> Boa Tarde!
>
>>
>
>> Estou com algumas dúvidas, gostaria que me ajudassem.
>
>>
>
>> Eu estou tentando criar um ambiente dataguard de teste para logo mais
>
>> implantar no meu ambiente de producão.
>
>>
>
>> Criei um ambiente teste com duas VMs com oracle 10g - 10.2.0.1.0
>
>> estou usando o sistema operacional CENTOS 5.2 32bits.
>
>> estou com duas instancias criadas no "servidor 1" , a base que quero
>
>> fazer o dataguard "PRIMARIA" e outra com o catalogo do "Rman" que já
>
>> está fazendo o backup da base "Primaria". O servidor 2 vai receber a
>
>> copia da base Primaria e vai ser tornar a base
>
>> secundaria "STANDBY" que vai receber a cópia via dataguard.
>
>>
>
>> Eu segui os passos do seguinte link:
>
>> http://imasters. uol.com.br/ artigo/5535/ oracle/data_ guard_na_
>> versao_10g_
>
>> release_2_ 102_-_parte_ 01/
>
>>
>
>> Bom estava indo legal até fazer a cópia da base, pois fiz a copia da
>
>> base pelo Rman restaurei no servidor 2 subiu tudo certo, mas o
>
>> standby controlfile deu erro dizendo que não é compativel com o
>
>> datafile system.
>
>>
>
>> No link a copia da base é com o comando CP do linux.
>
>>
>
>> Alguém sabe me dizer como faço a copia da base primaria pelo RMAN e
>
>> criar o standby database com o controlfile de standby com o RMAN?
>
>>
>
>> Desde já Agradeço
>
>>
>
>> Att.
>
>> Marcelo E. Procksch
>
>>
>
>> Veja quais são os assuntos do momento no Yahoo! +Buscados
>
>> http://br.maisbusca dos.yahoo. com
>
>>
>
>> [As partes desta mensagem que não continham texto foram removidas]
>
>>
>
>>
>
>
>
>
>
>
>
>
>
>
>
> Veja quais são os assuntos do momento no Yahoo! +Buscados
> http://br.maisbuscados.yahoo.com
>
> [As partes desta mensagem que não continham texto foram removidas]
>
> 

Responder a