问题描述
12c之后的版本，当通过alter user sys方式修改密码后，又通过orapwd重建的密码文件(与原来的密码版本不同),会同步修改SYS密码这个操作，在备库应用时由于密码版本不同而报错,MRP终止。
oerr ora 46952
46952, 00000, “standby database format mismatch for password file ‘%s’”
// *Cause: An attempt was made to apply password file changes made on the
// primary database to the password file of the standby database,
// but there was a password file format mismatch which prevented
// the operation.
// *Action: Re-create the password file on the standby database using the
// same password file format as that of the primary database.
// Ensure that the password file format used on the standby database
// matches that of the primary database.
解决方法
可以将备库密码文件删除，然后等同步过去后，重新从主库复制密码文件。
报划日志
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
MRP0 (PID:21119): Managed Standby Recovery starting Real Time Apply
Stopping change tracking
2021-12-23T13:45:55.753640+08:00
MRP0 (PID:21119): Media Recovery Log /oracle/standbyarch/arch_1085827577_1_32.arc
MRP0 (PID:21119): MRP0: Background Media Recovery terminated with error 46952
2021-12-23T13:45:55.775992+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21119.trc:
ORA-46952: standby database format mismatch for password file ‘/oracle/app/oracle/dbhome19c/dbs/orapwstby’
MRP0 (PID:21119): Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
rm orapw文件后报错日志，但不影响MRP RECOVER
2021-12-23T13:48:12.346861+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21434.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2021-12-23T13:48:12.347828+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21434.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2021-12-23T13:48:12.348750+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21434.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2021-12-23T13:48:12.348986+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21434.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2021-12-23T13:48:12.350033+08:00
Errors in file /oracle/app/oracle/diag/rdbms/stby/stby/trace/stby_mrp0_21434.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
