Advanced Topics › Control and Checkpoint File Considerations › How You Migrate to a New Control File › Migrate to a New Checkpoint File

Migrate to a New Checkpoint File

You use the MIGRATE command to migrate to a new checkpoint file.

To switch to a new checkpoint file

1. Issue the following command to view the list of available checkpoint file IDs:

   DISPLAY FILES
   

2. Issue the following command

   MIGRATE CHKPTFILE=nn
   

   nn

   Specifies the checkpoint file ID of the new checkpoint file

   For example, to switch from the current checkpoint file to checkpoint file 01, issue the following command:

   MIGRATE CHKPTFILE=01
   

   All checkpoint information is now stored on the checkpoint file 01.

To migrate to the next available checkpoint file

Issue the following command:

MIGRATE CHKPTFILE