Question on Oracle Dynamic View
Whenever a database is been brought into mounted state , still we can able to view some of the Oracle Dynamic View such as V$instance.etc but when a database enters into a Mount state the instance gets started and control file is opened. The control file is read (but it's contents are not validated ) plus data file is not yet open.Then How come still we are able to see the Dynamic View of the database in mount and no mount stage.
Thanks in advance..
When you do a start up mount the only views that are available are c structures. Information that is provided by the pfile/spfile. When the database is in mount mode there are additional view available based on the information that is in the control file. At this time the existence of and contents of the control files are read and validated. i.e. are the control files corrupt. Then when you open the database the data and temp files are read and Oracle makes sure that all of the data and temp files are valid and in sync at the same SCN number. So most of what you said is true.
c structures are data structures that don't rely on the data in the data files, hence they are considered to be statics and don't get stored with the data files.
this space intentionally left blank
Thanks for the clarification. Gandolf
It really helped...
Click Here to Expand Forum to Full Width