Controlfileredolog - Redo Logs and Control Files Control Files Database Name names/locations of data file and online redo files T.S names timestamp

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Redo Logs and Control Files Control Files: Database Name, names/locations of data file and online redo files, T.S. names, timestamp of D.B. creation, current log sequence number, checkpoint information, log history. SELECT name from v$controlfile; SELECT type, records_total FROM V$CONTROLFILE_RECORD_SECTION WHERE type=’DATAFILE’; Multiplexing Control Files: using CONTROL_FILES initialization parameter. Online Redo Groups: Minimizes lost of data by creating by using redo log files while during recovery. Recover committed data that is not written to data files. Each online redo log file is an online redo log group is called an online redo log member. Redo Log Members: Identical Log sequence member: assigned by the oracle server Same size for each online redo log member Parameters: MAXLOGFILES- maximum number of online redo log groups. MAXLOGMEMBERS- maximum number of online redo log members for every group. LOG_FILES- decreases max. number of groups of online redo log files for the current
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.

Page1 / 3

Controlfileredolog - Redo Logs and Control Files Control Files Database Name names/locations of data file and online redo files T.S names timestamp

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online