Password file difference is one of the
biggest causes of log shipping failure from primary database to the standby.
Follow this
document to resolve ORA-1619. Following is what would appear in the
alert log file if log shipping fails because of password file differences
between primary site and standby site.
Check
that the primary and standby are using a password file
and
remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and
that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[server,
ARC0]: FAL archive failed, see trace file.
ARCH:
FAL archive failed. Archiver continuing
ORACLE
Instance MYDB - Archival Error. Archiver continuing.
Wed
Jul 04 22:43:58 2018
Archived
Log entry 1282972 added for thread 1 sequence 225290 ID 0xbfe6d35e dest 1:
Wed
Jul 04 22:44:11 2018
Error
1017 received logging on to the standby
------------------------------------------------------------
Check
that the primary and standby are using a password file
and
remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and
that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[server,
ARC1]: FAL archive failed, see trace file.
ARCH:
FAL archive failed. Archiver continuing
ORACLE
Instance MYDB - Archival Error. Archiver continuing.
Wed
Jul 04 22:49:37 2018
Thread
1 advanced to log sequence 225292 (LGWR switch)
Current log# 4 seq# 225292 mem# 0:
+REDO1/mydb/onlinelog/group_4.260.814774489
Current log# 4 seq# 225292 mem# 1:
+REDO2/mydb/onlinelog/group_4.259.814774513
Wed
Jul 04 22:49:38 2018
******************************************************************
LGWR:
Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Wed
Jul 04 22:49:38 2018
Archived
Log entry 1282987 added for thread 1 sequence 225291 ID 0xbfe6d35e dest 1:
Error
1017 received logging on to the standby
------------------------------------------------------------
Check
that the primary and standby are using a password file
and
remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and
that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors
in file /u01/oracle/base/diag/rdbms/mydb/MYDB/trace/MYDB_nsa2_51031.trc:
ORA-16191:
Primary log shipping client not logged on standby
Wed
Jul 04 22:50:40 2018
Error
1017 received logging on to the standby
------------------------------------------------------------
Check
that the primary and standby are using a password file
and
remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and
that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Wed
Jul 04 22:56:42 2018
Error
1017 received logging on to the standby
------------------------------------------------------------
Check
that the primary and standby are using a password file
and
remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and
that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Wed
Jul 04 22:57:44 2018
Thread
1 advanced to log sequence 225293 (LGWR switch)
Current log# 5 seq# 225293 mem# 0:
+REDO1/mydb/onlinelog/group_5.261.814774529
Current log# 5 seq# 225293 mem# 1:
+REDO2/mydb/onlinelog/group_5.260.814774545
|
No comments:
Post a Comment