5. Determine the location of the online redo logfile members, and their size. As the size is an attribute of the group, not the members, you will have to join two views:
select m.group#,m.member,g.bytes from v$log g join v$logfile m
on m.group#=g.group# order by m.group#,m.member;
Two-Minute Drill
Describe the Stages of Database Startup and Shutdown
• The stages are NOMOUNT, MOUNT, and OPEN.• NOMOUNT mode requires a parameter file.• MOUNT mode requires the controlfile.• OPEN mode requires the datafiles and online redo logfiles.
Set Database Initialization Parameters
• Static parameters cannot be changed without a shutdown/startup.• Other parameters can be changed dynamically, for the instance or a session.• Parameters can be seen in the dynamic performance views V$PARAMETER and V$SPPARAMETER.
Use the Alert Log and Trace Files
PART I• The alert log contains a continuous stream of messages regarding critical operations.• Trace files are generated by background processes, usually when they encounter errors.
Use Data Dictionary and Dynamic Performance Views
• The dynamic performance views are populated from the instance and the controlfile.• The data dictionary views are populated from the data dictionary.• Dynamic performance views accumulate values through the lifetime of the instance, and are reinitialized at startup.• Data dictionary views show information that persists across shutdown and startup.• Both the data dictionary views and the dynamic performance views are published through synonyms.
Self Test
