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