Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Checkpoint - v$datafile_header
A log switch starts a check point which takes time to complete.
The only constraint is that the check point should be completed before
the old log is re-written.
So a log switch starts only a slow checlpoint, so it takes time before
it completes.
A log file switch struck coverts this slow checkpoint to a fast one.
A fast checkpoint is done when you give a command like
ALTER SYSTEM CHECKPOINT LOCAL;
ALTER TABLESPACE .... BEGIN BACKUP;
ALTER TABLESPACE .... OFFLINE;
There are several types checkpoints like FAST, SLOW, GLOBAL, LOCAL
For more info you can see the BACKUP and RECOVERY book from ORACLE
PRESS.
Received on Thu Aug 08 2002 - 23:37:06 CDT