First page Back Continue Last page Graphics
SRR Architectural Changes...
LOG_ARCHIVE_FORMAT
- Name includes “%r”
- RESETLOGS identifier
- Keeps it unique from logs created by another incarnation
V$ARCHIVED_LOG new column
Notes:
Obviously, there are some architecture changes required to support the simplified recovery through resetlogs. In essence, what Oracle 10g needs to do is keep track of each incarnation and be able to determine what recovery-related files belong to each incarnation. To do this, Oracle 10g implements the following changes:
The LOG_ARCHIVE_FORMAT parameter (which controls the name of the archive log) must include a new variable, “%r”. The %r variable provides an incarnation identifier (Oracle calls it a “resetlogs identifier”). %r insures that the archive log name is unique if a new incarnation of the database is created. (Other items in the archive log name typically include %t (thread) and %s (sequence number) which can be redundant across incarnations because the sequence number is reset to 0 by RESETLOGS.)
V$ARCHIVED_LOG view contains a new column, RESETLOGS_ID, that contains the resetlogs identifier.
Architecture changes continued on the next slide…