Índice do fórum Treinamentos Avançados Treinamento Oracle Data Guard Redo não é aplicado ao physical standby

Redo não é aplicado ao physical standby

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Data Guard.

Mensagem Sáb Out 17, 2015 6:25 pm

Mensagens: 0
Não consigo identificar, mas meus redos não estão sendo aplicados do primary para o physical stby.

Minhas configurações são as seguintes:

PRIMARY:
hostname: marte
Instancia: ORCLP

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string DG_CONFIG=(ORCLP,ORCLSTB)
log_archive_dest string
log_archive_dest_1 string LOCATION=/home/oracle/backup_p
rimary/ VALID_FOR=(ALL_LOGFILE
S,ALL_ROLES) DB_UNIQUE_NAME=OR
CLP
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=ORCLSTB ASYNC VALID_FO
R=(ONLINE_LOGFILES,PRIMARY_ROL
E) DB_UNIQUE_NAME=ORCLSTB



log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable

SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string ORCLP
db_unique_name string ORCLP
global_names boolean FALSE
instance_name string ORCLP
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string ORCLP

SQL> show parameter fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_optimizer_false_filter_pred_pullup boolean TRUE
fal_client string
fal_server string ORCLSTB


Listener

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=marte.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 17-OCT-2015 14:48:17
Uptime 0 days 0 hr. 24 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/marte/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=marte.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "ORCLP" has 1 instance(s).
Instance "ORCLP", status READY, has 1 handler(s) for this service...
Service "ORCLPXDB" has 1 instance(s).
Instance "ORCLP", status READY, has 1 handler(s) for this service...
The command completed successfully

TNSPING:

[oracle@marte ~]$ tnsping ORCLSTB

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 17-OCT-2015 15:13:29

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = saturno.localdomain)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCLSTB)(UR=A)))
OK (30 msec)
[oracle@marte ~]$ tnsping ORCLP

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 17-OCT-2015 15:13:31

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = marte.localdomain)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCLP)(UR=A)))
OK (0 msec)


Local dos archives

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/backup_primary/
Oldest online log sequence 652
Next log sequence to archive 656
Current log sequence 656


STANDBY
hostname: saturno
Instancia: ORCLSTB

log_archive_config string DG_CONFIG=(ORCLP,ORCLSTB)
log_archive_dest string
log_archive_dest_1 string LOCATION=/home/oracle/backup_s
tb VALID_FOR=(ALL_LOGFILES,ALL
_ROLES) DB_UNIQUE_NAME=ORCLSTB
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=ORCLP ASYNC VALID_FOR=
(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ORCLP

log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable


SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string ORCLP
db_unique_name string ORCLSTB
global_names boolean FALSE
instance_name string ORCLSTB
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string ORCLSTB


Listener:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 17-OCT-2015 15:13:24
Uptime 0 days 0 hr. 3 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/saturno/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=saturno.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "ORCLSTB" has 1 instance(s).
Instance "ORCLSTB", status READY, has 1 handler(s) for this service...
The command completed successfully


Tnsping

[oracle@saturno ~]$ tnsping ORCLP

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 17-OCT-2015 15:16:51

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = marte.localdomain)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCLP)(UR=A)))
OK (0 msec)
[oracle@saturno ~]$ tnsping ORCLSTB

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 17-OCT-2015 15:16:54

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = saturno.localdomain)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCLSTB)(UR=A)))
OK (0 msec)

Local dos archives

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/backup_stb
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0


No standby temos:

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY WHERE CLIENT_PROCESS='LGWR' OR PROCESS='MRP0';

CLIENT_P PROCESS THREAD# SEQUENCE# STATUS
-------- --------- ---------- ---------- ------------
N/A MRP0 1 638 WAIT_FOR_LOG


No PRIMARY

