Ramin Hossaini (blog)

Oracle: Forcing a checkpoint

A checkpoint makes sure that all changes to the database (that are still in buffers) are written to the datafiles.

1
2
3

SQL> ALTER SYSTEM CHECKPOINT;
 
SYSTEM altered.

Related posts:

1. Oracle: Recovering a Tablespace
2. Backing up an Oracle database without RMAN
3. Listing key Oracle Database files
4. Oracle: Basic user-logon auditing
5. Turning Archive-log mode on and off