RMAN Backup Causes Change Attribute Of Stat Command Updated For Password File (Doc ID 2219318.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Running RMAN backup Or a simple select query on v$pwfile_users cause the password file to  be updated as shown below.

 

The stat command cause the access & change attribute to be updated. It is understood that access attribute to be updated when accessing password file because of the select query being run on v$pwfile_users view by RMAN as every connection by the RMAN session to take a backup will internally connect as sys user.

However it is surprising to see the change attribute also gets updated.

Changes

 Running RMAN backup or Select on v$pwfile_users view

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms