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 and later
Information in this document applies to any platform.


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.


 Running RMAN backup or Select on v$pwfile_users view


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