SQL> select max(sequence#) from v$log;

MAX(SEQUENCE#)
--------------
656



No alert do PRIMARY tenho os erros:


Error 1033 received logging on to the standby
Sat Oct 17 15:21:07 2015
Errors in file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_tt00_3957.trc:
ORA-01033: ORACLE initialization or shutdown in progress
Error 1033 for archive log file 2 to 'ORCLSTB'
Sat Oct 17 15:21:07 2015
Errors in file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_tt00_3957.trc:
ORA-01033: ORACLE initialization or shutdown in progress
Sat Oct 17 15:21:07 2015
Errors in file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_tt00_3957.trc:
ORA-01033: ORACLE initialization or shutdown in progress
Sat Oct 17 15:21:07 2015
Error 1033 received logging on to the standby
Sat Oct 17 15:21:07 2015
Errors in file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_arc3_3955.trc:
ORA-01033: ORACLE initialization or shutdown in progress
FAL[server, ARC3]: Error 1033 creating remote archivelog file 'ORCLSTB'
ARC3: FAL archive failed with error 1033. See trace for details


Olhando as traces ele me retorna a seguinte mensagem:


OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'

*** 2015-10-17 15:21:06.047
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'

*** 2015-10-17 15:21:07.073
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1033 and errmsg is 'ORA-01033: ORACLE initialization or shutdown in progress
'
*** 2015-10-17 15:21:07.099394 4929 krsh.c
Error 1033 received logging on to the standby
*** 2015-10-17 15:21:07.099413 2958 krsu.c
Error 1033 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ORCLSTB'
krsi_verify_network: Error 1033 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ORCLSTB'
ORA-01033: ORACLE initialization or shutdown in progress
*** 2015-10-17 15:21:07.099741 4929 krsh.c
Error 1033 for archive log file 2 to 'ORCLSTB'
*** 2015-10-17 15:21:07.099770 6944 krsi.c
krsi_dst_fail_caller: dest:2 err:1033 force:0 blast:1
ORA-01033: ORACLE initialization or shutdown in progress
ORA-01033: ORACLE initialization or shutdown in progress


Já no STBY eu tenho


FAL[client, ARC3]: Error 12514 connecting to ORCLP for fetching gap sequence
Sat Oct 17 15:09:47 2015
Errors in file /u01/app/oracle/diag/rdbms/orclstb/ORCLSTB/trace/ORCLSTB_arc3_2641.trc:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Sat Oct 17 15:10:47 2015
ARC1: Becoming the active heartbeat ARCH
Sat Oct 17 15:17:55 2015
alter database mount standby database
ORA-1100 signalled during: alter database mount standby database...
alter database recover managed standby database disconnect from session
Sat Oct 17 15:18:17 2015
Attempt to start background Managed Standby Recovery process (ORCLSTB)
Starting background process MRP0
Sat Oct 17 15:18:17 2015
MRP0 started with pid=28, OS id=2693
Sat Oct 17 15:18:17 2015
MRP0: Background Managed Standby Recovery process started (ORCLSTB)
Sat Oct 17 15:18:22 2015
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Sat Oct 17 15:18:23 2015
Waiting for all non-current ORLs to be archived...
Sat Oct 17 15:18:23 2015
All non-current ORLs have been archived.
Media Recovery Waiting for thread 1 sequence 638
Completed: alter database recover managed standby database disconnect from session



Não compreendo o porque dele dizer que tenho a senha errada, copie o arquivo de senha do PRIMARY para o STBY e ele continua acusando erro.

Além de que se tento realizar um duplicate ocorre o seguinte:

[oracle@marte ~]$ rman TARGET sys/oracle AUXILIARY=sys/oracle@ORCLSTB

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Oct 17 15:24:49 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCLP (DBID=3673457665)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied



Consegue me dizer aonde estou comendo bola?


Mensagens: 0
Faltou o fal server do stby

SQL> show parameter fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string
fal_server string ORCLP


Mensagens: 0
Não perca seu tempo me respondendo Portilho.
Eu, com minha vasta inteligência, copiei o arquivo de senha do PRIMARY para o STB e não o remonei... :oops:

portilho Site Admin

Mensagens: 482
Poxa, esta estava fácil também! :-D


Voltar para Treinamento Oracle Data Guard

cron