sanjayktiwari

 Profile Answers by sanjayktiwari 

• Jun 14th, 2006

 

Question is incomplete

Mohammed Abdul Afroze

• Nov 20th, 2007

 

Checkpoint automatically occurs at:

1.Checkpoint automatically occurs at a log switch.
2.When we will specify the parameter fast_start_mttr_target=<No of Seconds>.
3.When Normally forced by the Database Administrator.
4.If the datafile is offline checkpoint will occur.

ianilreddy

 Profile Answers by ianilreddy 

• Aug 7th, 2010

 

At logswitch occur
fast_start_mttr_target
manually alter system checkpoint
When we made the database begin backup mode.

dbxplorer

 Profile Answers by dbxplorer 

• Jul 6th, 2012

 

Checkpoint occurs on below triggers:
- Redo log switch occurs.
- When active redo log is to be written.
- Manually checkpoint is triggered.
- On consistent shutdown of database.
- If MTTR is enabled by setting parameter "FAST_START_MTTR_TARGET".
- Partial checkpoint occurs, while taking the datafile offline or read-only.

Thanks,