What are CREATOR and REGISTRAR in the V$ARCHIVED_LOG view?
Environment: Oracle 11.2.0.3 EE on Solaris 10.5
I'm not sure exactly where this question belongs since it deals with database processes, RMAN and Data Guard all in one so I'll start here and see where it takes me.
I have a Data Guard environment set up with 1 primary and 1 standby. I am running some queries against the V$ARCHIVED_LOG view to understand the view so I can better monitor the archive log activity between the databases.
I have read the documentation but am still confused over a couple of things:
1- What is the FGRD process and how can it write archive logs as seen in the CREATOR column of the view looking from the primary side? I thought only the ARCn process could do that.
2- On the standby side all the logs have LGWR as the CREATOR which makes sense since, as I understand it, the LGWR process on the primary is sending the log files to the standby via SQL*Net. I realize this is not a question. :-)
3- The documentation for the view shows RMAN as a possible value for the CREATOR column. How and where does RMAN create an archive log file?
4- Finally, for now, what is the meaning of the REGISTRAR column? What exactly is it registering since we already know the source (CREATOR), status and whether the log has been archived, applied and deleted.
Thanks very much for any light you can shed in my darkness.
-gary